source/text/shared/01/05020301.xhp | 1256 ++++++++++++++++++-------------------
1 file changed, 628 insertions(+), 628 deletions(-)
New commits:
commit 001bc6f839d99b51a79eb398fc9f4317ccc9c60a
Author: Olivier Hallot <olivier.hal...@libreoffice.org>
AuthorDate: Fri Apr 7 19:12:56 2023 -0300
Commit: Olivier Hallot <olivier.hal...@libreoffice.org>
CommitDate: Sat Apr 8 01:38:40 2023 +0200
Adjust table and refactor
Change-Id: I477f9c35dcda50e2546c411b0a56f552e6e48ab9
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/150154
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hal...@libreoffice.org>
diff --git a/source/text/shared/01/05020301.xhp
b/source/text/shared/01/05020301.xhp
index 6a4a4c19ad..d5e862b46d 100644
--- a/source/text/shared/01/05020301.xhp
+++ b/source/text/shared/01/05020301.xhp
@@ -20,14 +20,14 @@
<meta>
<topic id="textshared0105020301xml" indexer="include">
- <title id="tit" xml-lang="en-US">Number Format Codes</title>
+ <title id="tit">Number Format Codes</title>
<filename>/text/shared/01/05020301.xhp</filename>
</topic>
</meta>
<body>
-<bookmark xml-lang="en-US" branch="index" id="bm_id3153514">
+<bookmark branch="index" id="bm_id3153514">
<bookmark_value>format codes; numbers</bookmark_value>
<bookmark_value>conditions; in number formats</bookmark_value>
<bookmark_value>number formats; codes</bookmark_value>
@@ -47,59 +47,59 @@
<comment>mw made "time formats" a two level entry and deleted 2x
"formats;"</comment>
<h1 id="hd_id3153514"><variable id="zahlenformatcodes"><link
href="text/shared/01/05020301.xhp">Number Format Codes</link> </variable></h1>
-<paragraph id="par_id3150467" role="paragraph" xml-lang="en-US">Number format
codes can consist of up to four sections separated by a semicolon
(<emph>;</emph>).</paragraph>
+<paragraph id="par_id3150467" role="paragraph">Number format codes can consist
of up to four sections separated by a semicolon (<emph>;</emph>).</paragraph>
<list type="ordered">
<listitem>
- <paragraph id="par_id3150146" role="listitem" xml-lang="en-US">In a number
format code with two sections, the first section applies to positive values and
zero, and the second section applies to negative values.</paragraph>
+ <paragraph id="par_id3150146" role="listitem">In a number format code with
two sections, the first section applies to positive values and zero, and the
second section applies to negative values.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id3158442" role="listitem" xml-lang="en-US">In a number
format code with three sections, the first section applies to positive values,
the second section to negative values, and the third section to the value
zero.</paragraph>
+ <paragraph id="par_id3158442" role="listitem">In a number format code with
three sections, the first section applies to positive values, the second
section to negative values, and the third section to the value zero.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id3155069" role="listitem" xml-lang="en-US">You can
also assign conditions to the three sections, so that the format is only
applied if a condition is met.</paragraph>
+ <paragraph id="par_id3155069" role="listitem">You can also assign
conditions to the three sections, so that the format is only applied if a
condition is met.</paragraph>
</listitem>
<listitem>
- <paragraph id="par_id3155070" role="listitem" xml-lang="en-US">Fourth
section applies if the content is not a value, but some text. Content is
represented by an at sign (<emph>@</emph>).</paragraph>
+ <paragraph id="par_id3155070" role="listitem">Fourth section applies if
the content is not a value, but some text. Content is represented by an at sign
(<emph>@</emph>).</paragraph>
</listitem>
</list>
<h2 id="hd_id3151262">Decimal Places and Significant Digits</h2>
- <paragraph id="par_id3153624" role="paragraph" xml-lang="en-US">Use zero
(<emph>0</emph>), the number sign (<emph>#</emph>) or the question mark
(<emph>?</emph>) as placeholders in your number format code to represent
numbers. The <emph>#</emph> only displays significant digits, while the
<emph>0</emph> displays zeroes if there are fewer digits in the number than in
the number format. The <emph>?</emph> works as the <emph>#</emph> but adds a
space character to keep decimal alignment if there is a hidden non-significant
zero.</paragraph>
- <paragraph id="par_id3153323" role="paragraph" xml-lang="en-US">Use question
marks (<emph>?</emph>), zeroes (<emph>0</emph>) or number signs
(<emph>#</emph>) to represent the number of digits to include in the numerator
and the denominator of a fraction. Fractions that do not fit the pattern that
you define are displayed as floating point numbers.</paragraph>
-<paragraph id="par_id3148440" role="paragraph" xml-lang="en-US">If a number
contains more digits to the right of the decimal delimiter than there are
placeholders in the format, the number is rounded accordingly. If a number
contains more digits to the left of the decimal delimiter than there are
placeholders in the format, the entire number is displayed. Use the following
list as a guide for using placeholders when you create a number format
code:</paragraph>
+ <paragraph id="par_id3153624" role="paragraph">Use zero (<emph>0</emph>),
the number sign (<emph>#</emph>) or the question mark (<emph>?</emph>) as
placeholders in your number format code to represent numbers. The
<emph>#</emph> only displays significant digits, while the <emph>0</emph>
displays zeroes if there are fewer digits in the number than in the number
format. The <emph>?</emph> works as the <emph>#</emph> but adds a space
character to keep decimal alignment if there is a hidden non-significant
zero.</paragraph>
+ <paragraph id="par_id3153323" role="paragraph">Use question marks
(<emph>?</emph>), zeroes (<emph>0</emph>) or number signs (<emph>#</emph>) to
represent the number of digits to include in the numerator and the denominator
of a fraction. Fractions that do not fit the pattern that you define are
displayed as floating point numbers.</paragraph>
+<paragraph id="par_id3148440" role="paragraph">If a number contains more
digits to the right of the decimal delimiter than there are placeholders in the
format, the number is rounded accordingly. If a number contains more digits to
the left of the decimal delimiter than there are placeholders in the format,
the entire number is displayed. Use the following list as a guide for using
placeholders when you create a number format code:</paragraph>
<table id="tbl_id3149760">
<tablerow>
<tablecell>
- <paragraph id="par_id3150902" role="tablehead"
xml-lang="en-US">Placeholders</paragraph>
+ <paragraph id="par_id3150902" role="tablehead">Placeholders</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3157896" role="tablehead"
xml-lang="en-US">Explanation</paragraph>
+ <paragraph id="par_id3157896" role="tablehead">Explanation</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152801" role="code" localize="false"
xml-lang="en-US">#</paragraph>
+ <paragraph id="par_id3152801" role="code" localize="false">#</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145090" role="tablecontent" xml-lang="en-US">Does
not display extra zeros.</paragraph>
+ <paragraph id="par_id3145090" role="tablecontent">Does not display extra
zeros.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152802" role="code" localize="false"
xml-lang="en-US">?</paragraph>
+ <paragraph id="par_id3152802" role="code" localize="false">?</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145091" role="tablecontent"
xml-lang="en-US">Displays space characters instead of extra zeros.</paragraph>
+ <paragraph id="par_id3145091" role="tablecontent">Displays space
characters instead of extra zeros.</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147088" role="code" xml-lang="en-US">0
(Zero)</paragraph>
+ <paragraph id="par_id3147088" role="code">0 (Zero)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150774" role="tablecontent"
xml-lang="en-US">Displays extra zeros if the number has less places than zeros
in the format.</paragraph>
+ <paragraph id="par_id3150774" role="tablecontent">Displays extra zeros
if the number has less places than zeros in the format.</paragraph>
</tablecell>
</tablerow>
</table>
@@ -110,89 +110,89 @@
<table id="tbl_id3153577">
<tablerow>
<tablecell>
- <paragraph id="par_id3149182" role="tablehead" xml-lang="en-US">Number
Format</paragraph>
+ <paragraph id="par_id3149182" role="tablehead">Number Format</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154749" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ <paragraph id="par_id3154749" role="tablehead">Format Code</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3148538" role="tablecontent"
xml-lang="en-US">3456.78 as 3456.8</paragraph>
+ <paragraph id="par_id3148538" role="tablecontent">3456.78 as
3456.8</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150355" role="code" localize="false"
xml-lang="en-US">####.#</paragraph>
+ <paragraph id="par_id3150355" role="code"
localize="false">####.#</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154142" role="tablecontent" xml-lang="en-US">9.9
as 9.900</paragraph>
+ <paragraph id="par_id3154142" role="tablecontent">9.9 as
9.900</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159256" role="code" localize="false"
xml-lang="en-US">#.000</paragraph>
+ <paragraph id="par_id3159256" role="code"
localize="false">#.000</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147077" role="tablecontent" xml-lang="en-US">13 as
13.0 and 1234.567 as 1234.57</paragraph>
+ <paragraph id="par_id3147077" role="tablecontent">13 as 13.0 and
1234.567 as 1234.57</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155388" role="code" localize="false"
xml-lang="en-US">#.0#</paragraph>
+ <paragraph id="par_id3155388" role="code"
localize="false">#.0#</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3149578" role="tablecontent" xml-lang="en-US">5.75
as 5 3/4 and 6.3 as 6 3/10</paragraph>
+ <paragraph id="par_id3149578" role="tablecontent">5.75 as 5 3/4 and 6.3
as 6 3/10</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145315" role="code" localize="false"
xml-lang="en-US"># ???/???</paragraph>
+ <paragraph id="par_id3145315" role="code" localize="false">#
???/???</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3156152" role="tablecontent" xml-lang="en-US">.5 as
0.5</paragraph>
+ <paragraph id="par_id3156152" role="tablecontent">.5 as 0.5</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149762" role="code" localize="false"
xml-lang="en-US">0.##</paragraph>
+ <paragraph id="par_id3149762" role="code"
localize="false">0.##</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3156153" role="tablecontent" xml-lang="en-US">.5 as
0.5 (with two extra spaces at the end)</paragraph>
+ <paragraph id="par_id3156153" role="tablecontent">.5 as 0.5 (with two
extra spaces at the end)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149763" role="code" localize="false"
xml-lang="en-US">0.???</paragraph>
+ <paragraph id="par_id3149763" role="code"
localize="false">0.???</paragraph>
</tablecell>
</tablerow>
</table>
<h3 id="hd_id3149276">Thousands Separator</h3>
-<paragraph id="par_id3154380" role="paragraph" xml-lang="en-US">Depending on
your language setting, you can use a comma, a period or a blank as a thousands
separator. You can also use the separator to reduce the size of the number that
is displayed by a multiple of 1000 for each separator. The examples below use
comma as thousands separator:</paragraph>
+<paragraph id="par_id3154380" role="paragraph">Depending on your language
setting, you can use a comma, a period or a blank as a thousands separator. You
can also use the separator to reduce the size of the number that is displayed
by a multiple of 1000 for each separator. The examples below use comma as
thousands separator:</paragraph>
<table id="tbl_id3150244">
<tablerow>
<tablecell>
- <paragraph id="par_id3154905" role="tablehead" xml-lang="en-US">Number
Format</paragraph>
+ <paragraph id="par_id3154905" role="tablehead">Number Format</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150822" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ <paragraph id="par_id3150822" role="tablehead">Format Code</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147264" role="tablecontent" xml-lang="en-US">15000
as 15,000</paragraph>
+ <paragraph id="par_id3147264" role="tablecontent">15000 as
15,000</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151223" role="code" localize="false"
xml-lang="en-US">#,###</paragraph>
+ <paragraph id="par_id3151223" role="code"
localize="false">#,###</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154935" role="tablecontent" xml-lang="en-US">16000
as 16</paragraph>
+ <paragraph id="par_id3154935" role="tablecontent">16000 as 16</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153961" role="code" localize="false"
xml-lang="en-US">#,</paragraph>
+ <paragraph id="par_id3153961" role="code" localize="false">#,</paragraph>
</tablecell>
</tablerow>
</table>
@@ -201,52 +201,52 @@
<h2 id="hd_id3154836">Including Text in Number Format Codes</h2>
<h3 id="hd_id3150398">Text and Numbers</h3>
-<paragraph id="par_id3154224" role="paragraph" xml-lang="en-US">To include
text in a number format that is applied to a cell containing numbers, place a
double quotation mark (") in front of and behind the text, or a backslash (\)
before a single character. For example, enter <emph>#.# "meters"</emph> to
display "3.5 meters" or <emph>#.# \m</emph> to display "3.5 m". If you use
space as thousands separator, you need to insert spaces between quotes in the
previous examples: <emph>#.#" meters"</emph> or <emph>#.#\ \m</emph> to get the
correct result.</paragraph>
+<paragraph id="par_id3154224" role="paragraph">To include text in a number
format that is applied to a cell containing numbers, place a double quotation
mark (") in front of and behind the text, or a backslash (\) before a single
character. For example, enter <emph>#.# "meters"</emph> to display "3.5 meters"
or <emph>#.# \m</emph> to display "3.5 m". If you use space as thousands
separator, you need to insert spaces between quotes in the previous examples:
<emph>#.#" meters"</emph> or <emph>#.#\ \m</emph> to get the correct
result.</paragraph>
<h3 id="hd_id3148979">Text and Text</h3>
-<paragraph id="par_id3153338" role="paragraph" xml-lang="en-US">To include
text in a number format that is applied to a cell that might contain text,
enclose the text by double quotation marks (" "), and then add an at sign (@).
For example, enter <emph>"Total for "@</emph> to display "Total for
December".</paragraph>
+<paragraph id="par_id3153338" role="paragraph">To include text in a number
format that is applied to a cell that might contain text, enclose the text by
double quotation marks (" "), and then add an at sign (@). For example, enter
<emph>"Total for "@</emph> to display "Total for December".</paragraph>
<h3 id="hd_id3154330">Spaces</h3>
-<paragraph id="par_id3156294" role="paragraph" xml-lang="en-US">To use a
character to define the width of a space in a number format, type an underscore
(<emph>_</emph>) followed by the character. The width of the space varies
according to the width of the character that you choose. For example,
<emph>_M</emph> creates a wider space than <emph>_i</emph>.</paragraph>
-<paragraph id="par_id3156295" role="paragraph" xml-lang="en-US">To fill free
space with a given character, use an asterisk (<emph>*</emph>) followed by this
character. For instance:</paragraph>
-<paragraph id="par_id3156296" role="code" localize="false"
xml-lang="en-US">*\0</paragraph>
-<paragraph id="par_id3156297" role="paragraph" xml-lang="en-US">will display
integer value (0) preceded by as many as needed backslash characters
(<emph>\</emph>) to fill column width. For accounting representation, you may
left align currency symbol with a format similar to:</paragraph>
-<paragraph id="par_id3156298" role="code" localize="false"
xml-lang="en-US">$_-* 0.--;$-* 0.--;$_-* -</paragraph>
+<paragraph id="par_id3156294" role="paragraph">To use a character to define
the width of a space in a number format, type an underscore (<emph>_</emph>)
followed by the character. The width of the space varies according to the width
of the character that you choose. For example, <emph>_M</emph> creates a wider
space than <emph>_i</emph>.</paragraph>
+<paragraph id="par_id3156295" role="paragraph">To fill free space with a given
character, use an asterisk (<emph>*</emph>) followed by this character. For
instance:</paragraph>
+<paragraph id="par_id3156296" role="code" localize="false">*\0</paragraph>
+<paragraph id="par_id3156297" role="paragraph">will display integer value (0)
preceded by as many as needed backslash characters (<emph>\</emph>) to fill
column width. For accounting representation, you may left align currency symbol
with a format similar to:</paragraph>
+<paragraph id="par_id3156298" role="code" localize="false">$_-* 0.--;$-*
0.--;$_-* -</paragraph>
<h2 id="hd_id3155994">Color</h2>
-<paragraph id="par_id3156423" role="paragraph" xml-lang="en-US">To set the
color of a section of a number format code, insert one of the following color
names in square brackets [ ]:</paragraph>
+<paragraph id="par_id3156423" role="paragraph">To set the color of a section
of a number format code, insert one of the following color names in square
brackets [ ]:</paragraph>
<table id="tbl_id3157321">
<tablerow>
<tablecell>
- <paragraph id="par_id3154630" role="code" localize="false"
xml-lang="en-US">CYAN</paragraph>
+ <paragraph id="par_id3154630" role="code"
localize="false">CYAN</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3148676" role="code" localize="false"
xml-lang="en-US">GREEN</paragraph>
+ <paragraph id="par_id3148676" role="code"
localize="false">GREEN</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154123" role="code" localize="false"
xml-lang="en-US">BLACK</paragraph>
+ <paragraph id="par_id3154123" role="code"
localize="false">BLACK</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149167" role="code" localize="false"
xml-lang="en-US">BLUE</paragraph>
+ <paragraph id="par_id3149167" role="code"
localize="false">BLUE</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3158407" role="code" localize="false"
xml-lang="en-US">MAGENTA</paragraph>
+ <paragraph id="par_id3158407" role="code"
localize="false">MAGENTA</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149560" role="code" localize="false"
xml-lang="en-US">RED</paragraph>
+ <paragraph id="par_id3149560" role="code"
localize="false">RED</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147502" role="code" localize="false"
xml-lang="en-US">WHITE</paragraph>
+ <paragraph id="par_id3147502" role="code"
localize="false">WHITE</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153368" role="code" localize="false"
xml-lang="en-US">YELLOW</paragraph>
+ <paragraph id="par_id3153368" role="code"
localize="false">YELLOW</paragraph>
</tablecell>
</tablerow>
</table>
@@ -255,283 +255,283 @@
<h2 id="hd_id3147435">Conditions</h2>
<h3 id="hd_id3148575">Conditional Brackets</h3>
-<paragraph id="par_id3155312" role="paragraph" xml-lang="en-US">You can define
a number format so that it only applies when the condition that you specify is
met. Conditions are enclosed by square brackets [ ].</paragraph>
-<paragraph id="par_id3159179" role="paragraph" xml-lang="en-US">You can use
any combination of numbers and the <, <=, >, >=, = and <>
operators.</paragraph>
-<paragraph id="par_id3159196" role="paragraph" xml-lang="en-US">For example,
if you want to apply different colors to different temperature data,
enter:</paragraph>
-<paragraph id="par_id3150872" role="example" localize="false"
xml-lang="en-US">[BLUE][<0]#.0 "°C";[RED][>30]#.0 "°C";[BLACK]#.0
"°C"</paragraph>
-<paragraph id="par_id3157870" role="paragraph" xml-lang="en-US">All
temperatures below zero are blue, temperatures between 0 and 30 °C are black,
and temperatures higher than 30 °C are red.</paragraph>
+<paragraph id="par_id3155312" role="paragraph">You can define a number format
so that it only applies when the condition that you specify is met. Conditions
are enclosed by square brackets [ ].</paragraph>
+<paragraph id="par_id3159179" role="paragraph">You can use any combination of
numbers and the <, <=, >, >=, = and <> operators.</paragraph>
+<paragraph id="par_id3159196" role="paragraph">For example, if you want to
apply different colors to different temperature data, enter:</paragraph>
+<paragraph id="par_id3150872" role="example" localize="false">[BLUE][<0]#.0
"°C";[RED][>30]#.0 "°C";[BLACK]#.0 "°C"</paragraph>
+<paragraph id="par_id3157870" role="paragraph">All temperatures below zero are
blue, temperatures between 0 and 30 °C are black, and temperatures higher than
30 °C are red.</paragraph>
<h3 id="hd_id3154833">Positive and Negative Numbers</h3>
-<paragraph id="par_id3147295" role="paragraph" xml-lang="en-US">To define a
number format that adds a different text to a number depending on if the number
is positive, negative, or equal to zero, use the following format:</paragraph>
-<paragraph id="par_id3153727" role="example" xml-lang="en-US">"plus" 0;"minus"
0;"null" 0</paragraph>
+<paragraph id="par_id3147295" role="paragraph">To define a number format that
adds a different text to a number depending on if the number is positive,
negative, or equal to zero, use the following format:</paragraph>
+<paragraph id="par_id3153727" role="example">"plus" 0;"minus" 0;"null"
0</paragraph>
<h2 id="hd_id3149260">Percentages, Scientific Notation and Fraction
Representation</h2>
<h3 id="hd_id3147218">Percentages</h3>
-<paragraph id="par_id3151168" role="paragraph" xml-lang="en-US">To display
numbers as percentages, add the percent sign (<emph>%</emph>) to the number
format.</paragraph>
+<paragraph id="par_id3151168" role="paragraph">To display numbers as
percentages, add the percent sign (<emph>%</emph>) to the number
format.</paragraph>
<h3 id="hd_id3156005">Scientific Notation</h3>
-<paragraph id="par_id3146923" role="paragraph" xml-lang="en-US">Scientific
notation lets you write very large numbers or very small fractions in a compact
form. For example, in scientific notation, 650000 is written as 6.5 x
10<sup>5</sup>, and 0.000065 as 6.5 x 10<sup>-5</sup>. <comment>Translators:
use the decimal delimiter of your language (period or comma) for all number
format codes in Calc.</comment>In <item type="productname">%PRODUCTNAME</item>,
these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a
number format that displays numbers using scientific notation, enter a # or 0,
and then one of the following codes E-, E+, e- or e+. If sign is omitted after
E or e, it won't appear for positive value of exponent. To get engineering
notation, enter 3 digits (0 or #) in the integer part: <emph>###.##E+00</emph>
for instance.</paragraph>
+<paragraph id="par_id3146923" role="paragraph">Scientific notation lets you
write very large numbers or very small fractions in a compact form. For
example, in scientific notation, 650000 is written as 6.5 x 10<sup>5</sup>, and
0.000065 as 6.5 x 10<sup>-5</sup>. <comment>Translators: use the decimal
delimiter of your language (period or comma) for all number format codes in
Calc.</comment>In <item type="productname">%PRODUCTNAME</item>, these numbers
are written as 6.5E+5 and 6.5E-5, respectively. To create a number format that
displays numbers using scientific notation, enter a # or 0, and then one of the
following codes E-, E+, e- or e+. If sign is omitted after E or e, it won't
appear for positive value of exponent. To get engineering notation, enter 3
digits (0 or #) in the integer part: <emph>###.##E+00</emph> for
instance.</paragraph>
<h3 id="hd_id3156006">Fraction Representation</h3>
-<paragraph id="par_id3146924" role="paragraph" xml-lang="en-US">To represent a
value as a fraction, format consists of two or three parts: integer optional
part, numerator and denominator. Integer and numerator are separated by a blank
or any quoted text. Numerator and denominator are separated by a slash
character. Each part can consist of a combination of #, ? and 0 as
placeholders.</paragraph>
-<paragraph id="par_id3146925" role="paragraph" xml-lang="en-US">Denominator is
calculated to get the nearest value of the fraction with respect to the number
of placeholders. For example, PI value is represented as 3 16/113 with
format:</paragraph>
-<paragraph id="par_id3146926" role="example" localize="false"
xml-lang="en-US"># ?/???</paragraph>
-<paragraph id="par_id3146927" role="paragraph" xml-lang="en-US">Denominator
value can also be forced to the value replacing placeholders. For example, to
get PI value as a multiple of 1/16th (i.e. 50/16), use format:</paragraph>
-<paragraph id="par_id3146929" role="example" localize="false"
xml-lang="en-US">?/16</paragraph>
+<paragraph id="par_id3146924" role="paragraph">To represent a value as a
fraction, format consists of two or three parts: integer optional part,
numerator and denominator. Integer and numerator are separated by a blank or
any quoted text. Numerator and denominator are separated by a slash character.
Each part can consist of a combination of #, ? and 0 as
placeholders.</paragraph>
+<paragraph id="par_id3146925" role="paragraph">Denominator is calculated to
get the nearest value of the fraction with respect to the number of
placeholders. For example, PI value is represented as 3 16/113 with
format:</paragraph>
+<paragraph id="par_id3146926" role="example" localize="false">#
?/???</paragraph>
+<paragraph id="par_id3146927" role="paragraph">Denominator value can also be
forced to the value replacing placeholders. For example, to get PI value as a
multiple of 1/16th (i.e. 50/16), use format:</paragraph>
+<paragraph id="par_id3146929" role="example" localize="false">?/16</paragraph>
<h2 id="hd_id3159080">Number Format Codes of Currency Formats</h2>
-<paragraph id="par_id3147318" role="paragraph" xml-lang="en-US">The default
currency format for the cells in your spreadsheet is determined by the regional
setting of your operating system. If you want, you can apply a custom currency
symbol to a cell. For example, enter #,##0.00 € to display 4.50 €
(Euros).<comment>Translators: use the decimal delimiter of your language
(period or comma) for all number format codes in Calc.</comment></paragraph>
-<paragraph id="par_id3150032" role="paragraph" xml-lang="en-US">You can also
specify the locale setting for the currency by entering the locale code for the
country after the symbol. For example, <emph>[$€-407]</emph> represents Euros
in Germany. To view the locale code for a country, select the country in the
<emph>Language</emph> list on the <emph>Numbers</emph> tab of the <emph>Format
Cells</emph> dialog.</paragraph>
+<paragraph id="par_id3147318" role="paragraph">The default currency format for
the cells in your spreadsheet is determined by the regional setting of your
operating system. If you want, you can apply a custom currency symbol to a
cell. For example, enter #,##0.00 € to display 4.50 €
(Euros).<comment>Translators: use the decimal delimiter of your language
(period or comma) for all number format codes in Calc.</comment></paragraph>
+<paragraph id="par_id3150032" role="paragraph">You can also specify the locale
setting for the currency by entering the locale code for the country after the
symbol. For example, <emph>[$€-407]</emph> represents Euros in Germany. To view
the locale code for a country, select the country in the <emph>Language</emph>
list on the <emph>Numbers</emph> tab of the <emph>Format Cells</emph>
dialog.</paragraph>
<embed href="text/shared/01/05020300.xhp#currencytext"/>
<h2 id="hd_id3157309">Date and Time Formats</h2>
<h3 id="hd_id3153740">Date Formats</h3>
-<paragraph id="par_id3152791" role="paragraph" xml-lang="en-US">To display
days, months and years, use the following number format codes. </paragraph>
-<paragraph id="par_id610980" role="warning" xml-lang="en-US">Not all format
codes give meaningful results for all languages.</paragraph>
+<paragraph id="par_id3152791" role="paragraph">To display days, months and
years, use the following number format codes. </paragraph>
+<warning id="par_id610980">Not all format codes give meaningful results for
all languages.</warning>
<table id="tbl_id3147426">
<tablerow>
<tablecell>
- <paragraph id="par_id3152376" role="tablehead"
xml-lang="en-US">Format</paragraph>
+ <paragraph id="par_id3152376" role="tablehead">Format</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159130" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ <paragraph id="par_id3159130" role="tablehead">Format Code</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147380" role="tablecontent" xml-lang="en-US">Month
as 3.</paragraph>
+ <paragraph id="par_id3147380" role="tablecontent">Month as 3.</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146928" role="code" localize="false"
xml-lang="en-US">M</paragraph>
+ <paragraph id="par_id3146928" role="code" localize="false">M</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3145594" role="tablecontent" xml-lang="en-US">Month
as 03.</paragraph>
+ <paragraph id="par_id3145594" role="tablecontent">Month as
03.</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153052" role="code" localize="false"
xml-lang="en-US">MM</paragraph>
+ <paragraph id="par_id3153052" role="code" localize="false">MM</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3145728" role="tablecontent" xml-lang="en-US">Month
as Jan-Dec</paragraph>
+ <paragraph id="par_id3145728" role="tablecontent">Month as
Jan-Dec</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151073" role="code" localize="false"
xml-lang="en-US">MMM</paragraph>
+ <paragraph id="par_id3151073" role="code"
localize="false">MMM</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3149909" role="tablecontent" xml-lang="en-US">Month
as January-December</paragraph>
+ <paragraph id="par_id3149909" role="tablecontent">Month as
January-December</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155318" role="code" localize="false"
xml-lang="en-US">MMMM</paragraph>
+ <paragraph id="par_id3155318" role="code"
localize="false">MMMM</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3151218" role="tablecontent" xml-lang="en-US">First
letter of Name of Month</paragraph>
+ <paragraph id="par_id3151218" role="tablecontent">First letter of Name
of Month</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150420" role="code" localize="false"
xml-lang="en-US">MMMMM</paragraph>
+ <paragraph id="par_id3150420" role="code"
localize="false">MMMMM</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154501" role="tablecontent" xml-lang="en-US">Day
as 2</paragraph>
+ <paragraph id="par_id3154501" role="tablecontent">Day as 2</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156181" role="code" localize="false"
xml-lang="en-US">D</paragraph>
+ <paragraph id="par_id3156181" role="code" localize="false">D</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3146969" role="tablecontent" xml-lang="en-US">Day
as 02</paragraph>
+ <paragraph id="par_id3146969" role="tablecontent">Day as 02</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156358" role="code" localize="false"
xml-lang="en-US">DD</paragraph>
+ <paragraph id="par_id3156358" role="code" localize="false">DD</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3148495" role="tablecontent" xml-lang="en-US">Day
as Sun-Sat</paragraph>
+ <paragraph id="par_id3148495" role="tablecontent">Day as
Sun-Sat</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3161665" role="code" localize="false"
xml-lang="en-US">NN or DDD or AAA</paragraph>
+ <paragraph id="par_id3161665" role="code" localize="false">NN or DDD or
AAA</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154272" role="tablecontent" xml-lang="en-US">Day
as Sunday to Saturday</paragraph>
+ <paragraph id="par_id3154272" role="tablecontent">Day as Sunday to
Saturday</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145164" role="code" localize="false"
xml-lang="en-US">NNN or DDDD or AAAA</paragraph>
+ <paragraph id="par_id3145164" role="code" localize="false">NNN or DDDD
or AAAA</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3146791" role="tablecontent" xml-lang="en-US">Day
followed by comma, as in "Sunday,"</paragraph>
+ <paragraph id="par_id3146791" role="tablecontent">Day followed by comma,
as in "Sunday,"</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146081" role="code" localize="false"
xml-lang="en-US">NNNN</paragraph>
+ <paragraph id="par_id3146081" role="code"
localize="false">NNNN</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3156275" role="tablecontent" xml-lang="en-US">Year
as 00-99</paragraph>
+ <paragraph id="par_id3156275" role="tablecontent">Year as
00-99</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3143236" role="code" localize="false"
xml-lang="en-US">YY</paragraph>
+ <paragraph id="par_id3143236" role="code" localize="false">YY</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3148408" role="tablecontent" xml-lang="en-US">Year
as 1900-2078</paragraph>
+ <paragraph id="par_id3148408" role="tablecontent">Year as
1900-2078</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151358" role="code" localize="false"
xml-lang="en-US">YYYY</paragraph>
+ <paragraph id="par_id3151358" role="code"
localize="false">YYYY</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3153355" role="tablecontent"
xml-lang="en-US">Calendar week</paragraph>
+ <paragraph id="par_id3153355" role="tablecontent">Calendar
week</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150744" role="code" localize="false"
xml-lang="en-US">WW</paragraph>
+ <paragraph id="par_id3150744" role="code" localize="false">WW</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154302" role="tablecontent"
xml-lang="en-US">Quarterly as Q1 to Q4</paragraph>
+ <paragraph id="par_id3154302" role="tablecontent">Quarterly as Q1 to
Q4</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159266" role="code" localize="false"
xml-lang="en-US">Q</paragraph>
+ <paragraph id="par_id3159266" role="code" localize="false">Q</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147583" role="tablecontent"
xml-lang="en-US">Quarterly as 1st quarter to 4th quarter</paragraph>
+ <paragraph id="par_id3147583" role="tablecontent">Quarterly as 1st
quarter to 4th quarter</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146918" role="code" localize="false"
xml-lang="en-US">QQ</paragraph>
+ <paragraph id="par_id3146918" role="code" localize="false">QQ</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147534" role="tablecontent" xml-lang="en-US">Era,
abbreviation. On the Japanese Gengou calendar, single character (possible
values are: M, T, S, H)</paragraph>
+ <paragraph id="par_id3147534" role="tablecontent">Era, abbreviation. On
the Japanese Gengou calendar, single character (possible values are: M, T, S,
H)</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151249" role="code" localize="false"
xml-lang="en-US">G</paragraph>
+ <paragraph id="par_id3151249" role="code" localize="false">G</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3163806" role="tablecontent" xml-lang="en-US">Era,
abbreviation</paragraph>
+ <paragraph id="par_id3163806" role="tablecontent">Era,
abbreviation</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155962" role="code" localize="false"
xml-lang="en-US">GG</paragraph>
+ <paragraph id="par_id3155962" role="code" localize="false">GG</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3151187" role="tablecontent" xml-lang="en-US">Era,
full name</paragraph>
+ <paragraph id="par_id3151187" role="tablecontent">Era, full
name</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149568" role="code" localize="false"
xml-lang="en-US">GGG</paragraph>
+ <paragraph id="par_id3149568" role="code"
localize="false">GGG</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3147344" role="tablecontent"
xml-lang="en-US">Number of the year within an era, short format</paragraph>
+ <paragraph id="par_id3147344" role="tablecontent">Number of the year
within an era, short format</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147255" role="code" localize="false"
xml-lang="en-US">E</paragraph>
+ <paragraph id="par_id3147255" role="code" localize="false">E</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3148487" role="tablecontent"
xml-lang="en-US">Number of the year within an era, long format</paragraph>
+ <paragraph id="par_id3148487" role="tablecontent">Number of the year
within an era, long format</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150298" role="code" xml-lang="en-US">EE or
R</paragraph>
+ <paragraph id="par_id3150298" role="code">EE or R</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152861" role="tablecontent" xml-lang="en-US">Era,
full name and year</paragraph>
+ <paragraph id="par_id3152861" role="tablecontent">Era, full name and
year</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149926" role="code" xml-lang="en-US">RR or
GGGEE</paragraph>
+ <paragraph id="par_id3149926" role="code">RR or GGGEE</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph id="par_id1002200811423518" role="paragraph" xml-lang="en-US">The
above listed formatting codes work with your language version of %PRODUCTNAME.
However, when you need to switch the locale of %PRODUCTNAME to another locale,
you need to know the formatting codes used in that other locale.</paragraph>
-<paragraph id="par_id1002200811423556" role="paragraph" xml-lang="en-US">For
example, if your software is set to an English locale, and you want to format a
year with four digits, you enter YYYY as a formatting code. When you switch to
a German locale, you must use JJJJ instead. The following table lists only the
localized differences.</paragraph>
+<paragraph id="par_id1002200811423518" role="paragraph">The above listed
formatting codes work with your language version of %PRODUCTNAME. However, when
you need to switch the locale of %PRODUCTNAME to another locale, you need to
know the formatting codes used in that other locale.</paragraph>
+<paragraph id="par_id1002200811423556" role="paragraph">For example, if your
software is set to an English locale, and you want to format a year with four
digits, you enter YYYY as a formatting code. When you switch to a German
locale, you must use JJJJ instead. The following table lists only the localized
differences.</paragraph>
<table id="tbl_id1002200811465915">
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811563044" role="tablehead"
xml-lang="en-US">Locale</paragraph>
+ <paragraph id="par_id1002200811563044"
role="tablehead">Locale</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563137" role="tablehead"
xml-lang="en-US">Year</paragraph>
+ <paragraph id="par_id1002200811563137" role="tablehead">Year</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563164" role="tablehead"
xml-lang="en-US">Month</paragraph>
+ <paragraph id="par_id1002200811563164" role="tablehead">Month</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563128" role="tablehead"
xml-lang="en-US">Day</paragraph>
+ <paragraph id="par_id1002200811563128" role="tablehead">Day</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563135" role="tablehead"
xml-lang="en-US">Hour</paragraph>
+ <paragraph id="par_id1002200811563135" role="tablehead">Hour</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563289" role="tablehead"
xml-lang="en-US">Day Of Week</paragraph>
+ <paragraph id="par_id1002200811563289" role="tablehead">Day Of
Week</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id100220081156322" role="tablehead"
xml-lang="en-US">Era</paragraph>
+ <paragraph id="par_id100220081156322" role="tablehead">Era</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811563233" role="tablecontent"
localize="false" xml-lang="en-US">English - en</paragraph>
- <paragraph id="par_id1002200811563243" role="tablecontent"
xml-lang="en-US">and all not listed locales</paragraph>
+ <paragraph id="par_id1002200811563233" role="tablecontent"
localize="false">English - en</paragraph>
+ <paragraph id="par_id1002200811563243" role="tablecontent">and all not
listed locales</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563352" role="tablecontent"
localize="false" xml-lang="en-US">Y</paragraph>
+ <paragraph id="par_id1002200811563352" role="tablecontent"
localize="false">Y</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563396" role="tablecontent"
localize="false" xml-lang="en-US">M</paragraph>
+ <paragraph id="par_id1002200811563396" role="tablecontent"
localize="false">M</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563385" role="tablecontent"
localize="false" xml-lang="en-US">D</paragraph>
+ <paragraph id="par_id1002200811563385" role="tablecontent"
localize="false">D</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563472" role="tablecontent"
localize="false" xml-lang="en-US">H</paragraph>
+ <paragraph id="par_id1002200811563472" role="tablecontent"
localize="false">H</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563430" role="tablecontent"
localize="false" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id1002200811563430" role="tablecontent"
localize="false">A</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563488" role="tablecontent"
localize="false" xml-lang="en-US">G</paragraph>
+ <paragraph id="par_id1002200811563488" role="tablecontent"
localize="false">G</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811563484" role="tablecontent"
xml-lang="en-US">German - de</paragraph>
+ <paragraph id="par_id1002200811563484" role="tablecontent">German -
de</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563518" role="tablecontent"
localize="false" xml-lang="en-US">J</paragraph>
+ <paragraph id="par_id1002200811563518" role="tablecontent"
localize="false">J</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563735" role="tablecontent"
localize="false" xml-lang="en-US">T</paragraph>
+ <paragraph id="par_id1002200811563735" role="tablecontent"
localize="false">T</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -542,17 +542,17 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811563823" role="tablecontent"
xml-lang="en-US">Netherlands - nl</paragraph>
+ <paragraph id="par_id1002200811563823" role="tablecontent">Netherlands -
nl</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563852" role="tablecontent"
localize="false" xml-lang="en-US">J</paragraph>
+ <paragraph id="par_id1002200811563852" role="tablecontent"
localize="false">J</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563827" role="tablecontent"
localize="false" xml-lang="en-US">U</paragraph>
+ <paragraph id="par_id1002200811563827" role="tablecontent"
localize="false">U</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -561,51 +561,51 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811563916" role="tablecontent"
xml-lang="en-US">French - fr</paragraph>
+ <paragraph id="par_id1002200811563916" role="tablecontent">French -
fr</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563970" role="tablecontent"
localize="false" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id1002200811563970" role="tablecontent"
localize="false">A</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811563980" role="tablecontent"
localize="false" xml-lang="en-US">J</paragraph>
+ <paragraph id="par_id1002200811563980" role="tablecontent"
localize="false">J</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564065" role="tablecontent"
localize="false" xml-lang="en-US">O</paragraph>
+ <paragraph id="par_id1002200811564065" role="tablecontent"
localize="false">O</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id100220081156407" role="tablecontent"
xml-lang="en-US">Italian - it</paragraph>
+ <paragraph id="par_id100220081156407" role="tablecontent">Italian -
it</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id100220081156403" role="tablecontent"
localize="false" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id100220081156403" role="tablecontent"
localize="false">A</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564042" role="tablecontent"
localize="false" xml-lang="en-US">G</paragraph>
+ <paragraph id="par_id1002200811564042" role="tablecontent"
localize="false">G</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id100220081156412" role="tablecontent"
localize="false" xml-lang="en-US">O</paragraph>
+ <paragraph id="par_id100220081156412" role="tablecontent"
localize="false">O</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564119" role="tablecontent"
localize="false" xml-lang="en-US">X</paragraph>
+ <paragraph id="par_id1002200811564119" role="tablecontent"
localize="false">X</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811564197" role="tablecontent"
xml-lang="en-US">Portuguese - pt</paragraph>
+ <paragraph id="par_id1002200811564197" role="tablecontent">Portuguese -
pt</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564272" role="tablecontent"
localize="false" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id1002200811564272" role="tablecontent"
localize="false">A</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -614,17 +614,17 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id100220081156423" role="tablecontent"
localize="false" xml-lang="en-US">O</paragraph>
+ <paragraph id="par_id100220081156423" role="tablecontent"
localize="false">O</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811564218" role="tablecontent"
xml-lang="en-US">Spanish - es</paragraph>
+ <paragraph id="par_id1002200811564218" role="tablecontent">Spanish -
es</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564390" role="tablecontent"
localize="false" xml-lang="en-US">A</paragraph>
+ <paragraph id="par_id1002200811564390" role="tablecontent"
localize="false">A</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -633,14 +633,14 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564319" role="tablecontent"
localize="false" xml-lang="en-US">O</paragraph>
+ <paragraph id="par_id1002200811564319" role="tablecontent"
localize="false">O</paragraph>
</tablecell>
<tablecell>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id100220081156433" role="tablecontent"
xml-lang="en-US">Danish - da</paragraph>
+ <paragraph id="par_id100220081156433" role="tablecontent">Danish -
da</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -649,7 +649,7 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id100220081156444" role="tablecontent"
localize="false" xml-lang="en-US">T</paragraph>
+ <paragraph id="par_id100220081156444" role="tablecontent"
localize="false">T</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -658,7 +658,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811564448" role="tablecontent"
xml-lang="en-US">Norwegian - no, nb, nn</paragraph>
+ <paragraph id="par_id1002200811564448" role="tablecontent">Norwegian -
no, nb, nn</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -667,7 +667,7 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564549" role="tablecontent"
localize="false" xml-lang="en-US">T</paragraph>
+ <paragraph id="par_id1002200811564549" role="tablecontent"
localize="false">T</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -676,7 +676,7 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811564565" role="tablecontent"
xml-lang="en-US">Swedish - sv</paragraph>
+ <paragraph id="par_id1002200811564565" role="tablecontent">Swedish -
sv</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -685,7 +685,7 @@
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564556" role="tablecontent"
localize="false" xml-lang="en-US">T</paragraph>
+ <paragraph id="par_id1002200811564556" role="tablecontent"
localize="false">T</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -694,19 +694,19 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id1002200811564637" role="tablecontent"
xml-lang="en-US">Finnish - fi</paragraph>
+ <paragraph id="par_id1002200811564637" role="tablecontent">Finnish -
fi</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564627" role="tablecontent"
localize="false" xml-lang="en-US">V</paragraph>
+ <paragraph id="par_id1002200811564627" role="tablecontent"
localize="false">V</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564643" role="tablecontent"
localize="false" xml-lang="en-US">K</paragraph>
+ <paragraph id="par_id1002200811564643" role="tablecontent"
localize="false">K</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564763" role="tablecontent"
localize="false" xml-lang="en-US">P</paragraph>
+ <paragraph id="par_id1002200811564763" role="tablecontent"
localize="false">P</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1002200811564715" role="tablecontent"
localize="false" xml-lang="en-US">T</paragraph>
+ <paragraph id="par_id1002200811564715" role="tablecontent"
localize="false">T</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -717,348 +717,348 @@
<h3 id="hd_id3149929">Entering Dates</h3>
-<paragraph id="par_id3148397" role="paragraph" xml-lang="en-US">To enter a
date in a cell, use the Gregorian calendar format. For example, in an English
locale, enter 1/2/2002 for Jan 2, 2002.</paragraph>
-<paragraph id="par_id3153274" role="paragraph" xml-lang="en-US">All date
formats are dependent on the locale that is set in <switchinline
select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME -
Preferences</emph></caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - Language settings -
Languages</emph>. For example, if your locale is set to 'Japanese', then the
Gengou calendar is used. The default date format in <item
type="productname">%PRODUCTNAME</item> uses the Gregorian Calendar.</paragraph>
-<paragraph id="par_id3153795" role="paragraph" xml-lang="en-US">To specify a
calendar format that is independent of the locale, add a modifier in front of
the date format. For example, to display a date using the Jewish calendar
format in a non-Hebrew locale, enter: [~jewish]DD/MM/YYYY.</paragraph>
-<paragraph id="par_id231020161240096930" role="paragraph" xml-lang="en-US">The
specified calendar is exported to Microsoft Excel using extended LCID. Extended
LCID can also be used in the format string. It will be converted to a calendar
modifier if it is supported. See <link
href="text/shared/01/05020301.xhp#ExtendedLCID">Extended LCID</link> section
below.</paragraph>
+<paragraph id="par_id3148397" role="paragraph">To enter a date in a cell, use
the Gregorian calendar format. For example, in an English locale, enter
1/2/2002 for Jan 2, 2002.</paragraph>
+<paragraph id="par_id3153274" role="paragraph">All date formats are dependent
on the locale that is set in <switchinline select="sys"><caseinline
select="MAC"><emph>%PRODUCTNAME -
Preferences</emph></caseinline><defaultinline><emph>Tools -
Options</emph></defaultinline></switchinline><emph> - Language settings -
Languages</emph>. For example, if your locale is set to 'Japanese', then the
Gengou calendar is used. The default date format in <item
type="productname">%PRODUCTNAME</item> uses the Gregorian Calendar.</paragraph>
+<paragraph id="par_id3153795" role="paragraph">To specify a calendar format
that is independent of the locale, add a modifier in front of the date format.
For example, to display a date using the Jewish calendar format in a non-Hebrew
locale, enter: [~jewish]DD/MM/YYYY.</paragraph>
+<paragraph id="par_id231020161240096930" role="paragraph">The specified
calendar is exported to Microsoft Excel using extended LCID. Extended LCID can
also be used in the format string. It will be converted to a calendar modifier
if it is supported. See <link
href="text/shared/01/05020301.xhp#ExtendedLCID">Extended LCID</link> section
below.</paragraph>
<table id="tbl_id3145133">
<tablerow>
<tablecell>
- <paragraph id="par_id3145764" role="tablehead"
xml-lang="en-US">Modifier</paragraph>
+ <paragraph id="par_id3145764" role="tablehead">Modifier</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3152967" role="tablehead"
xml-lang="en-US">Calendar</paragraph>
+ <paragraph id="par_id3152967" role="tablehead">Calendar</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3148390" role="code" localize="false"
xml-lang="en-US">[~buddhist]</paragraph>
+ <paragraph id="par_id3148390" role="code"
localize="false">[~buddhist]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3153781" role="tablecontent" xml-lang="en-US">Thai
Buddhist Calendar</paragraph>
+ <paragraph id="par_id3153781" role="tablecontent">Thai Buddhist
Calendar</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3157969" role="code" localize="false"
xml-lang="en-US">[~gengou]</paragraph>
+ <paragraph id="par_id3157969" role="code"
localize="false">[~gengou]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154656" role="tablecontent"
xml-lang="en-US">Japanese Gengou Calendar</paragraph>
+ <paragraph id="par_id3154656" role="tablecontent">Japanese Gengou
Calendar</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3150086" role="code" localize="false"
xml-lang="en-US">[~gregorian]</paragraph>
+ <paragraph id="par_id3150086" role="code"
localize="false">[~gregorian]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146070" role="tablecontent"
xml-lang="en-US">Gregorian Calendar</paragraph>
+ <paragraph id="par_id3146070" role="tablecontent">Gregorian
Calendar</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3146808" role="code" xml-lang="en-US">[~hanja] or
[~hanja_yoil]</paragraph>
+ <paragraph id="par_id3146808" role="code">[~hanja] or
[~hanja_yoil]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149207" role="tablecontent"
xml-lang="en-US">Korean Calendar</paragraph>
+ <paragraph id="par_id3149207" role="tablecontent">Korean
Calendar</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3150304" role="code" localize="false"
xml-lang="en-US">[~hijri]</paragraph>
+ <paragraph id="par_id3150304" role="code"
localize="false">[~hijri]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149238" role="tablecontent"
xml-lang="en-US">Arabic Islamic Calendar</paragraph>
+ <paragraph id="par_id3149238" role="tablecontent">Arabic Islamic
Calendar</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154903" role="code" localize="false"
xml-lang="en-US">[~jewish]</paragraph>
+ <paragraph id="par_id3154903" role="code"
localize="false">[~jewish]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3151288" role="tablecontent"
xml-lang="en-US">Jewish Calendar</paragraph>
+ <paragraph id="par_id3151288" role="tablecontent">Jewish
Calendar</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3166442" role="code" localize="false"
xml-lang="en-US">[~ROC]</paragraph>
+ <paragraph id="par_id3166442" role="code"
localize="false">[~ROC]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3145587" role="tablecontent"
xml-lang="en-US">Republic Of China Calendar</paragraph>
+ <paragraph id="par_id3145587" role="tablecontent">Republic Of China
Calendar</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph id="par_id3152419" role="paragraph" xml-lang="en-US"><switchinline
select="appl"><caseinline select="CALC">If you perform a calculation that
involves one or more cells using a date format, the result is formatted
according to the following mappings:</caseinline></switchinline></paragraph>
+<paragraph id="par_id3152419" role="paragraph"><switchinline
select="appl"><caseinline select="CALC">If you perform a calculation that
involves one or more cells using a date format, the result is formatted
according to the following mappings:</caseinline></switchinline></paragraph>
<switch select="appl">
<case select="CALC">
<table id="tbl_id3150490">
<tablerow>
<tablecell>
- <paragraph id="par_id3154194" role="tablehead" xml-lang="en-US">Initial
Format</paragraph>
+ <paragraph id="par_id3154194" role="tablehead">Initial Format</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149787" role="tablehead" xml-lang="en-US">Result
Format</paragraph>
+ <paragraph id="par_id3149787" role="tablehead">Result Format</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152993" role="tablecontent" xml-lang="en-US">Date
+ Date</paragraph>
+ <paragraph id="par_id3152993" role="tablecontent">Date + Date</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3150292" role="tablecontent"
xml-lang="en-US">Number (Days)</paragraph>
+ <paragraph id="par_id3150292" role="tablecontent">Number
(Days)</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3150460" role="tablecontent" xml-lang="en-US">Date
+ Number</paragraph>
+ <paragraph id="par_id3150460" role="tablecontent">Date +
Number</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154371" role="tablecontent"
xml-lang="en-US">Date</paragraph>
+ <paragraph id="par_id3154371" role="tablecontent">Date</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3145082" role="tablecontent" xml-lang="en-US">Date
+ Time</paragraph>
+ <paragraph id="par_id3145082" role="tablecontent">Date + Time</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156290" role="tablecontent"
xml-lang="en-US">Date&Time</paragraph>
+ <paragraph id="par_id3156290"
role="tablecontent">Date&Time</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152456" role="tablecontent" xml-lang="en-US">Date
+ Date&Time</paragraph>
+ <paragraph id="par_id3152456" role="tablecontent">Date +
Date&Time</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156169" role="tablecontent"
xml-lang="en-US">Number</paragraph>
+ <paragraph id="par_id3156169" role="tablecontent">Number</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154527" role="tablecontent" xml-lang="en-US">Time
+ Time</paragraph>
+ <paragraph id="par_id3154527" role="tablecontent">Time + Time</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159625" role="tablecontent"
xml-lang="en-US">Time</paragraph>
+ <paragraph id="par_id3159625" role="tablecontent">Time</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3146802" role="tablecontent" xml-lang="en-US">Time
+ Number</paragraph>
+ <paragraph id="par_id3146802" role="tablecontent">Time +
Number</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3146770" role="tablecontent"
xml-lang="en-US">Time</paragraph>
+ <paragraph id="par_id3146770" role="tablecontent">Time</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3155500" role="tablecontent" xml-lang="en-US">Time
+ Date&Time</paragraph>
+ <paragraph id="par_id3155500" role="tablecontent">Time +
Date&Time</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155128" role="tablecontent"
xml-lang="en-US">Date&Time</paragraph>
+ <paragraph id="par_id3155128"
role="tablecontent">Date&Time</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3152904" role="tablecontent"
xml-lang="en-US">Date&Time + Date&Time</paragraph>
+ <paragraph id="par_id3152904" role="tablecontent">Date&Time +
Date&Time</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3159143" role="tablecontent"
xml-lang="en-US">Time</paragraph>
+ <paragraph id="par_id3159143" role="tablecontent">Time</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3148909" role="tablecontent"
xml-lang="en-US">Date&Time + Number</paragraph>
+ <paragraph id="par_id3148909" role="tablecontent">Date&Time +
Number</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154806" role="tablecontent"
xml-lang="en-US">Date&Time</paragraph>
+ <paragraph id="par_id3154806"
role="tablecontent">Date&Time</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3151269" role="tablecontent"
xml-lang="en-US">Number + Number</paragraph>
+ <paragraph id="par_id3151269" role="tablecontent">Number +
Number</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154951" role="tablecontent"
xml-lang="en-US">Number</paragraph>
+ <paragraph id="par_id3154951" role="tablecontent">Number</paragraph>
</tablecell>
</tablerow>
</table>
</case>
</switch>
-<paragraph id="par_id3149174" role="paragraph" xml-lang="en-US"><switchinline
select="appl"><caseinline select="CALC">The <emph>Date & Time</emph> format
displays the date and time that an entry was made to a cell with this
format.</caseinline></switchinline></paragraph>
+<paragraph id="par_id3149174" role="paragraph"><switchinline
select="appl"><caseinline select="CALC">The <emph>Date & Time</emph> format
displays the date and time that an entry was made to a cell with this
format.</caseinline></switchinline></paragraph>
<switch select="appl">
<case select="CALC">
<embed href="text/shared/optionen/01010600.xhp#year_digits"/>
-<paragraph id="par_id3143225" role="note" xml-lang="en-US">By default in <item
type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds
to Dec 30, 1899.</paragraph>
+<note id="par_id3143225">By default in <item
type="productname">%PRODUCTNAME</item>, a date with the value "0" corresponds
to Dec 30, 1899.</note>
</case>
</switch>
<h3 id="hd_id3155870">Time Formats</h3>
-<paragraph id="par_id3150108" role="paragraph" xml-lang="en-US">To display
hours, minutes and seconds use the following number format codes:</paragraph>
+<paragraph id="par_id3150108" role="paragraph">To display hours, minutes and
seconds use the following number format codes:</paragraph>
<table id="tbl_id3154830">
<tablerow>
<tablecell>
- <paragraph id="par_id3149158" role="tablehead"
xml-lang="en-US">Format</paragraph>
+ <paragraph id="par_id3149158" role="tablehead">Format</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3154341" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ <paragraph id="par_id3154341" role="tablehead">Format Code</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154557" role="tablecontent" xml-lang="en-US">Hours
as 0-23</paragraph>
+ <paragraph id="par_id3154557" role="tablecontent">Hours as
0-23</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156348" role="code" localize="false"
xml-lang="en-US">H</paragraph>
+ <paragraph id="par_id3156348" role="code" localize="false">H</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143218" role="tablecontent" xml-lang="en-US">Hours
as 00-23</paragraph>
+ <paragraph id="par_id3143218" role="tablecontent">Hours as
00-23</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155266" role="code" localize="false"
xml-lang="en-US">HH</paragraph>
+ <paragraph id="par_id3155266" role="code" localize="false">HH</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3143219" role="tablecontent" xml-lang="en-US">Hours
as 00 up to more than 23</paragraph>
+ <paragraph id="par_id3143219" role="tablecontent">Hours as 00 up to more
than 23</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3155267" role="code" localize="false"
xml-lang="en-US">[HH]</paragraph>
+ <paragraph id="par_id3155267" role="code"
localize="false">[HH]</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3150139" role="tablecontent"
xml-lang="en-US">Minutes as 0-59</paragraph>
+ <paragraph id="par_id3150139" role="tablecontent">Minutes as
0-59</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3149588" role="code" localize="false"
xml-lang="en-US">M</paragraph>
+ <paragraph id="par_id3149588" role="code" localize="false">M</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3150531" role="tablecontent"
xml-lang="en-US">Minutes as 00-59</paragraph>
+ <paragraph id="par_id3150531" role="tablecontent">Minutes as
00-59</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147409" role="code" localize="false"
xml-lang="en-US">MM</paragraph>
+ <paragraph id="par_id3147409" role="code" localize="false">MM</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3150532" role="tablecontent"
xml-lang="en-US">Minutes as 00 up to more than 59</paragraph>
+ <paragraph id="par_id3150532" role="tablecontent">Minutes as 00 up to
more than 59</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3147410" role="code" localize="false"
xml-lang="en-US">[MM]</paragraph>
+ <paragraph id="par_id3147410" role="code"
localize="false">[MM]</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3154854" role="tablecontent"
xml-lang="en-US">Seconds as 0-59</paragraph>
+ <paragraph id="par_id3154854" role="tablecontent">Seconds as
0-59</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3156173" role="code" localize="false"
xml-lang="en-US">S</paragraph>
+ <paragraph id="par_id3156173" role="code" localize="false">S</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3149506" role="tablecontent"
xml-lang="en-US">Seconds as 00-59</paragraph>
+ <paragraph id="par_id3149506" role="tablecontent">Seconds as
00-59</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3157981" role="code" localize="false"
xml-lang="en-US">SS</paragraph>
+ <paragraph id="par_id3157981" role="code" localize="false">SS</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id3149507" role="tablecontent"
xml-lang="en-US">Seconds as 00 up to more than 59</paragraph>
+ <paragraph id="par_id3149507" role="tablecontent">Seconds as 00 up to
more than 59</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id3157982" role="code" localize="false"
xml-lang="en-US">[SS]</paragraph>
+ <paragraph id="par_id3157982" role="code"
localize="false">[SS]</paragraph>
</tablecell>
</tablerow>
</table>
-<paragraph id="par_id3156039" role="note" xml-lang="en-US">To display seconds
as fractions, add the decimal delimiter to your number format code. For
example, enter <emph>HH:MM:SS.00</emph> to display the time as
"01:02:03.45".<comment>Translators: use the decimal delimiter of your language
(period or comma) for all number format codes in Calc.</comment></paragraph>
-<paragraph id="par_id3148650" role="paragraph" xml-lang="en-US">Minute time
formats M and MM must be used in combination with hour or second time formats
to avoid confusion with month date format.</paragraph>
-<paragraph id="par_id3148649" role="paragraph" xml-lang="en-US">If a time is
entered in the form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats
are assigned if no other time format has been specified: MM:SS.00 or
[HH]:MM:SS.00 or [HH]:MM:SS<comment>Translators: use the decimal delimiter of
your language (period or comma) for all number format codes in
Calc.</comment></paragraph>
+<note id="par_id3156039">To display seconds as fractions, add the decimal
delimiter to your number format code. For example, enter
<emph>HH:MM:SS.00</emph> to display the time as
"01:02:03.45".<comment>Translators: use the decimal delimiter of your language
(period or comma) for all number format codes in Calc.</comment></note>
+<paragraph id="par_id3148650" role="paragraph">Minute time formats M and MM
must be used in combination with hour or second time formats to avoid confusion
with month date format.</paragraph>
+<paragraph id="par_id3148649" role="paragraph">If a time is entered in the
form 02:03.45 or 01:02:03.45 or 25:01:02, the following formats are assigned if
no other time format has been specified: MM:SS.00 or [HH]:MM:SS.00 or
[HH]:MM:SS<comment>Translators: use the decimal delimiter of your language
(period or comma) for all number format codes in Calc.</comment></paragraph>
<h2 id="hd_id3158404">Displaying Numbers Using Native Characters</h2>
<h2 id="hd_id231020161309289931">NatNum modifiers</h2>
-<paragraph id="par_id3149998" role="paragraph" xml-lang="en-US">To display
numbers using native number characters, use a [NatNum1], [NatNum2], ...,
[NatNum11] modifier at the beginning of a number format
codes.</paragraph><comment>this will be extended with the libnumbertext
work</comment>
-<paragraph id="par_id3158313" role="paragraph" xml-lang="en-US">To spell out
numbers in various number, currency and date formats, use a [NatNum12] modifier
with the chosen arguments at the beginning of a number format code. See <link
href="text/shared/01/05020301.xhp#NatNum12">NatNum12</link> section
below.</paragraph>
-<paragraph id="par_id3154600" role="paragraph" xml-lang="en-US">The [NatNum1]
modifier always uses a one to one character mapping to convert numbers to a
string that matches the native number format code of the corresponding locale.
The other modifiers produce different results if they are used with different
locales. A locale can be the language and the territory for which the format
code is defined, or a modifier such as [$-yyy] that follows the native number
modifier. In this case, yyy is the hexadecimal MS-LCID that is also used in
currency format codes. For example, to display a number using Japanese short
Kanji characters in an English US locale, use the following number format
code:</paragraph>
-<paragraph id="par_id3152546" role="example" localize="false"
xml-lang="en-US">[NatNum1][$-411]0</paragraph>
-<paragraph id="par_id3147269" role="paragraph" xml-lang="en-US">In the
following list, the Microsoft Excel [DBNumX] modifier that corresponds to <item
type="productname">%PRODUCTNAME</item> [NatNum] modifier is shown. If you want,
you can use a [DBNumX] modifier instead of [NatNum] modifier for your locale.
Whenever possible, <item type="productname">%PRODUCTNAME</item> internally maps
[DBNumX] modifiers to [NatNumN] modifiers.</paragraph>
-<paragraph id="par_idN11234" role="paragraph" xml-lang="en-US">Displaying
dates using [NatNum] modifiers can have a different effect than displaying
other types of numbers. Such effects are indicated by 'CAL: '. For example,
'CAL: 1/4/4' indicates that the year is displayed using the [NatNum1] modifier,
while the day and month are displayed using the [NatNum4] modifier. If 'CAL' is
not specified, the date formats for that particular modifier are not
supported.</paragraph>
-<paragraph id="hd_id150820161449146058" role="paragraph" localize="false"
xml-lang="en-US">[<emph>NatNum0</emph>]</paragraph>
-<paragraph id="par_id1508201614491484" role="paragraph" xml-lang="en-US">Try
to convert any native number string to ASCII Arabic digits. If already ASCII,
it remains ASCII.</paragraph>
-<paragraph id="par_id13082016175325372" role="paragraph" localize="false"
xml-lang="en-US">[<emph>NatNum1</emph>]</paragraph>
+<paragraph id="par_id3149998" role="paragraph">To display numbers using native
number characters, use a [NatNum1], [NatNum2], ..., [NatNum11] modifier at the
beginning of a number format codes.</paragraph><comment>this will be extended
with the libnumbertext work</comment>
+<paragraph id="par_id3158313" role="paragraph">To spell out numbers in various
number, currency and date formats, use a [NatNum12] modifier with the chosen
arguments at the beginning of a number format code. See <link
href="text/shared/01/05020301.xhp#NatNum12">NatNum12</link> section
below.</paragraph>
+<paragraph id="par_id3154600" role="paragraph">The [NatNum1] modifier always
uses a one to one character mapping to convert numbers to a string that matches
the native number format code of the corresponding locale. The other modifiers
produce different results if they are used with different locales. A locale can
be the language and the territory for which the format code is defined, or a
modifier such as [$-yyy] that follows the native number modifier. In this case,
yyy is the hexadecimal MS-LCID that is also used in currency format codes. For
example, to display a number using Japanese short Kanji characters in an
English US locale, use the following number format code:</paragraph>
+<paragraph id="par_id3152546" role="example"
localize="false">[NatNum1][$-411]0</paragraph>
+<paragraph id="par_id3147269" role="paragraph">In the following list, the
Microsoft Excel [DBNumX] modifier that corresponds to <item
type="productname">%PRODUCTNAME</item> [NatNum] modifier is shown. If you want,
you can use a [DBNumX] modifier instead of [NatNum] modifier for your locale.
Whenever possible, <item type="productname">%PRODUCTNAME</item> internally maps
[DBNumX] modifiers to [NatNumN] modifiers.</paragraph>
+<paragraph id="par_idN11234" role="paragraph">Displaying dates using [NatNum]
modifiers can have a different effect than displaying other types of numbers.
Such effects are indicated by 'CAL: '. For example, 'CAL: 1/4/4' indicates that
the year is displayed using the [NatNum1] modifier, while the day and month are
displayed using the [NatNum4] modifier. If 'CAL' is not specified, the date
formats for that particular modifier are not supported.</paragraph>
+<paragraph id="hd_id150820161449146058" role="paragraph"
localize="false">[<emph>NatNum0</emph>]</paragraph>
+<paragraph id="par_id1508201614491484" role="paragraph">Try to convert any
native number string to ASCII Arabic digits. If already ASCII, it remains
ASCII.</paragraph>
+<paragraph id="par_id13082016175325372" role="paragraph"
localize="false">[<emph>NatNum1</emph>]</paragraph>
<table id="Table1">
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753258543" role="tablehead"
xml-lang="en-US">Transliterations</paragraph>
+ <paragraph id="par_id130820161753258543"
role="tablehead">Transliterations</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id13082016175325613" role="tablehead"
xml-lang="en-US">Native Number Characters</paragraph>
+ <paragraph id="par_id13082016175325613" role="tablehead">Native Number
Characters</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753255045" role="tablehead"
localize="false" xml-lang="en-US">DBNumX</paragraph>
+ <paragraph id="par_id130820161753255045" role="tablehead"
localize="false">DBNumX</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753252157" role="tablehead"
xml-lang="en-US">Date Format</paragraph>
+ <paragraph id="par_id130820161753252157" role="tablehead">Date
Format</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753258910" role="tablecontent"
xml-lang="en-US">Chinese</paragraph>
+ <paragraph id="par_id130820161753258910"
role="tablecontent">Chinese</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753252802" role="tablecontent"
xml-lang="en-US">Chinese lower case characters</paragraph>
+ <paragraph id="par_id130820161753252802" role="tablecontent">Chinese
lower case characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753293296" role="tablecontent"
localize="false" xml-lang="en-US">CAL: 1/7/7 [DBNum1]</paragraph>
+ <paragraph id="par_id130820161753293296" role="tablecontent"
localize="false">CAL: 1/7/7 [DBNum1]</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753293042" role="tablecontent"
xml-lang="en-US">Japanese</paragraph>
+ <paragraph id="par_id130820161753293042"
role="tablecontent">Japanese</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753297854" role="tablecontent"
xml-lang="en-US">short Kanji characters</paragraph>
+ <paragraph id="par_id130820161753297854" role="tablecontent">short Kanji
characters</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753295852" role="tablecontent"
localize="false" xml-lang="en-US">[DBNum1]</paragraph>
+ <paragraph id="par_id130820161753295852" role="tablecontent"
localize="false">[DBNum1]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753293652" role="tablecontent"
localize="false" xml-lang="en-US">CAL: 1/4/4 [DBNum1]</paragraph>
+ <paragraph id="par_id130820161753293652" role="tablecontent"
localize="false">CAL: 1/4/4 [DBNum1]</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id13082016175330954" role="tablecontent"
xml-lang="en-US">Korean</paragraph>
+ <paragraph id="par_id13082016175330954"
role="tablecontent">Korean</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753303188" role="tablecontent"
xml-lang="en-US">Korean lower case characters</paragraph>
+ <paragraph id="par_id130820161753303188" role="tablecontent">Korean
lower case characters</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753305557" role="tablecontent"
localize="false" xml-lang="en-US">[DBNum1]</paragraph>
+ <paragraph id="par_id130820161753305557" role="tablecontent"
localize="false">[DBNum1]</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753303003" role="tablecontent"
localize="false" xml-lang="en-US">CAL: 1/7/7 [DBNum1]</paragraph>
+ <paragraph id="par_id130820161753303003" role="tablecontent"
localize="false">CAL: 1/7/7 [DBNum1]</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753317270" role="tablecontent"
xml-lang="en-US">Hebrew</paragraph>
+ <paragraph id="par_id130820161753317270"
role="tablecontent">Hebrew</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753311497" role="tablecontent"
xml-lang="en-US">Hebrew characters</paragraph>
+ <paragraph id="par_id130820161753311497" role="tablecontent">Hebrew
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1067,10 +1067,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753301830" role="tablecontent"
xml-lang="en-US">Arabic</paragraph>
+ <paragraph id="par_id130820161753301830"
role="tablecontent">Arabic</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753306722" role="tablecontent"
xml-lang="en-US">Arabic-Indic characters</paragraph>
+ <paragraph id="par_id130820161753306722"
role="tablecontent">Arabic-Indic characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1079,10 +1079,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753301290" role="tablecontent"
xml-lang="en-US">Thai</paragraph>
+ <paragraph id="par_id130820161753301290"
role="tablecontent">Thai</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753301107" role="tablecontent"
xml-lang="en-US">Thai characters</paragraph>
+ <paragraph id="par_id130820161753301107" role="tablecontent">Thai
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1091,10 +1091,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753301831" role="tablecontent"
xml-lang="en-US">Hindi</paragraph>
+ <paragraph id="par_id130820161753301831"
role="tablecontent">Hindi</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753306723" role="tablecontent"
xml-lang="en-US">Indic-Devanagari characters</paragraph>
+ <paragraph id="par_id130820161753306723"
role="tablecontent">Indic-Devanagari characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1103,10 +1103,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753309518" role="tablecontent"
xml-lang="en-US">Odia</paragraph>
+ <paragraph id="par_id130820161753309518"
role="tablecontent">Odia</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753301434" role="tablecontent"
xml-lang="en-US">Odia (Oriya) characters</paragraph>
+ <paragraph id="par_id130820161753301434" role="tablecontent">Odia
(Oriya) characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1115,10 +1115,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926246858" role="tablecontent"
xml-lang="en-US">Marathi</paragraph>
+ <paragraph id="par_id180820161926246858"
role="tablecontent">Marathi</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926248586" role="tablecontent"
xml-lang="en-US">Indic-Devanagari characters</paragraph>
+ <paragraph id="par_id180820161926248586"
role="tablecontent">Indic-Devanagari characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1127,10 +1127,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926241975" role="tablecontent"
xml-lang="en-US">Bengali</paragraph>
+ <paragraph id="par_id180820161926241975"
role="tablecontent">Bengali</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926246091" role="tablecontent"
xml-lang="en-US">Bengali characters</paragraph>
+ <paragraph id="par_id180820161926246091" role="tablecontent">Bengali
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1139,10 +1139,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926256261" role="tablecontent"
xml-lang="en-US">Punjabi</paragraph>
+ <paragraph id="par_id180820161926256261"
role="tablecontent">Punjabi</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926257295" role="tablecontent"
xml-lang="en-US">Punjabi (Gurmukhi) characters</paragraph>
+ <paragraph id="par_id180820161926257295" role="tablecontent">Punjabi
(Gurmukhi) characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1151,10 +1151,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926254282" role="tablecontent"
xml-lang="en-US">Gujarati</paragraph>
+ <paragraph id="par_id180820161926254282"
role="tablecontent">Gujarati</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926258664" role="tablecontent"
xml-lang="en-US">Gujarati characters</paragraph>
+ <paragraph id="par_id180820161926258664" role="tablecontent">Gujarati
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1163,10 +1163,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id18082016192625454" role="tablecontent"
xml-lang="en-US">Tamil</paragraph>
+ <paragraph id="par_id18082016192625454"
role="tablecontent">Tamil</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926253837" role="tablecontent"
xml-lang="en-US">Tamil characters</paragraph>
+ <paragraph id="par_id180820161926253837" role="tablecontent">Tamil
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1175,10 +1175,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id18082016192625217" role="tablecontent"
xml-lang="en-US">Telugu</paragraph>
+ <paragraph id="par_id18082016192625217"
role="tablecontent">Telugu</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id18082016192625475" role="tablecontent"
xml-lang="en-US">Telugu characters</paragraph>
+ <paragraph id="par_id18082016192625475" role="tablecontent">Telugu
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1187,10 +1187,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926251185" role="tablecontent"
xml-lang="en-US">Kannada</paragraph>
+ <paragraph id="par_id180820161926251185"
role="tablecontent">Kannada</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id18082016192625183" role="tablecontent"
xml-lang="en-US">Kannada characters</paragraph>
+ <paragraph id="par_id18082016192625183" role="tablecontent">Kannada
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1199,10 +1199,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926265921" role="tablecontent"
xml-lang="en-US">Malayalam</paragraph>
+ <paragraph id="par_id180820161926265921"
role="tablecontent">Malayalam</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id18082016192626103" role="tablecontent"
xml-lang="en-US">Malayalam characters</paragraph>
+ <paragraph id="par_id18082016192626103" role="tablecontent">Malayalam
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1211,10 +1211,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926264168" role="tablecontent"
xml-lang="en-US">Lao</paragraph>
+ <paragraph id="par_id180820161926264168"
role="tablecontent">Lao</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926262520" role="tablecontent"
xml-lang="en-US">Lao characters</paragraph>
+ <paragraph id="par_id180820161926262520" role="tablecontent">Lao
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1223,10 +1223,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926264242" role="tablecontent"
xml-lang="en-US">Tibetan</paragraph>
+ <paragraph id="par_id180820161926264242"
role="tablecontent">Tibetan</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926264284" role="tablecontent"
xml-lang="en-US">Tibetan characters</paragraph>
+ <paragraph id="par_id180820161926264284" role="tablecontent">Tibetan
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1235,10 +1235,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926265624" role="tablecontent"
xml-lang="en-US">Burmese</paragraph>
+ <paragraph id="par_id180820161926265624"
role="tablecontent">Burmese</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926265398" role="tablecontent"
xml-lang="en-US">Burmese (Myanmar) characters</paragraph>
+ <paragraph id="par_id180820161926265398" role="tablecontent">Burmese
(Myanmar) characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1247,10 +1247,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926273825" role="tablecontent"
xml-lang="en-US">Khmer</paragraph>
+ <paragraph id="par_id180820161926273825"
role="tablecontent">Khmer</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926273240" role="tablecontent"
xml-lang="en-US">Khmer (Cambodian) characters</paragraph>
+ <paragraph id="par_id180820161926273240" role="tablecontent">Khmer
(Cambodian) characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1259,10 +1259,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id18082016192627382" role="tablecontent"
xml-lang="en-US">Mongolian</paragraph>
+ <paragraph id="par_id18082016192627382"
role="tablecontent">Mongolian</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926276923" role="tablecontent"
xml-lang="en-US">Mongolian characters</paragraph>
+ <paragraph id="par_id180820161926276923" role="tablecontent">Mongolian
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1271,10 +1271,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926273435" role="tablecontent"
xml-lang="en-US">Nepali</paragraph>
+ <paragraph id="par_id180820161926273435"
role="tablecontent">Nepali</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926274450" role="tablecontent"
xml-lang="en-US">Indic-Devanagari characters</paragraph>
+ <paragraph id="par_id180820161926274450"
role="tablecontent">Indic-Devanagari characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1283,10 +1283,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926279875" role="tablecontent"
xml-lang="en-US">Dzongkha</paragraph>
+ <paragraph id="par_id180820161926279875"
role="tablecontent">Dzongkha</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926276833" role="tablecontent"
xml-lang="en-US">Tibetan characters</paragraph>
+ <paragraph id="par_id180820161926276833" role="tablecontent">Tibetan
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1295,10 +1295,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926272903" role="tablecontent"
xml-lang="en-US">Farsi</paragraph>
+ <paragraph id="par_id180820161926272903"
role="tablecontent">Farsi</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926271122" role="tablecontent"
xml-lang="en-US">East Arabic-Indic characters</paragraph>
+ <paragraph id="par_id180820161926271122" role="tablecontent">East
Arabic-Indic characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1307,10 +1307,10 @@
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id180820161926287716" role="tablecontent"
xml-lang="en-US">Church Slavic</paragraph>
+ <paragraph id="par_id180820161926287716" role="tablecontent">Church
Slavic</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id180820161926281396" role="tablecontent"
xml-lang="en-US">Cyrillic characters</paragraph>
+ <paragraph id="par_id180820161926281396" role="tablecontent">Cyrillic
characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
@@ -1319,69 +1319,69 @@
</tablerow>
</table>
-<paragraph id="par_id130820161753318343" role="paragraph" localize="false"
xml-lang="en-US">[<emph>NatNum2</emph>]</paragraph>
+<paragraph id="par_id130820161753318343" role="paragraph"
localize="false">[<emph>NatNum2</emph>]</paragraph>
<table id="Tabela1">
<tablerow>
<tablecell>
- <paragraph id="par_id130820162101136589" role="tablehead"
xml-lang="en-US">Transliterations</paragraph>
+ <paragraph id="par_id130820162101136589"
role="tablehead">Transliterations</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820162101139206" role="tablehead"
xml-lang="en-US">Native Number Characters</paragraph>
+ <paragraph id="par_id130820162101139206" role="tablehead">Native Number
Characters</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id13082016210113663" role="tablehead"
localize="false" xml-lang="en-US">DBNumX</paragraph>
+ <paragraph id="par_id13082016210113663" role="tablehead"
localize="false">DBNumX</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id1308201621011376" role="tablehead"
xml-lang="en-US">Date Format</paragraph>
+ <paragraph id="par_id1308201621011376" role="tablehead">Date
Format</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753314558" role="tablecontent"
xml-lang="en-US">Chinese</paragraph>
+ <paragraph id="par_id130820161753314558"
role="tablecontent">Chinese</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753311211" role="tablecontent"
xml-lang="en-US">Chinese upper case characters</paragraph>
+ <paragraph id="par_id130820161753311211" role="tablecontent">Chinese
upper case characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753316545" role="tablecontent"
localize="false" xml-lang="en-US">CAL 2/8/8 [DBNum2]</paragraph>
+ <paragraph id="par_id130820161753316545" role="tablecontent"
localize="false">CAL 2/8/8 [DBNum2]</paragraph>
</tablecell>
</tablerow>
<tablerow>
<tablecell>
- <paragraph id="par_id130820161753311010" role="tablecontent"
xml-lang="en-US">Japanese</paragraph>
+ <paragraph id="par_id130820161753311010"
role="tablecontent">Japanese</paragraph>
</tablecell>
<tablecell>
- <paragraph id="par_id130820161753311215" role="tablecontent"
xml-lang="en-US">traditional Kanji characters</paragraph>
+ <paragraph id="par_id130820161753311215" role="tablecontent">traditional
Kanji characters</paragraph>
</tablecell>
<tablecell>
</tablecell>
... etc. - the rest is truncated
