5 Appendix A: Product Behavior
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 Office Excel 2007
Microsoft Excel 2010
Microsoft Excel 2013
Microsoft Excel 2016
Microsoft Excel 2019
Microsoft Excel 2021
Microsoft Excel LTSC 2024
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.7.4: Office Excel 2007, Excel 2010 and Excel 2013 write out this part on save.
<2> Section 2.1.7.47: Office Excel 2007 preserves but does not support this part.
<3> Section 2.2.7.4.3.1: Office Excel 2007 does not save cached values for OLE data items.
<4> Section 2.2.9: Office Excel 2007, Excel 2010 and Excel 2013 warn the user when they enter passwords that contain characters other than alphanumeric characters or punctuation symbols.
<5> Section 2.3: Excel 2010 added support for record types that have record type values greater than or equal to 1024.
<6> Section 2.4.18: Excel 2010 and Excel 2013 do not save this record.
<7> Section 2.4.19: Excel 2010 and Excel 2013 does not save this record.
<8> Section 2.4.24: Excel 2010 saves out a DXFId instead.
<9> Section 2.4.71: If this Web connection was created in Microsoft Excel 97 this field is 1. Otherwise, this field is 0.
<10> Section 2.4.71: If this Web connection was refreshed using Microsoft Excel 2000, Microsoft Excel 2002, Microsoft Office Excel 2003, Office Excel 2007, Excel 2010 or Excel 2013, this field is 1. Otherwise, this field is 0.
<11> Section 2.4.78: Office Excel 2007, Excel 2010, and Excel 2013 do not load a file in which this field contains a value that it does not recognize, or that is not recognized by the underlying operating system. Office Excel 2007 and Excel 2010 recognize the language tags in the following table.
|
Language |
Locale |
Language tag |
|---|---|---|
|
Afrikaans |
South Africa |
af-ZA |
|
Albanian |
Albanian |
sq-AL |
|
Alsatian |
France |
gsw-FR |
|
Amharic |
Ethiopia |
am-ET |
|
Arabic |
Algeria |
ar-DZ |
|
Arabic |
Bahrain |
ar-BH |
|
Arabic |
Egypt |
ar-EG |
|
Arabic |
Iraq |
ar-IQ |
|
Arabic |
Jordan |
ar-JO |
|
Arabic |
Kuwait |
ar-KW |
|
Arabic |
Lebanon |
ar-LB |
|
Arabic |
Libya |
ar-LY |
|
Arabic |
Morocco |
ar-MA |
|
Arabic |
Oman |
ar-OM |
|
Arabic |
Qatar |
ar-QA |
|
Arabic |
Saudi Arabia |
ar-SA |
|
Arabic |
Syria |
ar-SY |
|
Arabic |
Tunisia |
ar-TN |
|
Arabic |
U.A.E. |
ar-AE |
|
Arabic |
Yemen |
ar-YE |
|
Armenian |
Armenia |
hy-AM |
|
Assamese |
India |
as-IN |
|
Azerbaijani (Cyrillic) |
Azerbaijan |
az-AZ-Cyrl |
|
Azerbaijani (Latin) |
Azerbaijan |
az-AZ-Latn |
|
Bangla |
Bangladesh |
bn-BD |
|
Bangla (Bangla Script) |
India |
bn-IN |
|
Bashkir |
Russia |
ba-RU |
|
Basque |
Basque (Basque) |
eu-ES |
|
Belarusian |
Belarus |
be-BY |
|
Bhutanese |
Bhutan |
bo-BT |
|
Bosnian (Cyrillic) |
Bosnia and Herzegovina |
bs-BA-Cyrl |
|
Bosnian (Latin) |
Bosnia and Herzegovina |
bs-BA-Latn |
|
Breton |
France |
br-FR |
|
Bulgarian |
Bulgaria |
bg-BG |
|
Catalan |
Catalan |
ca-ES |
|
Chinese |
Hong Kong SAR |
zh-HK |
|
Chinese |
Macao SAR |
zh-MO |
|
Chinese |
PRC |
zh-CN |
|
Chinese |
Singapore |
zh-SG |
|
Chinese |
Taiwan |
zh-TW |
|
Corsican |
France |
co-FR |
|
Croatian |
Croatia |
hr-HR |
|
Croatian (Latin) |
Bosnia and Herzegovina |
hr-BA-Latn |
|
Czech |
Czech Republic |
cs-CZ |
|
Danish |
Denmark |
da-DK |
|
Dari |
Afghanistan |
prs-AF |
|
Divehi |
Maldives |
div-MV |
|
Dutch |
Belgium |
nl-BE |
|
Dutch |
Netherlands |
nl-NL |
|
English |
Australia |
en-AU |
|
English |
Belize |
en-BZ |
|
English |
Canada |
en-CA |
|
English |
Caribbean |
en-CB |
|
English |
India |
en-IN |
|
English |
Ireland |
en-IE |
|
English |
Jamaica |
en-JM |
|
English |
Malaysia |
en-MY |
|
English |
New Zealand |
en-NZ |
|
English |
Philippines |
en-PH |
|
English |
South Africa |
en-ZA |
|
English |
Trinidad |
en-TT |
|
English |
United Kingdom |
en-GB |
|
English |
United States |
en-US |
|
English |
Zimbabwe |
en-ZW |
|
Estonian |
Estonia |
et-EE |
|
Faroese |
Faroe Islands |
fo-FO |
|
Filipino |
Philippines |
fil-PH |
|
Finnish |
Finland |
fi-FI |
|
French |
Belgium |
fr-BE |
|
French |
Canada |
fr-CA |
|
French |
France |
fr-FR |
|
French |
Luxembourg |
fr-LU |
|
French |
Monaco |
fr-MC |
|
French |
Switzerland |
fr-CH |
|
Frisian |
Netherlands |
fy-NL |
|
Galician |
Galician |
gl-ES |
|
Georgian |
Georgia |
ka-GE |
|
German |
Austria |
de-AT |
|
German |
Germany |
de-DE |
|
German |
Liechtenstein |
de-LI |
|
German |
Luxembourg |
de-LU |
|
German |
Switzerland |
de-CH |
|
Greek |
Greece |
el-GR |
|
Greenlandic |
Greenland |
kl-GL |
|
Gujarati (Gujarati Script) |
India |
gu-IN |
|
Hausa (Latin) |
Nigeria |
ha-NG-Latn |
|
Hebrew |
Israel |
he-IL |
|
Hindi |
India |
hi-IN |
|
Hungarian |
Hungary |
hu-HU |
|
Icelandic |
Iceland |
is-IS |
|
Igbo |
Nigeria |
ig-NG |
|
Inari Sami |
Finland |
smn-FI |
|
Indonesian |
Indonesia |
id-ID |
|
Inuktitut (Latin) |
Canada |
iu-CA-Latn |
|
Inuktitut (Syllabics) |
Canada |
iu-CA-Cans |
|
Irish |
Ireland |
ga-IE |
|
isiXhosa / Xhosa |
South Africa |
xh-ZA |
|
isiZulu / Zulu |
South Africa |
zu-ZA |
|
Italian |
Italy |
it-IT |
|
Italian |
Switzerland |
it-CH |
|
Japanese |
Japan |
ja-JP |
|
Kannada (Kannada Script) |
India |
kn-IN |
|
Kazakh |
Kazakhstan |
kk-KZ |
|
Khmer |
Cambodia |
kh-KH |
|
K'iche |
Guatemala |
qut-GT |
|
Kinyarwanda |
Rwanda |
rw-RW |
|
Konkani |
India |
kok-IN |
|
Korean |
Korea |
ko-KR |
|
Kyrgyz |
Kyrgyzstan |
ky-KG |
|
Lao |
Lao PDR |
lo-LA |
|
Latvian |
Latvia |
lv-LV |
|
Lithuanian |
Lithuania |
lt-LT |
|
Lower Sorbian |
Germany |
wee-DE |
|
Lule Sami |
Norway |
smj-NO |
|
Lule Sami |
Sweden |
smj-SE |
|
Luxembourgish |
Luxembourg |
lb-LU |
|
Macedonian |
Former Yugoslav Republic of Macedonia |
mk-MK |
|
Malay |
Brunei |
ms-BN |
|
Malay |
Malaysia |
ms-MY |
|
Malayalam (Malayalam Script) |
India |
ml-IN |
|
Maltese |
Malta |
mt-MT |
|
Maori |
New Zealand |
mi-NZ |
|
Mapudungun |
Chile |
arn-CL |
|
Marathi |
India |
mr-IN |
|
Mohawk |
Mohawk |
moh-CA |
|
Mongolian (Cyrillic) |
Mongolia |
mn-MN |
|
Mongolian (Mongolian) |
PRC |
mn-CN-Mong |
|
Nepali |
Nepal |
ne-NP |
|
Northern Sami |
Finland |
se-FI |
|
Northern Sami |
Norway |
se-NO |
|
Northern Sami |
Sweden |
se-SE |
|
Norwegian (Bokmål) |
Norway |
nb-NO |
|
Norwegian (Nynorsk) |
Norway |
nn-NO |
|
Occitan |
France |
oc-FR |
|
Odia |
India |
or-IN |
|
Pashto |
Afghanistan |
ps-AF |
|
Persian |
Iran |
fa-IR |
|
Polish |
Poland |
pl-PL |
|
Portuguese |
Brazil |
pt-BR |
|
Portuguese |
Portugal |
pt-PT |
|
Punjabi (Gurumukhi Script) |
India |
pa-IN |
|
Quechua |
Bolivia |
quz-BO |
|
Quechua |
Ecuador |
quz-EC |
|
Quechua |
Peru |
quz-PE |
|
Romanian |
Romania |
ro-RO |
|
Romansh |
Switzerland |
rm-CH |
|
Russian |
Russia |
ru-RU |
|
Sakha |
Russia |
sah-RU |
|
Sanskrit |
India |
sa-IN |
|
Serbian (Cyrillic) |
Bosnia and Herzegovina |
sr-BA-Cyrl |
|
Serbian (Cyrillic) |
Serbia |
sr-SP-Cyrl |
|
Serbian (Latin) |
Bosnia and Herzegovina |
sr-BA-Latn |
|
Serbian (Latin) |
Serbia |
sr-SP-Latn |
|
Sesotho sa Leboa / Northern Sotho |
South Africa |
ns-ZA |
|
Setswana / Tswana |
South Africa |
tn-ZA |
|
Sinhala |
Sri Lanka |
si-LK |
|
Skolt Sami |
Finland |
sms-FI |
|
Slovak |
Slovakia |
sk-SK |
|
Slovenian |
Slovenia |
sl-SI |
|
Southern Sami |
Norway |
sma-NO |
|
Southern Sami |
Sweden |
sma-SE |
|
Spanish |
Argentina |
es-AR |
|
Spanish |
Bolivia |
es-BO |
|
Spanish |
Chile |
es-CL |
|
Spanish |
Columbia |
es-CO |
|
Spanish |
Costa Rica |
es-CR |
|
Spanish |
Dominican Republic |
es-DO |
|
Spanish |
Ecuador |
es-EC |
|
Spanish |
El Salvador |
es-SV |
|
Spanish |
Guatemala |
es-GT |
|
Spanish |
Honduras |
es-HN |
|
Spanish |
Mexico |
es-MX |
|
Spanish |
Nicaragua |
es-NI |
|
Spanish |
Panama |
es-PA |
|
Spanish |
Paraguay |
es-PY |
|
Spanish |
Peru |
es-PE |
|
Spanish |
Puerto Rico |
es-PR |
|
Spanish |
Spain |
es-ES |
|
Spanish |
United States |
es-US |
|
Spanish |
Uruguay |
es-UY |
|
Spanish |
Venezuela |
es-VE |
|
Swahili |
Kenya |
sw-KE |
|
Swedish |
Finland |
sv-FI |
|
Swedish |
Sweden |
sv-SE |
|
Syriac |
Syria |
syr-SY |
|
Tajik (Cyrillic) |
Tajikistan |
tg-TJ-Cyrl |
|
Tamazight (Latin) |
Algeria |
tmz-DZ-Latn |
|
Tamil |
India |
ta-IN |
|
Tatar |
Russia |
tt-RU |
|
Telugu (Telugu Script) |
India |
te-IN |
|
Thai |
Thailand |
th-TH |
|
Tibetan |
PRC |
bo-CN |
|
Turkish |
Turkey |
tr-TR |
|
Turkmen |
Turkmenistan |
tk-TM |
|
Uighur |
PRC |
ug-CN |
|
Ukrainian |
Ukraine |
uk-UA |
|
Upper Sorbian |
Germany |
wen-DE |
|
Urdu |
Pakistan |
ur-PK |
|
Uzbek (Cyrillic) |
Uzbekistan |
uz-UZ-Cyrl |
|
Uzbek (Latin) |
Uzbekistan |
uz-UZ-Latn |
|
Vietnamese |
Viet Nam |
vi-VN |
|
Welsh |
Great Britain |
cy-GB |
|
Wolof |
Senegal |
wo-SN |
|
Yi |
PRC |
ii-CN |
|
Yoruba |
Nigeria |
yo-NG |
<12> Section 2.4.87: In certain scenarios, Office Excel 2007, Excel 2010, and Excel 2013 write out more than 0x000000CE BrtFmt records.
<13> Section 2.4.101: When the file is saved, the value of the stStyleAgg becomes NULL and the old value is written to the stStyleInsertRow. When the file is re-opened, these new styles will be applied.
<14> Section 2.4.107: Office Excel 2007, Excel 2010, and Excel 2013 will not load a file if kpiprop is equal to 0x00000005 or 0x00000006.
<15> Section 2.4.134: If this value is greater than 0x00 and the fMixedTypesIgnoringBlanks field of the BrtBeginPCDFAtbl (section 2.4.131) record of the enclosing BrtBeginPCDField (section 2.4.136) record is 1, Office Excel 2007 will report a valid file as corrupt.
<16> Section 2.4.148: Office Excel 2007, Excel 2010, and Excel 2013 will only load a file if the MDX expression specified by stWeight corresponds to a measure (section 2.2.5.2.7.1) in the OLAP cube.
<17> Section 2.4.148: Office Excel 2007 will not load a file with this string specified.
<18> Section 2.4.167: The value of fLoadSheet can be 0 if fName is 0 and the specified external workbook has one sheet and that sheet has the same name as that external workbook, not including the file extension.
<19> Section 2.4.198: Office Excel 2007, Excel 2010, and Excel 2013 allow the Comment field of a BrtBeginSct record to be a NULL string after converting an Excel Binary File Format (.xls) document to an Excel 2007 Binary File Format (.xlsb) document.
<20> Section 2.4.222: Excel 2010 and Excel 2013 do not save this record.
<21> Section 2.4.223: Excel 2010 and Excel 2013 do not save this record.
<22> Section 2.4.260: Office Excel 2007, Excel 2010, and Excel 2013 save the PNN value of Top-left pane as Bottom-right pane and Bottom-right pane as Top-left pane.
<23> Section 2.4.260: Office Excel 2007 will not load a file if the pivot selection belongs to the page area.
<24> Section 2.4.275: Office Excel 2007, Excel 2010, and Excel 2013 do not always save a value of 1 for OLAP PivotTables.
<25> Section 2.4.308: If the value of the protpwdBook field of the BrtBookProtection (section 2.4.308) record is not 0x0000, Office Excel 2007 encrypts the document as described in [MS-OFFCRYPTO], section 2.3.4, ECMA-376 Document Encryption. If an encryption password is not specified the document is encrypted with the default password of "\x56\x65\x6C\x76\x65\x74\x53\x77\x65\x61\x74\x73\x68\x6F\x70".
<26> Section 2.4.308: If the value of the protpwdRev field of the BrtBookProtection (section 2.4.308) record is not 0x0000, Office Excel 2007 encrypts the document as described in [MS-OFFCRYPTO], section 2.3.4, ECMA-376 Document Encryption. If an encryption password is not specified the document is encrypted with the default password of "\x56\x65\x6C\x76\x65\x74\x53\x77\x65\x61\x74\x73\x68\x6F\x70".
<27> Section 2.4.309: If the size of the rgbHash member of the ipdBookPasswordData field of the BrtBookProtectionIso (section 2.4.309) record is nonzero, Office Excel 2007 encrypts the document as described in [MS-OFFCRYPTO], section 2.3.4, ECMA-376 Document Encryption. If an encryption password is not specified the document is encrypted with the default password of "\x56\x65\x6C\x76\x65\x74\x53\x77\x65\x61\x74\x73\x68\x6F\x70".
<28> Section 2.4.309: If the size of the rgbHash member of the ipdRevPasswordData field of the BrtBookProtectionIso (section 2.4.309) record is nonzero, Office Excel 2007 encrypts the document as described in [MS-OFFCRYPTO], section 2.3.4, ECMA-376 Document Encryption. If an encryption password is not specified the document is encrypted with the default password of "\x56\x65\x6C\x76\x65\x74\x53\x77\x65\x61\x74\x73\x68\x6F\x70".
<29> Section 2.4.326: Excel 2010 and Excel 2013 do not save this record.
<30> Section 2.4.326: Office Excel 2007 will not correctly load files with a val greater than or equal to 256.
<31> Section 2.4.372: Excel 2010 and Excel 2013 do not save this record.
<32> Section 2.4.373: Excel 2010 and Excel 2013 do not save this record.
<33> Section 2.4.572: Excel 2010 and Excel 2013 do not save this record.
<34> Section 2.4.573: Excel 2010 and Excel 2013 do not save this record.
<35> Section 2.4.673: Office Excel 2007 , Excel 2010 and Excel 2013 use this GUID as described in [MS-DTYP] section 2.3.4 to determine whether the VBA project needs to be recompiled on load by comparing the GUID in the file to the GUID built into the application. If the value is 0x0, the VBA project needs to be recompiled on load.
<36> Section 2.4.673: Value "xl" for stAppName is used by Office Excel 2007, Excel 2010, and Excel 2013. When stAppName is equal to "xl", Office Excel 2007, Excel 2010, and Excel 2013 expect each of stLastEdited, stLowestEdited, and stRupBuild to be a text representation of an unsigned integer that is less than or equal to 32767. When stAppName is not equal to "xl", Office Excel 2007, Excel 2010, and Excel 2013 ignore values of stLastEdited, stLowestEdited, and stRupBuild.
<37> Section 2.4.681: This record is available only in Excel 2016.
<38> Section 2.4.718: Office Excel 2007 does not ignore the preceding BrtBeginPCDField (section 2.4.136) of this record.
<39> Section 2.4.719: Office Excel 2007 does not support multiple uses of the same OLAP measure in one cache hierarchy (section 2.2.5.2.7) as specified by the PCDHIERARCHY rule, and does not ignore the associated cache hierarchy when the BrtPCDH14.fIgnorable bit is 1.
<40> Section 2.4.734: Office Excel 2007, Excel 2010, and Excel 2013 do not load a file in which this field contains a value that it does not recognize, or that is not recognized by the underlying operating system. Office Excel 2007, Excel 2010, and Excel 2013 recognize the following language tags:
|
Language |
Locale |
Language Tag |
|---|---|---|
|
Afrikaans |
South Africa |
af-ZA |
|
Albanian |
Albanian |
sq-AL |
|
Alsatian |
France |
gsw-FR |
|
Amharic |
Ethiopia |
am-ET |
|
Arabic |
Algeria |
ar-DZ |
|
Arabic |
Bahrain |
ar-BH |
|
Arabic |
Egypt |
ar-EG |
|
Arabic |
Iraq |
ar-IQ |
|
Arabic |
Jordan |
ar-JO |
|
Arabic |
Kuwait |
ar-KW |
|
Arabic |
Lebanon |
ar-LB |
|
Arabic |
Libya |
ar-LY |
|
Arabic |
Morocco |
ar-MA |
|
Arabic |
Oman |
ar-OM |
|
Arabic |
Qatar |
ar-QA |
|
Arabic |
Saudi Arabia |
ar-SA |
|
Arabic |
Syria |
ar-SY |
|
Arabic |
Tunisia |
ar-TN |
|
Arabic |
U.A.E. |
ar-AE |
|
Arabic |
Yemen |
ar-YE |
|
Armenian |
Armenia |
hy-AM |
|
Assamese |
India |
as-IN |
|
Azerbaijani (Cyrillic) |
Azerbaijan |
az-AZ-Cyrl |
|
Azerbaijani (Latin) |
Azerbaijan |
az-AZ-Latn |
|
Bangla |
Bangladesh |
bn-BD |
|
Bangla (Bangla Script) |
India |
bn-IN |
|
Bashkir |
Russia |
ba-RU |
|
Basque |
Basque (Basque) |
eu-ES |
|
Belarusian |
Belarus |
be-BY |
|
Bhutanese |
Bhutan |
bo-BT |
|
Bosnian (Cyrillic) |
Bosnia and Herzegovina |
bs-BA-Cyrl |
|
Bosnian (Latin) |
Bosnia and Herzegovina |
bs-BA-Latn |
|
Breton |
France |
br-FR |
|
Bulgarian |
Bulgaria |
bg-BG |
|
Catalan |
Catalan |
ca-ES |
|
Chinese |
Hong Kong SAR |
zh-HK |
|
Chinese |
Macao SAR |
zh-MO |
|
Chinese |
PRC |
zh-CN |
|
Chinese |
Singapore |
zh-SG |
|
Chinese |
Taiwan |
zh-TW |
|
Corsican |
France |
co-FR |
|
Croatian |
Croatia |
hr-HR |
|
Croatian (Latin) |
Bosnia and Herzegovina |
hr-BA-Latn |
|
Czech |
Czech Republic |
cs-CZ |
|
Danish |
Denmark |
da-DK |
|
Dari |
Afghanistan |
prs-AF |
|
Divehi |
Maldives |
div-MV |
|
Dutch |
Belgium |
nl-BE |
|
Dutch |
Netherlands |
nl-NL |
|
English |
Australia |
en-AU |
|
English |
Belize |
en-BZ |
|
English |
Canada |
en-CA |
|
English |
Caribbean |
en-CB |
|
English |
India |
en-IN |
|
English |
Ireland |
en-IE |
|
English |
Jamaica |
en-JM |
|
English |
Malaysia |
en-MY |
|
English |
New Zealand |
en-NZ |
|
English |
Philippines |
en-PH |
|
English |
South Africa |
en-ZA |
|
English |
Trinidad |
en-TT |
|
English |
United Kingdom |
en-GB |
|
English |
United States |
en-US |
|
English |
Zimbabwe |
en-ZW |
|
Estonian |
Estonia |
et-EE |
|
Faroese |
Faroe Islands |
fo-FO |
|
Filipino |
Philippines |
fil-PH |
|
Finnish |
Finland |
fi-FI |
|
French |
Belgium |
fr-BE |
|
French |
Canada |
fr-CA |
|
French |
France |
fr-FR |
|
French |
Luxembourg |
fr-LU |
|
French |
Monaco |
fr-MC |
|
French |
Switzerland |
fr-CH |
|
Frisian |
Netherlands |
fy-NL |
|
Galician |
Galician |
gl-ES |
|
Georgian |
Georgia |
ka-GE |
|
German |
Austria |
de-AT |
|
German |
Germany |
de-DE |
|
German |
Liechtenstein |
de-LI |
|
German |
Luxembourg |
de-LU |
|
German |
Switzerland |
de-CH |
|
Greek |
Greece |
el-GR |
|
Greenlandic |
Greenland |
kl-GL |
|
Gujarati (Gujarati Script) |
India |
gu-IN |
|
Hausa (Latin) |
Nigeria |
ha-NG-Latn |
|
Hebrew |
Israel |
he-IL |
|
Hindi |
India |
hi-IN |
|
Hungarian |
Hungary |
hu-HU |
|
Icelandic |
Iceland |
is-IS |
|
Igbo |
Nigeria |
ig-NG |
|
Inari Sami |
Finland |
smn-FI |
|
Indonesian |
Indonesia |
id-ID |
|
Inuktitut (Latin) |
Canada |
iu-CA-Latn |
|
Inuktitut (Syllabics) |
Canada |
iu-CA-Cans |
|
Irish |
Ireland |
ga-IE |
|
isiXhosa / Xhosa |
South Africa |
xh-ZA |
|
isiZulu / Zulu |
South Africa |
zu-ZA |
|
Italian |
Italy |
it-IT |
|
Italian |
Switzerland |
it-CH |
|
Japanese |
Japan |
ja-JP |
|
Kannada (Kannada Script) |
India |
kn-IN |
|
Kazakh |
Kazakhstan |
kk-KZ |
|
Khmer |
Cambodia |
kh-KH |
|
K'iche |
Guatemala |
qut-GT |
|
Kinyarwanda |
Rwanda |
rw-RW |
|
Konkani |
India |
kok-IN |
|
Korean |
Korea |
ko-KR |
|
Kyrgyz |
Kyrgyzstan |
ky-KG |
|
Lao |
Lao PDR |
lo-LA |
|
Latvian |
Latvia |
lv-LV |
|
Lithuanian |
Lithuania |
lt-LT |
|
Lower Sorbian |
Germany |
wee-DE |
|
Lule Sami |
Norway |
smj-NO |
|
Lule Sami |
Sweden |
smj-SE |
|
Luxembourgish |
Luxembourg |
lb-LU |
|
Macedonian |
Former Yugoslav Republic of Macedonia |
mk-MK |
|
Malay |
Brunei |
ms-BN |
|
Malay |
Malaysia |
ms-MY |
|
Malayalam (Malayalam Script) |
India |
ml-IN |
|
Maltese |
Malta |
mt-MT |
|
Maori |
New Zealand |
mi-NZ |
|
Mapudungun |
Chile |
arn-CL |
|
Marathi |
India |
mr-IN |
|
Mohawk |
Mohawk |
moh-CA |
|
Mongolian (Cyrillic) |
Mongolia |
mn-MN |
|
Mongolian (Mongolian) |
PRC |
mn-CN-Mong |
|
Nepali |
Nepal |
ne-NP |
|
Northern Sami |
Finland |
se-FI |
|
Northern Sami |
Norway |
se-NO |
|
Northern Sami |
Sweden |
se-SE |
|
Norwegian (Bokmål) |
Norway |
nb-NO |
|
Norwegian (Nynorsk) |
Norway |
nn-NO |
|
Occitan |
France |
oc-FR |
|
Odia |
India |
or-IN |
|
Pashto |
Afghanistan |
ps-AF |
|
Persian |
Iran |
fa-IR |
|
Polish |
Poland |
pl-PL |
|
Portuguese |
Brazil |
pt-BR |
|
Portuguese |
Portugal |
pt-PT |
|
Punjabi (Gurumukhi Script) |
India |
pa-IN |
|
Quechua |
Bolivia |
quz-BO |
|
Quechua |
Ecuador |
quz-EC |
|
Quechua |
Peru |
quz-PE |
|
Romanian |
Romania |
ro-RO |
|
Romansh |
Switzerland |
rm-CH |
|
Russian |
Russia |
ru-RU |
|
Sakha |
Russia |
sah-RU |
|
Sanskrit |
India |
sa-IN |
|
Serbian (Cyrillic) |
Bosnia and Herzegovina |
sr-BA-Cyrl |
|
Serbian (Cyrillic) |
Serbia |
sr-SP-Cyrl |
|
Serbian (Latin) |
Bosnia and Herzegovina |
sr-BA-Latn |
|
Serbian (Latin) |
Serbia |
sr-SP-Latn |
|
Sesotho sa Leboa / Northern Sotho |
South Africa |
ns-ZA |
|
Setswana / Tswana |
South Africa |
tn-ZA |
|
Sinhala |
Sri Lanka |
si-LK |
|
Skolt Sami |
Finland |
sms-FI |
|
Slovak |
Slovakia |
sk-SK |
|
Slovenian |
Slovenia |
sl-SI |
|
Southern Sami |
Norway |
sma-NO |
|
Southern Sami |
Sweden |
sma-SE |
|
Spanish |
Argentina |
es-AR |
|
Spanish |
Bolivia |
es-BO |
|
Spanish |
Chile |
es-CL |
|
Spanish |
Columbia |
es-CO |
|
Spanish |
Costa Rica |
es-CR |
|
Spanish |
Dominican Republic |
es-DO |
|
Spanish |
Ecuador |
es-EC |
|
Spanish |
El Salvador |
es-SV |
|
Spanish |
Guatemala |
es-GT |
|
Spanish |
Honduras |
es-HN |
|
Spanish |
Mexico |
es-MX |
|
Spanish |
Nicaragua |
es-NI |
|
Spanish |
Panama |
es-PA |
|
Spanish |
Paraguay |
es-PY |
|
Spanish |
Peru |
es-PE |
|
Spanish |
Puerto Rico |
es-PR |
|
Spanish |
Spain |
es-ES |
|
Spanish |
United States |
es-US |
|
Spanish |
Uruguay |
es-UY |
|
Spanish |
Venezuela |
es-VE |
|
Swahili |
Kenya |
sw-KE |
|
Swedish |
Finland |
sv-FI |
|
Swedish |
Sweden |
sv-SE |
|
Syriac |
Syria |
syr-SY |
|
Tajik (Cyrillic) |
Tajikistan |
tg-TJ-Cyrl |
|
Tamazight (Latin) |
Algeria |
tmz-DZ-Latn |
|
Tamil |
India |
ta-IN |
|
Tatar |
Russia |
tt-RU |
|
Telugu (Telugu Script) |
India |
te-IN |
|
Thai |
Thailand |
th-TH |
|
Tibetan |
PRC |
bo-CN |
|
Turkish |
Turkey |
tr-TR |
|
Turkmen |
Turkmenistan |
tk-TM |
|
Uighur |
PRC |
ug-CN |
|
Ukrainian |
Ukraine |
uk-UA |
|
Upper Sorbian |
Germany |
wen-DE |
|
Urdu |
Pakistan |
ur-PK |
|
Uzbek (Cyrillic) |
Uzbekistan |
uz-UZ-Cyrl |
|
Uzbek (Latin) |
Uzbekistan |
uz-UZ-Latn |
|
Vietnamese |
Viet Nam |
vi-VN |
|
Welsh |
Great Britain |
cy-GB |
|
Wolof |
Senegal |
wo-SN |
|
Yi |
PRC |
ii-CN |
|
Yoruba |
Nigeria |
yo-NG |
<41> Section 2.4.743: Versions of Excel prior to Excel LTSC 2024 will not ignore the isxvdData field of the immediately preceding BrtBeginSXDI (section 2.4.243) record.
<42> Section 2.4.744: Versions of Excel prior to Excel LTSC 2024 will not ignore the preceding BrtBeginSXVD record (section 2.4.272).
<43> Section 2.4.761: Office Excel 2007, Excel 2010, and Excel 2013 ignore this value on load and write out 0.
<44> Section 2.4.764: Office Excel 2007, Excel 2010, and Excel 2013 write the value of fAccepted as 0 when converting from an [ISO/IEC29500-1:2016] document to this persistence format and the other revision whose rrd.revid value matches the rrd.revid value of this revision is in a different revision log.
<45> Section 2.4.770: In Office Excel 2007, Excel 2010, and Excel 2013, the value BrtRRFormat.ich can also be 0 because the effect was not calculated. The ich value can be correctly determined from the cch value.
<46> Section 2.4.794: Excel 2010 and Excel 2013 do not save this record.
<47> Section 2.4.811: Office Excel 2007 does not save cached values for OLE Data Items (section 2.2.7.4.3.1).
<48> Section 2.4.815: Office Excel 2007 will not ignore the isxvdData field of the immediately preceding BrtBeginSXDI (section 2.4.243) record.
<49> Section 2.4.817: Versions of Excel prior to Excel LTSC 2024 will not ignore the iiftab of the immediately the immediately preceding BrtBeginSXDI (section 2.4.243) record.
<50> Section 2.4.820: Office Excel 2007 will not ignore the BrtBeginSXTH record preceding this record.
<51> Section 2.4.830: Office Excel 2007 does not support multiple uses of the same OLAP measure in one PivotTable view as specified by the PivotTable rule (section 2.2.5.3.9), and does not ignore the associated pivot field when BrtSXVD14 (section 2.4.830).fIgnorable is 0x01.
<52> Section 2.4.852: Excel 2010 and Excel 2013 do not save this record.
<53> Section 2.4.853: Office Excel 2007, Excel 2010, and Excel 2013 treat this as 0x0 for security considerations.
<54> Section 2.4.853: If the workbook doesn’t contain a VBA project, Office Excel 2007, Excel 2010, and Excel 2013 will reset the strName to a default value when the project is created.
<55> Section 2.4.854: The following table shows the different versions of function accuracy Microsoft Excel supports.
|
Value |
Meaning |
|---|---|
|
0 |
Functions are calculated using the current application’s algorithms. |
|
1 |
Functions are calculated using algorithms implemented in Office Excel 2007. |
|
2 |
Functions are calculated using algorithms implemented in Excel 2010. |
<56> Section 2.5.1: Excel 2010, and Excel 2013 writes out 0x0E02 for this field.
<57> Section 2.5.1: Excel 2010, and Excel 2013 writes out 0x0000 for this field.
<58> Section 2.5.2: Versions of Excel prior to Excel LTSC 2024 will not ignore the iiftab field of the preceding BrtBeginSXDI (section 2.4.243).
<59> Section 2.5.4: In some cases, Office Excel 2007, Excel 2010, and Excel 2013 will save the formats associated with 0x0011 through 0x0014 as 0x0000 through 0x0003. In this case, the formats associated with 0x0000 through 0x0010 will be saved as 0x0004 through 0x0014.
<60> Section 2.5.6: Office Excel 2007, Excel 2010, and Excel 2013 can also write out 0.
<61> Section 2.5.29: The following table shows the maximum data functionality levels (section 2.2.5.1) that different versions of spreadsheet software support.
|
Value |
Maximum data functionality level for |
|---|---|
|
0 |
Excel 97 and Excel 2000 |
|
1 |
Excel 2002 and Office Excel 2003 |
|
3 |
Office Excel 2007 |
|
4 |
Excel 2010 |
|
5 |
Excel 2013 |
<62> Section 2.5.30: Office Excel 2007, Excel 2010, and Excel 2013 treat this value as the non-existent date February 29, 1900.
<63> Section 2.5.36: Office Excel 2007, Excel 2010, and Excel 2013 do not always write out the correct value in this field. Although the value of this field is validated on load, it is not used at run time.
<64> Section 2.5.36: Office Excel 2007, Excel 2010, and Excel 2013 do not always write out the correct value in this field. Although the value of this field is validated on load, it is not used at run time.
<65> Section 2.5.41: Office Excel 2007, Excel 2010, and Excel 2013 can write 0 for fPromptForFile.
<66> Section 2.5.51: Office Excel 2007, Excel 2010, and Excel 2013 can write out values 0x13 through 0x24.
<67> Section 2.5.62: Office Excel 2007 writes 0x0000 for this field. Excel 2010 writes 0x0E02 for this field.
<68> Section 2.5.62: Office Excel 2007, Excel 2010, and Excel 2013 write 0x0000 for this field.
<69> Section 2.5.95: Office Excel 2007, Excel 2010, and Excel 2013 use fixed values for some of the MdtFlags (section 2.5.95) flags regardless of the values specified in the structure. The specified values are preserved when the file is saved. The following table specifies the affected flags and their respective fixed values.
-
-
MdtFlags properties
Value
fGhostRw
0
fGhostCol
0
fDelete
0
fPasteAll
1
fPasteFmlas
1
fPasteValues
1
fPasteFmts
0
fPasteComments
0
fPasteDv
0
fPasteBorders
1
fPasteColWidths
0
fPasteNumFmts
0
fMerge
1
fSplitFirst
1
fSplitAll
0
fRwColShift
1
fClearAll
0
fClearContents
0
fClearComments
1
fCanCoerce
1
fAdjust
0
-
<70> Section 2.5.95: In Office Excel 2007, Excel 2010, and Excel 2013, examples of such functions are: IF, CHOOSE, VLOOKUP, and HLOOKUP.
<71> Section 2.5.95: Office Excel 2007, Excel 2010, and Excel 2013 write the reserved2 value as 1 for the MDX Metadata (section 2.2.4.8) metadata type (section 2.2.4.1).
<72> Section 2.5.98.14: Office Excel 2007, Excel 2010, and Excel 2013 can write out an rgce that contains PtgArray (section 2.5.98.23).
<73> Section 2.5.142: Office Excel 2007, Excel 2010, and Excel 2013 do not load a file in which this field contains a value that it does not recognize, or that is not recognized by the underlying operating system. Office Excel 2007, Excel 2010, and Excel 2013 recognize the following language tags:
|
Language |
Locale |
Language Tag |
|---|---|---|
|
Afrikaans |
South Africa |
af-ZA |
|
Albanian |
Albanian |
sq-AL |
|
Alsatian |
France |
gsw-FR |
|
Amharic |
Ethiopia |
am-ET |
|
Arabic |
Algeria |
ar-DZ |
|
Arabic |
Bahrain |
ar-BH |
|
Arabic |
Egypt |
ar-EG |
|
Arabic |
Iraq |
ar-IQ |
|
Arabic |
Jordan |
ar-JO |
|
Arabic |
Kuwait |
ar-KW |
|
Arabic |
Lebanon |
ar-LB |
|
Arabic |
Libya |
ar-LY |
|
Arabic |
Morocco |
ar-MA |
|
Arabic |
Oman |
ar-OM |
|
Arabic |
Qatar |
ar-QA |
|
Arabic |
Saudi Arabia |
ar-SA |
|
Arabic |
Syria |
ar-SY |
|
Arabic |
Tunisia |
ar-TN |
|
Arabic |
U.A.E. |
ar-AE |
|
Arabic |
Yemen |
ar-YE |
|
Armenian |
Armenia |
hy-AM |
|
Assamese |
India |
as-IN |
|
Azerbaijani (Cyrillic) |
Azerbaijan |
az-AZ-Cyrl |
|
Azerbaijani (Latin) |
Azerbaijan |
az-AZ-Latn |
|
Bangla |
Bangladesh |
bn-BD |
|
Bangla (Bangla Script) |
India |
bn-IN |
|
Bashkir |
Russia |
ba-RU |
|
Basque |
Basque (Basque) |
eu-ES |
|
Belarusian |
Belarus |
be-BY |
|
Bhutanese |
Bhutan |
bo-BT |
|
Bosnian (Cyrillic) |
Bosnia and Herzegovina |
bs-BA-Cyrl |
|
Bosnian (Latin) |
Bosnia and Herzegovina |
bs-BA-Latn |
|
Breton |
France |
br-FR |
|
Bulgarian |
Bulgaria |
bg-BG |
|
Catalan |
Catalan |
ca-ES |
|
Chinese |
Hong Kong SAR |
zh-HK |
|
Chinese |
Macao SAR |
zh-MO |
|
Chinese |
PRC |
zh-CN |
|
Chinese |
Singapore |
zh-SG |
|
Chinese |
Taiwan |
zh-TW |
|
Corsican |
France |
co-FR |
|
Croatian |
Croatia |
hr-HR |
|
Croatian (Latin) |
Bosnia and Herzegovina |
hr-BA-Latn |
|
Czech |
Czech Republic |
cs-CZ |
|
Danish |
Denmark |
da-DK |
|
Dari |
Afghanistan |
prs-AF |
|
Divehi |
Maldives |
div-MV |
|
Dutch |
Belgium |
nl-BE |
|
Dutch |
Netherlands |
nl-NL |
|
English |
Australia |
en-AU |
|
English |
Belize |
en-BZ |
|
English |
Canada |
en-CA |
|
English |
Caribbean |
en-CB |
|
English |
India |
en-IN |
|
English |
Ireland |
en-IE |
|
English |
Jamaica |
en-JM |
|
English |
Malaysia |
en-MY |
|
English |
New Zealand |
en-NZ |
|
English |
Philippines |
en-PH |
|
English |
South Africa |
en-ZA |
|
English |
Trinidad |
en-TT |
|
English |
United Kingdom |
en-GB |
|
English |
United States |
en-US |
|
English |
Zimbabwe |
en-ZW |
|
Estonian |
Estonia |
et-EE |
|
Faroese |
Faroe Islands |
fo-FO |
|
Filipino |
Philippines |
fil-PH |
|
Finnish |
Finland |
fi-FI |
|
French |
Belgium |
fr-BE |
|
French |
Canada |
fr-CA |
|
French |
France |
fr-FR |
|
French |
Luxembourg |
fr-LU |
|
French |
Monaco |
fr-MC |
|
French |
Switzerland |
fr-CH |
|
Frisian |
Netherlands |
fy-NL |
|
Galician |
Galician |
gl-ES |
|
Georgian |
Georgia |
ka-GE |
|
German |
Austria |
de-AT |
|
German |
Germany |
de-DE |
|
German |
Liechtenstein |
de-LI |
|
German |
Luxembourg |
de-LU |
|
German |
Switzerland |
de-CH |
|
Greek |
Greece |
el-GR |
|
Greenlandic |
Greenland |
kl-GL |
|
Gujarati (Gujarati Script) |
India |
gu-IN |
|
Hausa (Latin) |
Nigeria |
ha-NG-Latn |
|
Hebrew |
Israel |
he-IL |
|
Hindi |
India |
hi-IN |
|
Hungarian |
Hungary |
hu-HU |
|
Icelandic |
Iceland |
is-IS |
|
Igbo |
Nigeria |
ig-NG |
|
Inari Sami |
Finland |
smn-FI |
|
Indonesian |
Indonesia |
id-ID |
|
Inuktitut (Latin) |
Canada |
iu-CA-Latn |
|
Inuktitut (Syllabics) |
Canada |
iu-CA-Cans |
|
Irish |
Ireland |
ga-IE |
|
isiXhosa / Xhosa |
South Africa |
xh-ZA |
|
isiZulu / Zulu |
South Africa |
zu-ZA |
|
Italian |
Italy |
it-IT |
|
Italian |
Switzerland |
it-CH |
|
Japanese |
Japan |
ja-JP |
|
Kannada (Kannada Script) |
India |
kn-IN |
|
Kazakh |
Kazakhstan |
kk-KZ |
|
Khmer |
Cambodia |
kh-KH |
|
K'iche |
Guatemala |
qut-GT |
|
Kinyarwanda |
Rwanda |
rw-RW |
|
Konkani |
India |
kok-IN |
|
Korean |
Korea |
ko-KR |
|
Kyrgyz |
Kyrgyzstan |
ky-KG |
|
Lao |
Lao PDR |
lo-LA |
|
Latvian |
Latvia |
lv-LV |
|
Lithuanian |
Lithuania |
lt-LT |
|
Lower Sorbian |
Germany |
wee-DE |
|
Lule Sami |
Norway |
smj-NO |
|
Lule Sami |
Sweden |
smj-SE |
|
Luxembourgish |
Luxembourg |
lb-LU |
|
Macedonian |
Former Yugoslav Republic of Macedonia |
mk-MK |
|
Malay |
Brunei |
ms-BN |
|
Malay |
Malaysia |
ms-MY |
|
Malayalam (Malayalam Script) |
India |
ml-IN |
|
Maltese |
Malta |
mt-MT |
|
Maori |
New Zealand |
mi-NZ |
|
Mapudungun |
Chile |
arn-CL |
|
Marathi |
India |
mr-IN |
|
Mohawk |
Mohawk |
moh-CA |
|
Mongolian (Cyrillic) |
Mongolia |
mn-MN |
|
Mongolian (Mongolian) |
PRC |
mn-CN-Mong |
|
Nepali |
Nepal |
ne-NP |
|
Northern Sami |
Finland |
se-FI |
|
Northern Sami |
Norway |
se-NO |
|
Northern Sami |
Sweden |
se-SE |
|
Norwegian (Bokmål) |
Norway |
nb-NO |
|
Norwegian (Nynorsk) |
Norway |
nn-NO |
|
Occitan |
France |
oc-FR |
|
Odia |
India |
or-IN |
|
Pashto |
Afghanistan |
ps-AF |
|
Persian |
Iran |
fa-IR |
|
Polish |
Poland |
pl-PL |
|
Portuguese |
Brazil |
pt-BR |
|
Portuguese |
Portugal |
pt-PT |
|
Punjabi (Gurumukhi Script) |
India |
pa-IN |
|
Quechua |
Bolivia |
quz-BO |
|
Quechua |
Ecuador |
quz-EC |
|
Quechua |
Peru |
quz-PE |
|
Romanian |
Romania |
ro-RO |
|
Romansh |
Switzerland |
rm-CH |
|
Russian |
Russia |
ru-RU |
|
Sakha |
Russia |
sah-RU |
|
Sanskrit |
India |
sa-IN |
|
Serbian (Cyrillic) |
Bosnia and Herzegovina |
sr-BA-Cyrl |
|
Serbian (Cyrillic) |
Serbia |
sr-SP-Cyrl |
|
Serbian (Latin) |
Bosnia and Herzegovina |
sr-BA-Latn |
|
Serbian (Latin) |
Serbia |
sr-SP-Latn |
|
Sesotho sa Leboa / Northern Sotho |
South Africa |
ns-ZA |
|
Setswana / Tswana |
South Africa |
tn-ZA |
|
Sinhala |
Sri Lanka |
si-LK |
|
Skolt Sami |
Finland |
sms-FI |
|
Slovak |
Slovakia |
sk-SK |
|
Slovenian |
Slovenia |
sl-SI |
|
Southern Sami |
Norway |
sma-NO |
|
Southern Sami |
Sweden |
sma-SE |
|
Spanish |
Argentina |
es-AR |
|
Spanish |
Bolivia |
es-BO |
|
Spanish |
Chile |
es-CL |
|
Spanish |
Columbia |
es-CO |
|
Spanish |
Costa Rica |
es-CR |
|
Spanish |
Dominican Republic |
es-DO |
|
Spanish |
Ecuador |
es-EC |
|
Spanish |
El Salvador |
es-SV |
|
Spanish |
Guatemala |
es-GT |
|
Spanish |
Honduras |
es-HN |
|
Spanish |
Mexico |
es-MX |
|
Spanish |
Nicaragua |
es-NI |
|
Spanish |
Panama |
es-PA |
|
Spanish |
Paraguay |
es-PY |
|
Spanish |
Peru |
es-PE |
|
Spanish |
Puerto Rico |
es-PR |
|
Spanish |
Spain |
es-ES |
|
Spanish |
United States |
es-US |
|
Spanish |
Uruguay |
es-UY |
|
Spanish |
Venezuela |
es-VE |
|
Swahili |
Kenya |
sw-KE |
|
Swedish |
Finland |
sv-FI |
|
Swedish |
Sweden |
sv-SE |
|
Syriac |
Syria |
syr-SY |
|
Tajik (Cyrillic) |
Tajikistan |
tg-TJ-Cyrl |
|
Tamazight (Latin) |
Algeria |
tmz-DZ-Latn |
|
Tamil |
India |
ta-IN |
|
Tatar |
Russia |
tt-RU |
|
Telugu (Telugu Script) |
India |
te-IN |
|
Thai |
Thailand |
th-TH |
|
Tibetan |
PRC |
bo-CN |
|
Turkish |
Turkey |
tr-TR |
|
Turkmen |
Turkmenistan |
tk-TM |
|
Uighur |
PRC |
ug-CN |
|
Ukrainian |
Ukraine |
uk-UA |
|
Upper Sorbian |
Germany |
wen-DE |
|
Urdu |
Pakistan |
ur-PK |
|
Uzbek (Cyrillic) |
Uzbekistan |
uz-UZ-Cyrl |
|
Uzbek (Latin) |
Uzbekistan |
uz-UZ-Latn |
|
Vietnamese |
Viet Nam |
vi-VN |
|
Welsh |
United Kingdom |
cy-GB |
|
Wolof |
Senegal |
wo-SN |
|
Yi |
PRC |
ii-CN |
|
Yoruba |
Nigeria |
yo-NG |
<74> Section 2.5.172: Under certain circumstances, Office Excel 2007, Excel 2010, and Excel 2013 persist these values.
<75> Section 2.5.173: Office Excel 2007, Excel 2010, and Excel 2013 save a value of -1 on the lastSheet field for either a top-level or a sheet-level reference to an external book if an Information Rights Management (IRM) authorization failure occurred during a refresh of that book's data.