Column Calculation in FlexGrid

GridExpressionColumn enables modify expressions directly within grid cells. Users can modify expressions at run time using the column header options menu, making data calculations flexible and interactive without requiring changes to the underlying data source. GridExpressionColumn is added as build-in column type for FlexGrid and it has its own set of properties and events. It supports two modes:

• Cell-level evaluation: Each cell can contain its own editable expression

• Column-level evaluation: Entire column uses a single shared expression

Expressions can be changed at run time using the column header options menu or each GridExpressionColumn can define its own ExpressionEngine, EvaluationMode, and can subscribe to events such as:

• EngineChanged

• ExpressionChanged

• EvaluationModeChanged

Sample Usage

<c1:GridExpressionColumn Binding="OrderTotal" EvaluationMode="CellEvaluation" Header="Calculated Exp." Expression="OrderTotal*5">
  <c1:GridExpressionColumn.Engine>
    <c1:C1ExpressionEngine Expression="2*OrderTotal"/>
  </c1:GridExpressionColumn.Engine>
</c1:GridExpressionColumn>