Syncfusion.Grid.Windows
Members 


Syncfusion.Windows.Forms.Grid Namespace : GridFormulaCellRenderer Class

GridFormulaCellRenderer Class

Implements a GridCellRender that supports formulas.
Object Model
GridFormulaCellRenderer ClassGridCurrentCell ClassGridStyleInfo ClassGridCellButton ClassIGridDropDownContainer InterfaceIGridDropDownCellImp InterfaceIGridDropDownCellImp InterfaceGridControlBase ClassGridCellModelBase ClassGridStyleInfo Class
Syntax
Remarks
See GridFormulaCellModel for a discussion about formula engine and customization.

The following table lists some characteristics about the FormulaCell cell type:

Item Description
CellType FormulaCell
Renderer GridFormulaCellRenderer
Model GridFormulaCellModel
XP Themes Support NA
Interactive Edit with Text and Formula Input
Control GridTextBoxControl
Floating Support Both
Base Type GridTextBoxCellRenderer

The cell's behavior and appearance can be customized with the following properties of the GridStyleInfo class:

PropertyName Description
GridStyleInfo.AllowEnter (System.Boolean) Gets / sets if pressing the <Enter>-Key should insert a new line into the edited text. (Default: False)
GridStyleInfo.AutoSize (System.Boolean) Gets / sets if the cell height should automatically increase when the edited text does not fit into the cell and GridStyleInfo.WrapText is True. If GridStyleInfo.WrapText is False, GridStyleInfo.AutoSize will affect the column width. (Default: False)
GridStyleInfo.BaseStyle (System.String) The base style for this style instance with default values for properties that are not initialized for this style object. (Default: String.Empty)
GridStyleInfo.Borders (GridBordersInfo) Top, left, bottom, and right border settings. (Default: GridBordersInfo.Default)
GridStyleInfo.CellAppearance (GridCellAppearance) Specifies if cell edges shall be drawn raised, sunken, or flat (default). (Default: GridCellAppearance.Flat)
GridStyleInfo.CellTipText (System.String) ToolTip text to be displayed when user hovers mouse over cell. (Default: String.Empty)
GridStyleInfo.CellType (System.String) FormulaCell (Default: Text Box)
GridStyleInfo.CellValue (System.Object) This property holds the cell value. Although the cell value is typically a string, it can also be any other primitive type such as int, byte, enum, or any custom type that is derived from System.Object. (Default: String.Empty)
GridStyleInfo.CellValueType (System.Type) Specifies the preferred System.Type for cell values. When you assign a value to the GridStyleInfo object, the value will be converted to this type. If the value cannot be converted, GridStyleInfo.Error will contain error information. (Default: NULL)
GridStyleInfo.CultureInfo (System.Globalization.CultureInfo) The culture information holds rules for parsing and formatting the cell's value. (Default: null)
GridStyleInfo.Enabled (System.Boolean) Specifies if the cell can be activated as current cell or if the cell should be skipped when moving the current cell. (Default: True)
GridStyleInfo.Error (System.String) Holds error information if a value could not be converted to the System.Type specified with GridStyleInfo.CellValueType. (Default: String.Empty)
GridStyleInfo.FloatCell (System.Boolean) Gets / sets if text can float into the boundaries of a neighboring cell. (Default: True)
GridStyleInfo.FloodCell (System.Boolean) Gets / sets if this cell can be flooded by a previous cell. (Default: True)
GridStyleInfo.Font (GridFontInfo) The font for drawing text. (Default: GridFontInfo.Default)
GridStyleInfo.Format (System.String) Gets / sets the format mask for formatting the cell value. You can specify numeric format strings, date format strings or enumeration format strings as discussed in the section "Format Specifiers and Format Providers" of the .NET Framework Developers Guide (see ms-help://MS.VSCC/MS.MSDNVS/cpguide/html/cpconformatspecifiersformatproviders.htm) (Default: String.Empty)
GridStyleInfo.FormulaTag (GridFormulaTag) A formula tag that is associated with a cell. (Default: NULL)
GridStyleInfo.HorizontalAlignment (GridHorizontalAlignment) Specifies horizontal alignment of text in the cell. (Default: GridHorizontalAlignment.Left)
GridStyleInfo.HotkeyPrefix (System.Drawing.Text.HotkeyPrefix) Specifies how hot-key prefixes should be displayed. Hot-keys are indicated in text with an '&' (ampersand). When you enable a hot-key prefix, the specific characters can be displayed underlined or regular. The '&' will not be displayed. (Default: HotkeyPrefix.Show)
GridStyleInfo.ImageIndex (System.Int32) Specifies an index for an image in the GridStyleInfo.ImageList of a GridStyleInfo instance. (Default: -1)
GridStyleInfo.ImageList (System.Windows.Forms.ImageList) The GridStyleInfo.ImageList that holds a collection of images. Cells can choose images with the GridStyleInfo.ImageIndex property in a GridStyleInfo instance. (Default: NULL)
GridStyleInfo.Interior (Syncfusion.Drawing.BrushInfo) Lets you specify a solid backcolor, gradient, or pattern style with both back and forecolor for a cell's background. (Default: SystemColors.Window)
GridStyleInfo.MaxLength (System.Int32) Limits the number of characters the user can type into the cell. Note: When selecting a text from a choice list or when pasting text, the text can be longer. Additional validation is necessary on your side. (Default: 0)
GridStyleInfo.MergeCell (GridMergeCellDirection) Specifies merge behavior for an individual cell when merging cells feature has been enabled in a GridModel with GridModelOptions.MergeCellsMode. (Default: GridMergeCellDirection.None)
GridStyleInfo.ReadOnly (System.Boolean) Specifies if cell contents can be modified by the user. You can programmatically change Read-only cells by setting GridModel.DiscardReadOnly to True. (Default: False)
GridStyleInfo.Text (System.String) Gets / sets the value as a string. If a GridStyleInfo.CellValueType is specified, the text will be parsed and converted to the type specified with GridStyleInfo.CellValueType using any GridStyleInfo.CultureInfo information. (Default: String.Empty)
GridStyleInfo.TextColor (System.Drawing.Color) Lets you specify the color for drawing the cell text. (Default: SystemColors.WindowText)
GridStyleInfo.TextMargins (GridMarginsInfo) Holds text margins in pixels. When drawing a cell, this specifies the empty area between the text rectangle and the client rectangle of the cell without borders and cell buttons. (Default: GridMarginsInfo.Default)
GridStyleInfo.Trimming (System.Drawing.StringTrimming) Indicates how text is trimmed when it exceeds the edges of the cell text rectangle. (Default: StringTrimming.Character)
GridStyleInfo.ValidateValue (GridCellValidateValueInfo) Holds validation rules for cell values that are being checked before any user changes are committed to the grid cell's style object. (Default: NULL)
GridStyleInfo.VerticalAlignment (GridVerticalAlignment) Specifies vertical alignment of text in the cell. (Default: GridVerticalAlignment.Top)
GridStyleInfo.VerticalScrollbar (System.Boolean) Specifies if text box should show a vertical scrollbar when text is being edited and does not fit in cell. WrapText must be initialized to True. (Default: False)
GridStyleInfo.WrapText (System.Boolean) Specifies if text should be wrapped when it does not fit into a single line. (Default: True)

Inheritance Hierarchy
AssemblyVersion

Syncfusion.Grid.Windows: 17.1460.0.47

See Also