6 Appendix B: Product Behavior

Office

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

  • Microsoft Excel 2013

  • Microsoft SQL Server 2008 R2

  • Microsoft SQL Server 2012

  • Microsoft Excel 2016

Exceptions, if any, are noted below. If a service pack or Quick Fix Engineering (QFE) number appears with the product version, behavior changed in that service pack or QFE. The new behavior also applies to subsequent service packs of the product 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.

Show: