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.