TextTableCell

This class represents a cell of a table.

Properties

Application through getApplication

BackColor through getBackgroundColor and setBackgroundColor

BackTransparent through isBackTransparent and setBackTransparent

Formula through getFormula and setFormula

Name through getName

Protected through isProtected and setProtected

Range through getRange

Text through getText and setText

Value through getValue and setValue

Methods

borders

Access
To get a cell of a table, use:

Usage

TextTableCell provides access to the range, text, and value of a cell.

To automatically calculate the value for a cell, use the Formula property.

To protect the cell from being modified by users, use the Protected property.

The value of a cell can be a string value or a double value. The property Text is used to set the string value for a cell. The property Value is used to set the double value for a cell. The value for the Text property and Value property can overwrite each other's value.
  • When you set the value for the Text property, the value of the Value property is the numeric conversion value of the Text property's value.
  • When you set the value for the Value property, the value of the Text property is the string conversion value of the Value property's value.
For example, if we set the Text property's value as Test, the Value property's value is 0; if we set the Value property's value as 26.7, the Text property's value is 26.7.
See examples

Example in TextTable

Example in TextTableCells