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
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.
SetAllMembers	Sets all members to true or false

Properties

Name	Description
Borders	Cell borders.
Font	Cell Font.
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.
HasOnlyBorders	Returns true if the format definition contains only borders.
Hidden	Cell is Hidden.
Indent	Indent value. (on characters)
IsEmpty	Returns true if the format does not apply any setting.
Locked	Cell is locked.
Lotus123Prefix	Lotus 123 compatibility prefixes.
ParentStyle	Parent style. This is the parent style name and all the properties that are linked to it.
ReadingOrder	Reading order.
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.
ShrinkToFit	Shrink to fit.
VAlignment	Vertical align on the cell.
WrapText	Cell wrap.