The summary cell displays calculations and results of cell values. You can use the summary cell to define a formula at design time without using code. Calculations are possible in unbound mode when the calculation column of the data source cannot be used.
Features
In addition to the Base Cell features, the following features can also be used in the summary cell.
- Calculation of Any Column (Cell)
- Sum
- Average
- Minimum Value
- Maximum Value
- Value Count
- Calculation Using Operators
- + - * / ()
- Specify whether to calculate hidden row
- User defined formula
For more details on each feature, refer to the SummaryCell class.
Data Types
The summary cell uses the Object type value. This type can be checked with the SummaryCell.ValueType property. The value cast into the String type is used for display. This type can be checked with the SummaryCell.FormattedValueType property. You can modify behavior during casting by overriding the ToString Object type method. You can override the SummaryCell.OnCellFormatting method to modify the behavior when values are read in a cell.
Cell Edit Control
The summary cell does not support the cell edit control. The SummaryCell.EditType property always returns a null reference (Nothing in Visual Basic).
Styles
The summary cell supports the following CellStyle class members. You can set the cell style with the SummaryCell.Style property.
| CellStyle Members | Enabled or Disabled |
|---|---|
| BackColor | Enabled |
| BackgroundGradientEffect | Enabled |
| Border | Enabled |
| DataSourceNullValue | Enabled |
| DisabledBackColor | Enabled |
| DisabledForeColor | Enabled |
| DisabledGradientEffect | Enabled |
| EditingBackColor | - |
| EditingForeColor | - |
| Font | Enabled |
| ForeColor | Enabled |
| Format | Enabled |
| FormatProvider | Enabled |
| Image | Enabled |
| ImageAlign | Enabled |
| ImeMode | - |
| ImeSentenceMode | - |
| InputScope | - |
| LineAdjustment | Enabled only for GDI+ CompatibleMode |
| Margin | Enabled |
| MouseOverBackColor | Enabled |
| MouseOverForeColor | Enabled |
| MouseOverGradientEffect | Enabled |
| Multiline | Enabled |
| NullValue | Enabled |
| Padding | Enabled |
| PatternColor | Enabled |
| PatternStyle | Enabled |
| SelectionBackColor | Enabled |
| SelectionForeColor | Enabled |
| SelectionGradientEffect | Enabled |
| Tag | Enabled |
| TextAdjustment | Enabled only for GDI+ CompatibleMode |
| TextAlign | Enabled |
| TextAngle | Enabled only for GDI+ CompatibleMode |
| TextEffect | Enabled |
| TextImageRelation | Enabled |
| TextIndent | Enabled |
| TextVertical | Enabled only for GDI+ CompatibleMode |
| UseCompatibleTextRendering | Enabled |
| WordWrap | Enabled |
To set GDI+ Compatibility Mode as Enabled, set the UseCompatibleTextRendering property to True.
Shortcut Keys
The summary cell does not process any shortcut keys.
Events
You can use the GcMultiRow.CellContentClick event to implement the processing when clicking in the cell content area. Use the GcMultiRow.CellContentDoubleClick event for a double-click.
Comparison with Standard Control
This cell type does not correspond to a standard control.
See the following topics for more information:
- Show Column Sum in Footer (SummaryCell)
- Displaying an Error Icon for Data Errors (SummaryCell)
- Create Statement of Account (SummaryCell)