The XFProtection Object

class XFProtection

A collection of the protection-related attributes of an XF record. Items correspond to those in the Excel UI’s Format/Cells/Protection tab.

Note

the OOo docs include the “cell or style” bit in this bundle of attributes. This is incorrect; the bit is used in determining which bundles to use.

• New in version 0.6.1

XFProtection.cell_locked

1 = Cell is prevented from being changed, moved, resized, or deleted (only if the sheet is protected).

XFProtection.formula_hidden

1 = Hide formula so that it doesn’t appear in the formula bar when the cell is selected (only if the sheet is protected).