Share via

2.4.3 f

  • Article

Target namespace: http://schemas.microsoft.com/office/excel/2006/main

Referenced by: CT_WebExtension, CT_CfRule, CT_Cfvo, CT_DataValidationFormula, CT_SparklineGroup, CT_Sparkline, CT_PivotUserEdit

The f element is an ST_Formula element, as specified in [ISO/IEC29500-1:2016] section 18.18.35, that specifies a generic formula that adheres to section 2.2.2.

An application can adjust the cell references within this formula when the worksheet layout changes, even when the containing ext element, as specified in [ISO/IEC29500-1:2016] section 18.2.7, is not recognized by the application. See [ISO/IEC29500-3:2015] section 10.1.2 for more information about how extension lists are used.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this element.

 <xsd:element name="f" type="x:ST_Formula"/>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).