Cell Properties
A cell can have additional information that determines the content, font, and format of the data associated with it. This information can be used by client applications to present cell data.
The following table contains a list of supported cell properties with descriptions.
| Property | Description |
|---|---|
| BACK_COLOR | The background color for displaying the VALUE or FORMATTED_VALUE property. For more information, see FORE_COLOR and BACK_COLOR Contents. |
| CELL_EVALUATION_LIST | A semicolon-delimited list of evaluated formulas applicable to the cell, in order from lowest to highest. |
| CELL_ORDINAL | The ordinal number of the cell in the dataset. |
| FORE_COLOR | The foreground color for displaying the VALUE or FORMATTED_VALUE property. For more information, see FORE_COLOR and BACK_COLOR Contents. |
| FONT_NAME | The font to be used to display the VALUE or FORMATTED_VALUE property. |
| FONT_SIZE | Font size to be used to display the VALUE or FORMATTED_VALUE property. |
| FONT_FLAGS | The bitmask detailing effects on the font. It can be the result of a bitwise OR operation of one or more of the following:
|
| FORMAT_STRING | The format string used to create the FORMATTED_VALUE property value.
For more information, see FORMAT_STRING Contents. |
| FORMATTED_VALUE | The character string that represents a formatted display of the VALUE property. |
| VALUE | The unformatted value of the cell. |
In addition to the properties listed in the table, other providers may support provider-specific cell properties. The MDSCHEMA_PROPERTIES schema rowset contains information on supported cell properties, including data types and provider support.
For more information on supported cell properties and their usage, see Using Cell Properties.