TFlxApplyFormat Class

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

Namespace: FlexCel.Core

public class TFlxApplyFormat: ICloneable

Fields

Name	Description
FillPattern	Fill pattern.

Constructors

Name	Description
TFlxApplyFormat	Creates an empty Format class.

Methods

Name	Description
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.

Properties

Name	Description
Font	Cell Font.
Borders	Cell borders.
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.