5 Appendix A: 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 Office Excel 2007

  • Microsoft Excel 2010

  • Microsoft Excel 2013

  • 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.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.3:  Excel 2010 added support for record types that have record type values greater than or equal to 1024.

<5> Section 2.4.16:  Excel 2010 and Excel 2013 do not save this record.

<6> Section 2.4.17:  Excel 2010 and Excel 2013 does not save this record.

<7> Section 2.4.22:  Excel 2010 saves out a DXFId instead.

<8> Section 2.4.67:  If this Web connection was created in Microsoft Excel 97 this field is always 1. Otherwise, this field is always 0.

<9> Section 2.4.67:  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 always 1. Otherwise, this field is always 0.

<10> Section 2.4.74:  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

<11> Section 2.4.83:  In certain scenarios, Office Excel 2007, Excel 2010, and Excel 2013 write out more than 0x000000CE BrtFmt records.

<12> Section 2.4.97:  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.

<13> Section 2.4.103:  Office Excel 2007, Excel 2010, and Excel 2013 will not load a file if kpiprop is equal to 0x00000005 or 0x00000006.

<14> Section 2.4.130:  If this value is greater than 0x00 and the fMixedTypesIgnoringBlanks field of the BrtBeginPCDFAtbl (section 2.4.127) record of the enclosing BrtBeginPCDField (section 2.4.132) record is 1, Office Excel 2007 will report a valid file as corrupt.

<15> Section 2.4.144:  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.

<16> Section 2.4.144:  Office Excel 2007 will not load a file with this string specified.

<17> Section 2.4.163:  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.

<18> Section 2.4.189:  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.

<19> Section 2.4.213:  Excel 2010 and Excel 2013 do not save this record.

<20> Section 2.4.214:  Excel 2010 and Excel 2013 do not save this record.

<21> Section 2.4.251:  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.

<22> Section 2.4.251:  Office Excel 2007 will not load a file if the pivot selection belongs to the page area.

<23> Section 2.4.266:  Office Excel 2007, Excel 2010, and Excel 2013 do not always save a value of 1 for OLAP PivotTables.

<24> Section 2.4.299:  If the value of the protpwdBook field of the BrtBookProtection (section 2.4.299) 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".

<25> Section 2.4.299:  If the value of the protpwdRev field of the BrtBookProtection (section 2.4.299) 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.300:  If the size of the rgbHash member of the ipdBookPasswordData field of the BrtBookProtectionIso (section 2.4.300) 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".

<27> Section 2.4.300:  If the size of the rgbHash member of the ipdRevPasswordData field of the BrtBookProtectionIso (section 2.4.300) 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.316:  Excel 2010 and Excel 2013 do not save this record.

<29> Section 2.4.316:  Office Excel 2007 will not correctly load files with a val greater than or equal to 256.

<30> Section 2.4.358:  Excel 2010 and Excel 2013 do not save this record.

<31> Section 2.4.359:  Excel 2010 and Excel 2013 do not save this record.

<32> Section 2.4.551:  Excel 2010 and Excel 2013 do not save this record.

<33> Section 2.4.552:  Excel 2010 and Excel 2013 do not save this record.

<34> Section 2.4.649:  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.

<35> Section 2.4.649:  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.

<36> Section 2.4.657:  This record is available only in Excel 2016.

<37> Section 2.4.694:  Office Excel 2007 does not ignore the preceding BrtBeginPCDField (section 2.4.132) of this record.

<38> Section 2.4.695:  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.

<39> Section 2.4.710:  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

<40> Section 2.4.726:  Office Excel 2007, Excel 2010, and Excel 2013 ignore this value on load and always write out 0.

<41> Section 2.4.729:  Office Excel 2007, Excel 2010, and Excel 2013 always write the value of fAccepted as 0 when converting from an [ISO/IEC29500-1:2011] 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.

<42> Section 2.4.735:  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.

<43> Section 2.4.759:  Excel 2010 and Excel 2013 do not save this record.

<44> Section 2.4.776:  Office Excel 2007 does not save cached values for OLE Data Items (section 2.2.7.4.3.1).

<45> Section 2.4.780:  Office Excel 2007 will not ignore the isxvdData field of the immediately preceding BrtBeginSXDI (section 2.4.234) record.

<46> Section 2.4.784:  Office Excel 2007 will not ignore the BrtBeginSXTH record preceding this record.

<47> Section 2.4.794:  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.794).fIgnorable is 0x01.

<48> Section 2.4.814:  Excel 2010 and Excel 2013 do not save this record.

<49> Section 2.4.815:  Office Excel 2007, Excel 2010, and Excel 2013 treat this as 0x0 for security considerations.

<50> Section 2.4.815:  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.

<51> Section 2.4.816:  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.

<52> Section 2.5.1:  Excel 2010, and Excel 2013 writes out 0x0E02 for this field.

<53> Section 2.5.1:  Excel 2010, and Excel 2013 writes out 0x0000 for this field.

<54> Section 2.5.3:  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.

<55> Section 2.5.5:  Office Excel 2007, Excel 2010, and Excel 2013 can also write out 0.

<56> Section 2.5.28:  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

<57> Section 2.5.29:  Office Excel 2007, Excel 2010, and Excel 2013 treat this value as the non-existent date February 29, 1900.

<58> Section 2.5.35:  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.

<59> Section 2.5.35:  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.

<60> Section 2.5.40:  Office Excel 2007, Excel 2010, and Excel 2013 can write 0 for fPromptForFile.

<61> Section 2.5.50:  Office Excel 2007, Excel 2010, and Excel 2013 can sometimes write out values 0x13 through 0x24.

<62> Section 2.5.61:  Office Excel 2007 writes 0x0000 for this field. Excel 2010 writes 0x0E02 for this field.

<63> Section 2.5.61:  Office Excel 2007, Excel 2010, and Excel 2013 write 0x0000 for this field.

<64> Section 2.5.94:  Office Excel 2007, Excel 2010, and Excel 2013 use fixed values for some of the MdtFlags (section 2.5.94) 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

<65> Section 2.5.94:  In Office Excel 2007, Excel 2010, and Excel 2013, examples of such functions are: IF, CHOOSE, VLOOKUP, and HLOOKUP.

<66> Section 2.5.94:  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).

<67> Section 2.5.97.14:  Office Excel 2007, Excel 2010, and Excel 2013 can sometimes write out an rgce that contains PtgArray (section 2.5.97.23).

<68> Section 2.5.141:  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

<69> Section 2.5.171:  Under certain circumstances, Office Excel 2007, Excel 2010, and Excel 2013 persist these values.

<70> Section 2.5.172:  Office Excel 2007, Excel 2010, and Excel 2013 can sometimes 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.

<71> Section 3.8.26:  This version is Office Excel 2007.

<72> Section 4: 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.

Show: