2.5.4 formatCode16
Target namespace: http://schemas.microsoft.com/office/spreadsheetml/2015/02/main
The formatCode16 attribute<8> is an ST_Xstring ([ISO/IEC29500-1:2016] section 22.9.2.19) attribute that specifies the number format codes for this number format. If present, the formatCode16 attribute takes precedence over the formatCode attribute ([ISO/IEC29500-1:2016] section 18.8.31).
The contents of the formatCode16 attribute are
identical to that of the formatCode attribute ([ISO/IEC29500-1:2016]
section 18.8.31), with the following modifications to the "International
Considerations" therein. The syntax for the formatCode16
attribute’s currency and locale/date system/number system information is [$<currency string>-<culture info>[,<calendar type and numeral system>]].
The currency string is the string to use as a currency symbol.
The culture info is a culture tag, which can be either an IETF language tag ([RFC5646]) or one of the following private use namespace tags.
|
Value |
Meaning |
|---|---|
|
x-sysdate |
System long date format. Cannot be combined with other culture tags. |
|
x-systime |
System time format. Cannot be combined with other culture tags. |
|
x-euro1 |
Trailing generic Euro currency. Cannot be combined with other culture tags. |
|
x-euro2 |
Leading generic Euro currency. Cannot be combined with other culture tags. |
|
x-genlower |
Use genitive lowercase form for any full month names in the format (Russian language only). Append to IETF language tag, for example, "ru-RU-x-genlower". |
|
x-genupper |
Use genitive uppercase form for any full month names in the format (Russian language only). Append to IETF language tag, for example, "ru-RU-x-genupper". |
|
x-nomlower |
Use nominative lowercase form for any full month names in the format (Russian language only). Append to IETF language tag, for example, "ru-RU-x-nomlower". |
|
x-xbt1 |
Trailing Bitcoin currency. Cannot be combined with other culture tags. |
|
x-xbt2 |
Leading Bitcoin currency. Cannot be combined with other culture tags. |
The optional calendar type and numeral system data is a 16-bit number in hexadecimal form that is placed after a culture tag, separated by a comma. The contents are defined by the formatCode attribute ([ISO/IEC29500-1:2016] section 18.8.31), with the following modification: The calendar type is stored in byte 0 (the least significant byte) and the numeral system is stored in byte 1 (the most significant byte).
The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this attribute.
-
<xsd:attribute name="formatCode16" type="x:ST_Xstring"/>
See section 5.11 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).