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:2011] 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:2011] section 18.2.7, is not recognized by the application. See [ISO/IEC29500-3:2011] section 10.1.2 for more information about how extension lists are used.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.4.4 ref
Target namespace: http://schemas.microsoft.com/office/excel/2006/main
The ref element is an ST_Ref type element, as specified in section 2.7.1, that specifies a cell reference.
An application can adjust this cell reference when the worksheet layout changes, even when the containing ext element, as specified in [ISO/IEC29500-1:2011] section 18.2.7, is not recognized by the application. See [ISO/IEC29500-3:2011] section 10.1.2 for more information about how extension lists are used.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.4.5 sqref
Target namespace: http://schemas.microsoft.com/office/excel/2006/main
Referenced by: CT_ConditionalFormatting, CT_DataValidation, CT_Sparkline, CT_IgnoredError, CT_ProtectedRange
A sqref element is an ST_Sqref type element, as specified in section 2.7.2, that specifies a list of cell references.
An application can adjust these cell references when the worksheet layout changes, even when the containing ext element, as specified in [ISO/IEC29500-1:2011] section 18.2.7, is not recognized by the application. See [ISO/IEC29500-3:2011] section 10.1.2 for more information about how extension lists are used.
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.4.6 conditionalFormattings
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
A conditionalFormattings element is a CT_ConditionalFormattings type element, as specified in section 2.6.1, that specifies conditional formatting information for the worksheet. See section 2.2.4.11 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2011].
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.4.7 dataValidations
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main
The dataValidations element is a CT_DataValidations type element, as specified in section 2.6.3, that specifies a group of data validation items on the sheet (1). This element also specifies data validation properties of a sheet (1) that are used by the application user interface. See section 2.2.4.11 for how this element integrates with the Office Open XML file formats specified in [ISO/IEC29500-1:2011].
The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.
See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).
2.4.8 sparklineGroups
Dostları ilə paylaş: | 
