2.1.721 Part 1 Section 18.8.45, xf (Format)

  • Article

a.   The standard does not define different behaviors for @applyAlignment depending on whether the xf is in the CellXfs element or the CellStyleXfs element.

For the cellStyleXfs element, this boolean value indicates whether the alignment formatting specified for this xf is applied. The default value for applyAlignment in cellStyleXfs is true.

For the cellXfs element, this boolean value indicates whether the alignment formatting in the xf is overwritten by changes to the cellStyleXfs referenced by xfId. If applyAlignment is false and the alignment formatting in the cellStyleXfs changes, the new alignment formatting is set in the xf as well. If applyAlignment is true, then the xf will retain its existing alignment formatting. If the alignment formatting in the cellXf is different than the alignment formatting in the parent cellStyleXf, applyAlignment shall be true. The default value for applyAlignment in cellXfs element is false.

b.   The standard does not define different behaviors for @applyBorder depending on whether the xf is in the CellXfs element or the CellStyleXfs element.

For the cellStyleXfs element, this boolean value indicates whether the border formatting specified for this xf is applied. The default value for applyBorder in cellStyleXfs is true.

For the cellXfs element, this boolean value indicates whether the border formatting in the xf is overwritten by changes to the cellStyleXfs referenced by xfId. If applyBorder is false and the border formatting in the cellStyleXfs changes, the new border formatting is set in the xf as well. If applyBorder is true, then the xf will retain its existing border formatting. If the border formatting in the cellXf is different than the border formatting in the parent cellStyleXf, applyBorder shall be true. The default value for applyBorder in cellXfs element is false.

c.   The standard does not define different behaviors for @applyFill depending on whether the xf is in the CellXfs element or the CellStyleXfs element.

For the cellStyleXfs element, this boolean value indicates whether the fill formatting specified for this xf is applied. The default value for applyFill in cellStyleXfs is true.

For the cellXfs element, this boolean value indicates whether the fill formatting in the xf is overwritten by changes to the cellStyleXfs referenced by xfId. If applyFill is false and the fill formatting in the cellStyleXfs changes, the new fill formatting is set in the xf as well. If applyFill is true, then the xf will retain its existing fill formatting. If the fill formatting in the cellXf is different than the fill formatting in the parent cellStyleXf, applyFill shall be true. The default value for applyFill in cellXfs element is false.

d.   The standard does not define different behaviors for @applyFont depending on whether the xf is in the CellXfs element or the CellStyleXfs element.

For the cellStyleXfs element, this boolean value indicates whether the font formatting specified for this xf is applied. The default value for applyFont in cellStyleXfs is true.

For the cellXfs element, this boolean value indicates whether the font formatting in the xf is overwritten by changes to the cellStyleXfs referenced by xfId. If applyFont is false and the font formatting in the cellStyleXfs changes, the new font formatting is set in the xf as well. If applyFont is true, then the xf will retain its existing font formatting. If the font formatting in the cellXf is different than the font formatting in the parent cellStyleXf, applyFont shall be true. The default value for applyFont in cellXfs element is false.

e.   The standard does not define different behavior for @applyNumberFormat depending on whether the xf is in the CellXfs element or the CellStyleXfs element.

For the cellStyleXfs element, this boolean value indicates whether the number formatting specified for this xf is applied. The default value for applyNumberFormat in cellStyleXfs is true.

For the cellXfs element, this boolean value indicates whether the number formatting in the xf is overwritten by changes to the cellStyleXfs referenced by xfId. If applyNumberFormat is false and the number formatting in the cellStyleXfs changes, the new number formatting is set in the xf as well. If applyNumberFormat is true, then the xf will retain its existing number formatting. If the number formatting in the cellXf is different than the number formatting in the parent cellStyleXf, applyNumberFormat shall be true. The default value for applyNumberFormat in cellXfs element is false.

f.   The standard does not define different behaviors for @applyProtection depending on whether the xf is in the CellXfs element or the CellStyleXfs element.

For the cellStyleXfs element, this boolean value indicates whether the protection formatting specified for this xf is applied. The default value for applyProtection in cellStyleXfs is true.

For the cellXfs element, this boolean value indicates whether the protection formatting in the xf is overwritten by changes to the cellStyleXfs referenced by xfId. If applyProtection is false and the protection formatting in the cellStyleXfs changes, the new protection formatting is set in the xf as well. If applyProtection is true, then the xf will retain its existing protection formatting. If the protection formatting in the cellXf is different than the protection formatting in the parent cellStyleXf, applyProtection shall be true. The default value for applyProtection in cellXfs element is false.