DefaultStyleSettings

DefaultStyleSettings class

Settings for the default values of workbook’s style properties.

Properties

NameTypeDescription
BuiltInPreferencebooleanIndicates whether property for number format is preferrable when the style defines both built-in number and custom patte
FontNameStringGets/Sets the default font name for the workbook
FontSizeNumberGets/Sets the default standard font size for the workbook.
HorizontalAlignmentNumberGets/Sets the default value for horizontal alignment The value of the property is TextAlignmentType integer constant.
VerticalAlignmentNumberGets/Sets the default value for vertical alignment The value of the property is TextAlignmentType integer constant.

DefaultStyleSettings.BuiltInPreference property

Indicates whether property for number format is preferrable when the style defines both built-in number and custom pattern. Default value is false, that means by default custom pattern will be used to format values as long as it is not empty for one style. When loading workbook from existing template file, maybe both built-in number and custom pattern are defined for one style. This property determine whether we should use the built-in number or the custom pattern when formatting values with the style.

Type: boolean

DefaultStyleSettings.FontName property

Gets/Sets the default font name for the workbook

Type: String

DefaultStyleSettings.FontSize property

Gets/Sets the default standard font size for the workbook.

Type: Number

DefaultStyleSettings.HorizontalAlignment property

Gets/Sets the default value for horizontal alignment The value of the property is TextAlignmentType integer constant.

Type: Number

DefaultStyleSettings.VerticalAlignment property

Gets/Sets the default value for vertical alignment The value of the property is TextAlignmentType integer constant.

Type: Number