Defines which attributes of a TFlxFormat will be applied for one cell.
Whatever member is set to false, it will not apply this member property to the cell.
Syntax
Unit: FlexCel.Core
TFlxApplyFormat = record;
Fields
Methods
| Name |
Description |
| Create |
Creates an empty Format class.
|
| SetAllMembers |
Sets all members to true or false |
| Apply |
This method will modify existingFormat with the properties from newFormat that are specified on this class |
| Clone |
Returns a deep copy of the format.
|
Operators
| Name |
Description |
| Equality |
Adapts the = operator so it returns true when both instances have the same values. |
| Inequality |
Adapts the <> operator so it returns true when both instances have different values. |
Properties
| Name |
Description |
| Format |
Format string. (For example, "yyyy-mm-dd" for a date format, or "#.00" for a numeric 2 decimal format)
This format string is the same you use in Excel under "Custom" format when formatting a cell, and it is documented in Excel documentation. Under "Finding out what format string to use in TFlxFormat.Format" section in UsingFlexCelAPI.pdf you can find more detailed information on how to create this string.
|
| HAlignment |
Horizontal align on the cell.
|
| VAlignment |
Vertical align on the cell.
|
| Locked |
Cell is locked.
|
| Hidden |
Cell is Hidden.
|
| ParentStyle |
Parent style. This is the parent style name and all the properties that are linked to it.
|
| WrapText |
Cell wrap.
|
| ShrinkToFit |
Shrink to fit.
|
| Rotation |
Text Rotation in degrees.
When this value is from 0 to 90 then this is the rotation degrees in the up direction.
When this value is from 91 to 180 then this is a rotation in the down direction. 91 means -1 degree rotation, 92 means -2 degrees, and so on until 180 which means -90 degrees.
255 is vertical text.
Other values are invalid.
|
| Indent |
Indent value. (on characters) |
| ReadingOrder |
Reading order.
|
| Lotus123Prefix |
Lotus 123 compatibility prefixes.
|
| IsEmpty |
Returns true if the format does not apply any setting.
|
| HasOnlyBorders |
Returns true if the format definition contains only borders.
|