Table of Contents

TFlxApplyFormat Record

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

Name Description
FillPattern Fill pattern.
Font Cell Font.
Borders Cell borders.

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.