Create Excel-like formulas for shaping data in ComponentOne controls

Embed the Expression Editor and EditorPanel so users can work with data inside another ComponentOne control, like FlexGrid or DataGrid. The ExpressionEditor can be used separately, as embedded in a custom filter or in the cell of a grid.

Embed the Expression Editor in a grid

Work with many Excel-like, pre-defined operators and functions

Work with many Excel-like, pre-defined operators and functions

Functions include:

  • Aggregate
  • Text
  • Datetime
  • Math
  • Conversions
  • Logical operators

Read your formulas more easily with syntax highlighting

Read your formulas more easily with syntax highlighting

Expression Editor uses different colors to highlight functions and fields, just like the SQL Query editor. As the keywords are automatically highlighted, it increases the readability of expressions which makes it easier to differentiate between functions, operators, and fields. SyntaxHighlighting property of C1ExpressionEditor class controls whether a function or a field should be highlighted in an expression.

Write faster with IntelliSense-like smart code completion

Write faster with IntelliSense-like smart code completion

When you type expressions, Expression Editor completes it by providing recommendations of possible functions or fields in a list based on what you type. This option helps to complete expression quickly and reduces the chance of making typing errors.

Catch formula errors with full error reporting

Catch formula errors with full error reporting

When the expression in Expression TextBox is invalid, you'll immediately see an error in the expression textbox. The IsValid property of C1ExpressionEditor class is used to indicate if an expression is valid or not.

See the details of a function with ToolTip Helper

See the details of a function with ToolTip Helper

Each time the mouse hovers over a function, Expression Editor displays a descriptive tooltip.

Check your work with results preview

Check your work with results preview

Visualize final output and correct possible errors easily before finalizing the expression for a supported control! When you write a valid expression, it displays the result in the preview and displays error for an invalid expression.

Filter results using expressions

Filter results using expressions

Filter a data set in a FlexGrid or FlexChart control using the expressions of your choice. Match on strings, formulas, or other data.