[]
        
(Showing Draft Content)

FarPoint.Web.Spread.Cell

Cell Class

Represents a cell in the Spread component.

Inheritance
Cell
Namespace: FarPoint.Web.Spread
Assembly: FarPoint.Web.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.

viewrow

Gets or sets the row start index.

Properties

Name Description
BackColor

Gets or sets the background color for a cell.

Background

Gets or sets the background 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.

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.

EncodeValue

Gets or sets the encode value for a cell.

Font

Gets or sets the font for the text in a cell.

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.

HorizontalAlign

Gets or sets the horizontal alignment of contents for a cell.

ImeMode

Gets or sets the IME mode for a cell.

Locked

Gets or sets whether a cell is marked as locked from editing.

Margin

Gets or sets the settings of the cell margins that define the space between the cell border and the cell contents, for the four sides of the cell.

Note

Gets or sets the note for a cell.

Parent

Gets the parent for this cell.

ParentStyleName

Gets or sets the name of the parent style for a 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.

Value

Gets or sets the value in a cell.

VerticalAlign

Gets or sets the vertical alignment of contents for a 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.

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.

ResetBackground()

Resets the background.

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.

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.

ResetLocked()

Resets the locked state for the cell and makes the cell inherit the locked state from the default cell.

ResetMargin()

Resets the settings of the cell margins that define the space between the cell border and the cell contents, for all the cells in this column.

ResetNote()

Resets the note for the cell to empty.

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.

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.

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.