StyleModifyFlag enumeration

StyleModifyFlag enumeration

The style modified flags.

The StyleModifyFlag type exposes the following members:

Fields

FieldDescription
LEFT_BORDERIndicates whether left border has been modified for the style.
RIGHT_BORDERIndicates whether right border has been modified for the style.
TOP_BORDERIndicates whether top border has been modified for the style.
BOTTOM_BORDERIndicates whether bottom border has been modified for the style.
DIAGONAL_DOWN_BORDERIndicates whether diagonal-down border has been modified for the style.
DIAGONAL_UP_BORDERIndicates whether diagonal-up border has been modified for the style.
HORIZONTAL_BORDERIndicates whether horizontal border has been modified for the style.
Only for dynamic style, such as conditional formatting.
VERTICAL_BORDERIndicates whether vertical border has been modified for the style.
Only for dynamic style, such as conditional formatting.
SIDE_BORDERSIndicates the four side borders: StyleModifyFlag.LEFT_BORDER,
StyleModifyFlag.RIGHT_BORDER, StyleModifyFlag.TOP_BORDER and StyleModifyFlag.BOTTOM_BORDER.
DIAGONALIndicates diagonal borders: StyleModifyFlag.DIAGONAL_DOWN_BORDER and StyleModifyFlag.DIAGONAL_UP_BORDER.
DYNAMIC_STYLE_BORDERSIndicates borders of dynamic style: StyleModifyFlag.HORIZONTAL_BORDER and StyleModifyFlag.VERTICAL_BORDER.
BORDERSIndicates whether one or more borders(StyleModifyFlag.LEFT_BORDER,
StyleModifyFlag.RIGHT_BORDER, StyleModifyFlag.TOP_BORDER, StyleModifyFlag.BOTTOM_BORDER,
StyleModifyFlag.DIAGONAL, StyleModifyFlag.HORIZONTAL_BORDER, StyleModifyFlag.VERTICAL_BORDER)
have been modified for the style.
NUMBER_FORMATIndicates whether numberformat has been modified.
HORIZONTAL_ALIGNMENTIndicates whether horizontal alignment has been modified.
VERTICAL_ALIGNMENTIndicates whether vertical alignment has been modified.
INDENTIndicates whether indent property has been modified.
ROTATIONIndicates whether rotation property has been modified.
WRAP_TEXTIndicates whether wrap text property has been modified.
SHRINK_TO_FITIndicates whether shrink to fit property has been modified.
TEXT_DIRECTIONIndicates whether text direction property has been modified.
RELATIVE_INDENTIndicates whether relative indent property has been modified for the style.
Only for dynamic style, such as conditional formatting.
ALIGNMENT_SETTINGSIndicates whether one or more alignment-related properties(StyleModifyFlag.HORIZONTAL_ALIGNMENT,
StyleModifyFlag.VERTICAL_ALIGNMENT, StyleModifyFlag.ROTATION, StyleModifyFlag.WRAP_TEXT,
StyleModifyFlag.WRAP_TEXT, StyleModifyFlag.INDENT, StyleModifyFlag.SHRINK_TO_FIT, StyleModifyFlag.TEXT_DIRECTION,
StyleModifyFlag.RELATIVE_INDENT) have been modified.
PATTERNIndicates whether pattern of the shading has been modified.
FOREGROUND_COLORIndicates whether foreground color has been modified.
BACKGROUND_COLORIndicates whether background color has been modified.
CELL_SHADINGIndicates whether one or more shading-related properties(StyleModifyFlag.PATTERN,
StyleModifyFlag.FOREGROUND_COLOR, StyleModifyFlag.BACKGROUND_COLOR) have been modified.
LOCKEDIndicates whether locked property has been modified.
HIDE_FORMULAIndicates whether hide formula has been modified.
PROTECTION_SETTINGSIndicates whether one or more protection-related properties(StyleModifyFlag.LOCKED,
StyleModifyFlag.HIDE_FORMULA) have been modified.
FONT_SIZEIndicates whether font size has been modified.
FONT_NAMEIndicates whether font name has been modified.
FONT_COLORIndicates whether font color has been modified.
FONT_WEIGHTIndicates whether font weight has been modified.
FONT_ITALICIndicates whether italic property of font has been modified.
FONT_UNDERLINEIndicates whether underline property of font has been modified.
FONT_STRIKEIndicates whether strike property font has been modified.
FONT_SCRIPTIndicates whether subscript or superscript property of font has been modified.
FONT_FAMILYIndicates whether font family has been modified.
FONT_CHARSETIndicates whether charset of the font has been modified.
FONT_SCHEMEunused.
FONT_DIRTYunused.
FONT_SPELLING_ERRORunused.
FONT_U_FILL_TXunused.
FONT_SPACINGunused.
FONT_KERNINGunused.
FONT_EQUALIZEunused.
FONT_CAPunused.
FONT_VERTICAL_TEXT
FONTIndicates whether one or more properties have been modified for the font of the style.
ALLAll properties that can be modified for the style.
NONENo property has been specified.

Remarks

Combinations of multiple properties are defined for user’s convenience. When checking whether they are modified for one style, the returned value denotes whether one or more properties in the combination have been modified.

See Also