[ms-xlsx]: Excel (. xlsx) Extensions to the Office Open xml spreadsheetml file Format

Future function

_xlfn.ACOT

_xlfn.ACOTH

_xlfn.AGGREGATE

_xlfn.ARABIC

_xlfn.BASE

_xlfn.BETA.DIST

_xlfn.BETA.INV

_xlfn.BINOM.DIST

_xlfn.BINOM.DIST.RANGE

_xlfn.BINOM.INV

_xlfn.BITAND

_xlfn.BITLSHIFT

_xlfn.BITOR

_xlfn.BITRSHIFT

_xlfn.BITXOR

_xlfn.CEILING.MATH

_xlfn.CEILING.PRECISE

_xlfn.CHISQ.DIST

_xlfn.CHISQ.DIST.RT

_xlfn.CHISQ.INV

_xlfn.CHISQ.INV.RT

_xlfn.CHISQ.TEST

_xlfn.COMBINA

_xlfn.CONFIDENCE.NORM

_xlfn.CONFIDENCE.T

_xlfn.COT

_xlfn.COTH

_xlfn.COVARIANCE.P

_xlfn.COVARIANCE.S

_xlfn.CSC

_xlfn.CSCH

_xlfn.DAYS

_xlfn.DECIMAL

ECMA.CEILING

_xlfn.ERF.PRECISE

_xlfn.ERFC.PRECISE

_xlfn.EXPON.DIST

_xlfn.F.DIST

_xlfn.F.DIST.RT

_xlfn.F.INV

_xlfn.F.INV.RT

_xlfn.F.TEST

_xlfn.FILTERXML

_xlfn.FLOOR.MATH

_xlfn.FLOOR.PRECISE

_xlfn.FORMULATEXT

_xlfn.GAMMA

_xlfn.GAMMA.DIST

_xlfn.GAMMA.INV

_xlfn.GAMMALN.PRECISE

_xlfn.GAUSS

_xlfn.HYPGEOM.DIST

_xlfn.IFNA

_xlfn.IMCOSH

_xlfn.IMCOT

_xlfn.IMCSC

_xlfn.IMCSCH

_xlfn.IMSEC

_xlfn.IMSECH

_xlfn.IMSINH

_xlfn.IMTAN

_xlfn.ISFORMULA

ISO.CEILING

_xlfn.ISOWEEKNUM

_xlfn.LOGNORM.DIST

_xlfn.LOGNORM.INV

_xlfn.MODE.MULT

_xlfn.MODE.SNGL

_xlfn.MUNIT

_xlfn.NEGBINOM.DIST

NETWORKDAYS.INTL

_xlfn.NORM.DIST

_xlfn.NORM.INV

_xlfn.NORM.S.DIST

_xlfn.NORM.S.INV

_xlfn.NUMBERVALUE

_xlfn.PDURATION

_xlfn.PERCENTILE.EXC

_xlfn.PERCENTILE.INC

_xlfn.PERCENTRANK.EXC

_xlfn.PERCENTRANK.INC

_xlfn.PERMUTATIONA

_xlfn.PHI

_xlfn.POISSON.DIST

_xlfn.QUARTILE.EXC

_xlfn.QUARTILE.INC

_xlfn.QUERYSTRING

_xlfn.RANK.AVG

_xlfn.RANK.EQ

_xlfn.RRI

_xlfn.SEC

_xlfn.SECH

_xlfn.SHEET

_xlfn.SHEETS

_xlfn.SKEW.P

_xlfn.STDEV.P

_xlfn.STDEV.S

_xlfn.T.DIST

_xlfn.T.DIST.2T

_xlfn.T.DIST.RT

_xlfn.T.INV

_xlfn.T.INV.2T

_xlfn.T.TEST

_xlfn.UNICHAR

_xlfn.UNICODE

_xlfn.VAR.P

_xlfn.VAR.S

_xlfn.WEBSERVICE

_xlfn.WEIBULL.DIST

WORKDAY.INTL

_xlfn.XOR

_xlfn.Z.TEST

The function syntax ([ISO/IEC29500-1:2011] section 18.17.2.4) is extended by changing the function-name rule to:

function-name =

prefixed-function-name |

predefined-function-name |

user-defined-function-name |

future-function-list;

The future-function-list rule is found in the Formulas grammar.

2.2.4 Extensions by Part

This section specifies the elements from Office Open XML file formats as specified in [ISO/IEC29500-1:2011] that are extended by this format. Either the Ignorable attribute ([ISO/IEC29500-3:2011] section 10.1.1), AlternateContent element ([ISO/IEC29500-3:2011] section 10.2.1), or the extLst element ([ISO/IEC29500-1:2011] section 18.2.10) MUST be used to maintain compatibility with Office Open XML file formats implementations as specified in [ISO/IEC29500:2011].

2.2.4.1 Connections

The extLst child element ([ISO/IEC29500-1:2011] section 18.2.10) of the connection element ([ISO/IEC29500-1:2011] section 18.13.1) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2011] section 18.2.7) whose structure is specified in the following table.

Ext URI	Child element
{D79990A0-CA42-45E3-83F4-45C500A0EAA5}	connection
{DE250136-89BD-433C-8126-D09CA5730AF9}	connection

 

See [ISO/IEC29500-3:2011] section 10.1.2 for more details about how extension lists are used.

2.2.4.2 Drawing

The oneCellAnchor element ([ISO/IEC29500-1:2011] section 20.5.2.24) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] section 10.2.1) whose structure is specified in the following table.

AlternateContent components	Child element
Choice: http://schemas.microsoft.com/office/drawingml/2010/slicer	slicer
Fallback	sp ([ISO/IEC29500-1:2011] section 20.5.2.29)

The twoCellAnchor element ([ISO/IEC29500-1:2011] section 20.5.2.33) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] section 10.2.1) whose structure is specified in the following table.

AlternateContent components	Child element
Choice: http://schemas.microsoft.com/office/drawingml/2010/slicer	slicer
Fallback	sp ([ISO/IEC29500-1:2011] section 20.5.2.29)

The grpSp element ([ISO/IEC29500-1:2011] section 20.5.2.17) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] section 10.2.1) whose structure is specified in the following table.

AlternateContent components	Child element
Choice: http://schemas.microsoft.com/office/drawingml/2010/slicer	slicer
Fallback	sp ([ISO/IEC29500-1:2011] section 20.5.2.29)

The absoluteAnchor element ([ISO/IEC29500-1:2011] section 20.5.2.1) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] section 10.2.1) whose structure is specified in the following table.

AlternateContent components	Child element
Choice: http://schemas.microsoft.com/office/drawingml/2010/slicer	slicer
Fallback	sp ([ISO/IEC29500-1:2011] section 20.5.2.29)

2.2.4.3 External Workbook References

The oleItems element ([ISO/IEC29500-1:2011] section 18.14.10) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] section 10.2.1) whose structure is specified in the following table.

AlternateContent components	Child element
Choice: http://schemas.microsoft.com/office/spreadsheetml/2009/9/main	oleItem
Fallback	oleItem ([ISO/IEC29500-1:2011] section 18.14.9)

2.2.4.4 Pivot Table

The extLst child element ([ISO/IEC29500-1:2011] section 18.2.10) of the pivotTableDefinition element ([ISO/IEC29500-1:2011] section 18.10.1.73) is extended by the addition of new child ext elements ([ISO/IEC29500-1:2011] section 18.2.7) whose structure is specified in the following table.

Ext URI	Child element
{962EF5D1-5CA2-4C93-8EF4-DBF5C05439D2}	pivotTableDefinition
{44433962-1CF7-4059-B4EE-95C3D5FFCF73}	pivotTableData
{C510F80B-63DE-4267-81D5-13C33094786E}	pivotTableServerFormats
{E67621CE-5B39-4880-91FE-76760E9C1902}	pivotTableUISettings

 

See [ISO/IEC29500-3:2011] section 10.1.2 for more information about how extension lists are used.

The extLst child element ([ISO/IEC29500-1:2011] section 18.2.10) of the pivotField element ([ISO/IEC29500-1:2011] section 18.10.1.69) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2011] section 18.2.7) whose structure is specified in the following table.

Ext URI	Child element
{2946ED86-A175-432A-8AC1-64E0C546D7DE}	pivotField

 

See [ISO/IEC29500-3:2011] section 10.1.2 for more information about how extension lists are used.

The extLst child element ([ISO/IEC29500-1:2011] section 18.2.10) of the dataField element ([ISO/IEC29500-1:2011] section 18.10.1.22) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2011] section 18.2.7) whose structure is specified in the following table.

Ext URI	Child element
{E15A36E0-9728-4E99-A89B-3F7291B0FE68}	dataField

 

See [ISO/IEC29500-3:2011] section 10.1.2 for more information about how extension lists are used.

The extLst child element ([ISO/IEC29500-1:2011] section 18.2.10) of the pivotHierarchy element ([ISO/IEC29500-1:2011] section 18.10.1.72) is extended by the addition of a new child ext element ([ISO/IEC29500-1:2011] section 18.2.7) whose structure is specified in the following table.

Ext URI	Child element
{F1805F06-0CD304483-9156-8803C3D141DF}	pivotHierarchy

 

See [ISO/IEC29500-3:2011] section 10.1.2 for more information about how extension lists are used.

The filterColumn element ([ISO/IEC29500-1:2011] section 18.3.2.7) is extended by the addition of a child AlternateContent element ([ISO/IEC29500-3:2011] section 10.2.1) whose structure is specified in the following table.