6 Appendix B: Product Behavior

  • Article

The information in this specification is applicable to the following Microsoft products or supplemental software. References to product versions include updates to those products.

  • Microsoft Excel 2013

  • Microsoft SQL Server 2008 R2

  • Microsoft SQL Server 2012

  • Microsoft Excel 2016

  • Microsoft Excel 2019

  • Microsoft Excel 2021

Exceptions, if any, are noted in this section. If an update version, service pack or Knowledge Base (KB) number appears with a product name, the behavior changed in that update. The new behavior also applies to subsequent updates unless otherwise specified. If a product edition appears with the product version, behavior is different in that product edition.

Unless otherwise specified, any statement of optional behavior in this specification that is prescribed using the terms "SHOULD" or "SHOULD NOT" implies product behavior in accordance with the SHOULD or SHOULD NOT prescription. Unless otherwise specified, the term "MAY" implies that the product does not follow the prescription.

<1> Section 2.1.2.3.1:  Excel 2013 restricts the collation name to a list of strings that can be obtained by executing the following query against SQL Server 2008 R2:

 SELECT * FROM FN:HELPCOLLATIONS() WHERE NAME NOT LIKE ‘SQL%’

<2> Section 2.1.2.3.1.1:  Excel 2013 accepts only strings that can be obtained by executing the following query against SQL Server 2008 R2:

 SELECT * FROM FN:HELPCOLLATIONS() WHERE NAME NOT LIKE ‘SQL%’

<3> Section 2.2.1:  Excel 2013 normalizes UserID as described in [MS-SSAS] section 2.2.4.2.1.2.

<4> Section 2.2.3.1:  Excel 2013 normalizes UserID as described in [MS-SSAS] section 2.2.4.2.1.2.

<5> Section 2.2.3.2:  Excel 2013 normalizes UserID as described in [MS-SSAS] section 2.2.4.2.1.2.

<6> Section 2.2.3.4:  Excel 2013 normalizes UserID as described in [MS-SSAS] section 2.2.4.2.1.2.

<7> Section 2.2.3.5:  Excel 2013 generates a data source folder for the model. The folder is empty.

<8> Section 2.2.3.6:  Excel 2013 normalizes UserID as described in [MS-SSAS] section 2.2.4.2.1.2.

<9> Section 2.3.1:  Excel 2013 assigns data identifiers in the order in which each unique value is encountered in the source data.

<10> Section 2.3.1:  Excel 2013 uses partial sorting to optimize compression.

<11> Section 2.5.2.3.1:  Excel 2013 restricts the collation name to a list of strings that can be obtained by executing the following query against SQL Server 2008 R2:

 SELECT * FROM FN:HELPCOLLATIONS() WHERE NAME NOT LIKE ‘SQL%’

<12> Section 2.6.9:  Excel 2013 inserts the text for the command as stated in the document.