FarPoint.Win.Spread.Cell

Cell Class

Represents a cell in the Spread component.

Inheritance

object

Cell

CellFooter

Namespace: FarPoint.Win.Spread

Assembly: FarPoint.Win.Spread.dll

Syntax

public class Cell

Public Class Cell

Fields

Name	Description
columnField	Gets or sets the model column index.
rowField	Gets or sets the model row index.
viewcolumn	Gets or sets the column start index.
viewcolumn2
viewrow	Gets or sets the row start index.
viewrow2

Properties

Name	Description
BackColor	Gets or sets the background color for a cell.
Border	Gets or sets the border for a cell.
CanFocus	Gets or sets whether the user can set focus to the cell using the keyboard or mouse.
CellPadding	Gets or sets the amount of spaces to pad the cell(s) in pixels.
CellType	Gets or sets the type of cell.
Column	Gets the column that contains this cell.
ColumnSpan	Gets or sets the number of columns spanned by this cell.
Editor	Gets or sets the editor for a cell.
ErrorText	Gets or sets error text for this cell.
Font	Gets or sets the font for the cell text.
ForeColor	Gets or sets the text (foreground) color for a cell.
Formatter	Gets or sets the formatter for a cell.
Formula	Gets or sets the formula in a cell.
FormulaArray	Get/Set array formula for cell range
HorizontalAlignment	Gets or sets the horizontal alignment of the cell contents.
ImeMode	Gets or sets the IME mode for a cell.
ImeSentenceMode	Gets or sets the ImeSentenceMode value for a cell.
InputScope	Gets or sets the input scope for a cell.
LockBackColor	Gets or sets the background color for a locked cell.
LockFont	Gets or sets the font for a locked cell.
LockForeColor	Gets or sets the text (foreground) color for a locked cell.
Locked	Gets or sets whether a cell is marked as locked from editing.
Note	Gets or sets the note for a cell.
NoteIndicatorColor	Gets or sets the color for the note indicator for a cell.
NoteIndicatorPosition	Gets or sets the cell note indicator position for the cell.
NoteIndicatorSize	Gets or sets the size for the note indicator for a cell.
NoteStyle	Gets or sets the note style for a cell.
Parent	Gets the parent for this cell.
ParentStyleName	Gets or sets the name of the parent style for a cell.
ParseFormatInfo	Gets or sets the parsed formatting for the cell.
ParseFormatString	Gets or sets the parsed formatting string for the cell.
Renderer	Gets or sets the renderer for a cell.
Row	Gets the row that contains this cell.
RowSpan	Gets or sets the number of rows spanned by a cell.
Sparkline	Gets or sets the sparkline.
StyleName	Gets or sets the name of the custom style for a cell.
TabStop	Gets or sets whether the user can set focus to the cell using the Tab key.
Tag	Gets or sets an application-defined tag value for a cell.
Text	Gets or sets the formatted text in a cell.
TextIndent	Gets or sets the amount to indent the text in a cell.
Validation	Gets an instance of IValidation which may be used to get and set validation properties of the cells represented by this Cell.
Value	Gets or sets the value in a cell.
VerticalAlignment	Gets or sets the vertical alignment of the cell contents.
VisualStyles	Gets or sets the setting of visual styles (XP themes) for the cell.

Methods

Name	Description
Equals(object)	Determines whether the specified object is equivalent to this cell.
GetDataModel()	Gets the data model for a cell.
GetHashCode()	Gets the hash code of an object.
GroupSparkline(Cell)	Groups the sparkline.
GroupSparkline(CellRange)	Groups the sparkline.
GroupSparkline(int, int)	Groups the sparkline.
Invalidate()	Invalidates the displayed cells and sends the message to repaint them.
IsValid(int, int)	Checks whether the specified view row and column indexes are valid coordinates in the sheet's data model, and if so sets the row and column fields to the model row and column indexes.
ResetBackColor()	Resets the background color for the cell and makes the cell inherit the background color from the default cell.
ResetBorder()	Resets the cell border for the cell and makes the cell inherit the cell border from the default cell.
ResetCanFocus()	Resets to its default value whether the cell can receive focus.
ResetCellPadding()	Resets the cell padding.
ResetCellType()	Resets the cell type for the cell and makes the cell inherit the cell type from the default cell.
ResetFont()	Resets the font for the cell and makes the cell inherit the font from the default cell.
ResetForeColor()	Resets the text (foreground) color for the cell and makes the cell inherit the text color from the default cell.
ResetFormula()	Resets the formula for the cell to empty.
ResetHorizontalAlignment()	Resets the horizontal alignment for the cell and makes the cell inherit the horizontal alignment from the default cell.
ResetImeMode()	Resets the background color for the cell and makes the cell inherit the IME mode from the default cell.
ResetImeSentenceMode()	Resets the ImeSentenceMode property for the cell and makes the cell inherit the ImeSentenceMode value from the default cell.
ResetLockBackColor()	Resets the background color for the locked cell and makes the cell inherit the background color from the default cell.
ResetLockFont()	Resets the font for the locked cell and makes the cell in herit the font from the default cell.
ResetLockForeColor()	Resets the text color for the locked cell and makes the cell inherit the fore color from the default cell.
ResetLocked()	Resets the locked state for the cell and makes the cell inherit the locked state from the default cell.
ResetNote()	Resets the note for the cell to empty.
ResetNoteIndicatorColor()	Resets the color of the cell note indicator to its default value.
ResetNoteIndicatorPosition()	Resets the position of the note indicator.
ResetNoteIndicatorSize()	Resets the size of the note indicator.
ResetNoteStyle()	Resets the note style for the cell and makes the cell inherit the note style from the default cell.
ResetParentStyleName()	Resets the ParentStyleName object for the cell to an empty string.
ResetTabStop()	Resets to its default value whether the user can set focus to the cell using the Tab key.
ResetTag()	Resets the tag for the cell to empty.
ResetText()	Resets the text for the cell to empty.
ResetTextIndent()	Resets the size of the note indicator.
ResetValue()	Resets the value for the cell to empty.
ResetVerticalAlignment()	Resets the vertical alignment for the cell and makes the cell inherit the vertical alignment from the default cell.
ResetVisualStyles()	Resets the setting of visual styles (XP themes) for the cell to the default setting.
ToString()	Gets a string that contains an absolute reference to this cell in the current reference style.
ToString(Cell)	Gets a string that contains a relative reference to this cell in the current reference style.
ToString(Cell, ReferenceStyle)	Gets a string that contains a relative reference to this cell in the specified reference style.
ToString(ReferenceStyle)	Gets a string that contains an absolute reference to this cell in the specified reference style.
UnGroupSparkline(Cell)	Ungroups the group sparkline.
UnGroupSparkline(CellRange)	Ungroups the group sparkline.
UnGroupSparkline(int, int)	Ungroups the sparkline at the specified location if it is in the same group with the current cell.

Cell Class
Fields
Properties
Methods