TAdaptativeFormats Record
Information about characters in a numeric format that need to be adapted when rendering. For example, if the cell A1 has value 1 and format "*_0" it will print as "______1" when the cell is wide, and as "_1" when the cell is shorter.
Syntax
Unit: FlexCel.Core
TAdaptativeFormats = record;
Methods
Name | Description |
---|---|
ApplySeparators | Returns the string with the characters at the positions in Separator changed by the characters specified in Separators. |
AddSeparator | Overloaded AddSeparator(string, Integer) AddSeparator(string, Integer, Integer) |
Mix | This assumes separators in New are all sorted and after separators in old. |
IsNull | Returns true if the record doesn't have a defined value. |
HasValue | Returns true if the record has a defined value. This is the inverse of IsNull |
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 |
---|---|
WildcardPos | Position of the last wildcard ("*") character in the format (0 based). If a wildcard is present in the format, the string has to be expanded with the character at position until it fits the width of the cell. A negative value means there is no wildcard in the format. |
Separators | An array of positions and characters that must be used to pad the string. In this field you have the the "_" and "?" numeric format delimiters from Excel. The spaces at the positions in the position array should have the width of the character specified in this field. If null, there are no separators in this class. |
IsEmpty | Returns true if this class has no adaptative formats. |