source/text/shared/01/05020301.xhp | 2644 +++++++++++++++++++++----------------
1 file changed, 1547 insertions(+), 1097 deletions(-)
New commits:
commit 053c67aeb4049a175eda8dc4a1910516f58ce7b4
Author: Laurent Balland-Poirier <laurent.balland-poir...@laposte.net>
Date: Sat Aug 13 22:17:20 2016 -0300
Improvement in help page for number format codes
added/fixed comments by LBP in code review 1
Change-Id: Ic06e89a027d70d35c6985215b7fcc420d7b4e7ed
Reviewed-on: https://gerrit.libreoffice.org/28110
Reviewed-by: Laurent BP <laurent.balland-poir...@laposte.net>
Reviewed-by: Olivier Hallot <ohal...@collabora.co.uk>
Tested-by: Olivier Hallot <ohal...@collabora.co.uk>
diff --git a/source/text/shared/01/05020301.xhp
b/source/text/shared/01/05020301.xhp
index 45bfdb8..7bc6872 100644
--- a/source/text/shared/01/05020301.xhp
+++ b/source/text/shared/01/05020301.xhp
@@ -1,6 +1,5 @@
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
-
<!--
* This file is part of the LibreOffice project.
*
@@ -17,1145 +16,1596 @@
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
- -->
-
-
+-->
+
<meta>
-<topic id="textshared0105020301xml" indexer="include">
-<title id="tit" xml-lang="en-US">Number Format Codes</title>
-<filename>/text/shared/01/05020301.xhp</filename>
-</topic>
+ <topic id="textshared0105020301xml" indexer="include">
+ <title id="tit" xml-lang="en-US">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_value>format codes; numbers</bookmark_value>
-<bookmark_value>conditions; in number formats</bookmark_value>
-<bookmark_value>number formats; codes</bookmark_value>
-<bookmark_value>currency formats</bookmark_value>
-<bookmark_value>formats;of currencies/date/time</bookmark_value>
-<bookmark_value>numbers; date, time and currency formats</bookmark_value>
-<bookmark_value>Euro; currency formats</bookmark_value>
-<bookmark_value>date formats</bookmark_value>
-<bookmark_value>times, formats</bookmark_value>
-<bookmark_value>percentages, formats</bookmark_value>
-<bookmark_value>scientific notation, formats</bookmark_value>
-<bookmark_value>engineering notation, formats</bookmark_value>
-<bookmark_value>fraction, formats</bookmark_value>
-</bookmark><comment>mw made "time formats" a two level entry and deleted 2x
"formats;"</comment>
-<paragraph role="heading" id="hd_id3153514" xml-lang="en-US" level="1"
l10n="U" oldref="1"><variable id="zahlenformatcodes"><link
href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format
Codes</link>
-</variable></paragraph>
-<paragraph role="paragraph" id="par_id3150467" xml-lang="en-US" l10n="U"
oldref="88">Number format codes can consist of up to four sections separated by
a semicolon (;).</paragraph>
+
+<bookmark xml-lang="en-US" 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>
+ <bookmark_value>currency formats</bookmark_value>
+ <bookmark_value>formats;of currencies/date/time</bookmark_value>
+ <bookmark_value>numbers; date, time and currency formats</bookmark_value>
+ <bookmark_value>Euro; currency formats</bookmark_value>
+ <bookmark_value>date formats</bookmark_value>
+ <bookmark_value>times, formats</bookmark_value>
+ <bookmark_value>percentages, formats</bookmark_value>
+ <bookmark_value>scientific notation, formats</bookmark_value>
+ <bookmark_value>engineering notation, formats</bookmark_value>
+ <bookmark_value>fraction, formats</bookmark_value>
+</bookmark>
+<comment>mw made "time formats" a two level entry and deleted 2x
"formats;"</comment>
+
+<paragraph id="hd_id3153514" role="heading" level="1"
xml-lang="en-US"><variable id="zahlenformatcodes"><link
href="text/shared/01/05020301.xhp" name="Number Format Codes">Number Format
Codes</link> </variable></paragraph>
+<paragraph id="par_id3150467" role="paragraph" xml-lang="en-US">Number format
codes can consist of up to four sections separated by a semicolon
(;).</paragraph>
+
<list type="ordered">
-<listitem>
-<paragraph role="listitem" id="par_id3150146" xml-lang="en-US" l10n="U"
oldref="108">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 role="listitem" id="par_id3158442" xml-lang="en-US" l10n="CHG"
oldref="109">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 role="listitem" id="par_id3155069" xml-lang="en-US" l10n="U"
oldref="110">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 role="listitem" id="par_id3155070" xml-lang="en-US" l10n="U"
oldref="249">Fourth section applies if the content is not a value, but some
text. Content is represented by an at sign (@).</paragraph>
-</listitem>
+ <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>
+ </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>
+ </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>
+ </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 (@).</paragraph>
+ </listitem>
</list>
-<paragraph role="heading" id="hd_id3151262" xml-lang="en-US" level="2"
l10n="U" oldref="229">Decimal Places and Significant Digits</paragraph>
-<paragraph role="paragraph" id="par_id3153624" xml-lang="en-US" l10n="U"
oldref="3">Use zero (0), the number sign (#) or the question mark (?) as
placeholders in your number format code to represent numbers. The (#) only
displays significant digits, while the (0) displays zeroes if there are fewer
digits in the number than in the number format. The (?) works as the (#) but
adds a space character to keep decimal alignment if there is a hidden
non-significant zero.</paragraph>
-<paragraph role="paragraph" id="par_id3153323" xml-lang="en-US" l10n="U"
oldref="107">Use question marks (?) 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 role="paragraph" id="par_id3148440" xml-lang="en-US" l10n="U"
oldref="4">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="hd_id3151262" role="heading" level="2" xml-lang="en-US">Decimal
Places and Significant Digits</paragraph>
+<paragraph id="par_id3153624" role="paragraph" xml-lang="en-US">Use zero (0),
the number sign (#) or the question mark (?) as placeholders in your number
format code to represent numbers. The (#) only displays significant digits,
while the (0) displays zeroes if there are fewer digits in the number than in
the number format. The (?) works as the (#) 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 (?) 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>
+
<table id="tbl_id3149760">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id3150902" xml-lang="en-US" l10n="U"
oldref="86">Placeholders</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id3157896" xml-lang="en-US" l10n="U"
oldref="87">Explanation</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3152801" xml-lang="en-US" l10n="U"
oldref="5">#</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3145090" xml-lang="en-US" l10n="U"
oldref="6">Does not display extra zeros.</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3152802" xml-lang="en-US" l10n="U"
oldref="239">?</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3145091" xml-lang="en-US" l10n="U"
oldref="240">Displays space characters instead of extra zeros.</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3147088" xml-lang="en-US" l10n="U"
oldref="7">0 (Zero)</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3150774" xml-lang="en-US" l10n="U"
oldref="8">Displays extra zeros if the number has less places than zeros in the
format.</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3150902" role="tablehead"
xml-lang="en-US">Placeholders</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3157896" role="tablehead"
xml-lang="en-US">Explanation</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3152801" role="code" xml-lang="en-US">#</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3145090" role="tablecontent" xml-lang="en-US">Does
not display extra zeros.</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3152802" role="code" xml-lang="en-US">?</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3145091" role="tablecontent"
xml-lang="en-US">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>
+ </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>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="heading" id="par_idN1087E" xml-lang="en-US" level="3"
l10n="NEW">Examples</paragraph>
+
+<paragraph id="par_idN1087E" role="heading" level="3"
xml-lang="en-US">Examples</paragraph>
+
<table id="tbl_id3153577">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id3149182" xml-lang="en-US" l10n="U"
oldref="9">Number Format</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id3154749" xml-lang="en-US" l10n="U"
oldref="10">Format Code</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3148538" xml-lang="en-US" l10n="U"
oldref="11">3456.78 as 3456.8</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3150355" xml-lang="en-US" l10n="U"
oldref="12">####.#</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154142" xml-lang="en-US" l10n="U"
oldref="13">9.9 as 9.900</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3159256" xml-lang="en-US" l10n="U"
oldref="14">#.000</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3147077" xml-lang="en-US" l10n="U"
oldref="15">13 as 13.0 and 1234.567 as 1234.57</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3155388" xml-lang="en-US" l10n="U"
oldref="16">#.0#</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3149578" xml-lang="en-US" l10n="U"
oldref="17">5.75 as 5 3/4 and 6.3 as 6 3/10</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3145315" xml-lang="en-US" l10n="U"
oldref="18"># ???/???</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3156152" xml-lang="en-US" l10n="U"
oldref="19">.5 as 0.5</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3149762" xml-lang="en-US" l10n="U"
oldref="20">0.##</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3156153" xml-lang="en-US" l10n="U"
oldref="241">.5 as 0.5   (with two extra spaces at the
end)</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3149763" xml-lang="en-US" l10n="U"
oldref="242">0.???</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3149182" role="tablehead" xml-lang="en-US">Number
Format</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3154749" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3148538" role="tablecontent"
xml-lang="en-US">3456.78 as 3456.8</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3150355" role="code"
xml-lang="en-US">####.#</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154142" role="tablecontent" xml-lang="en-US">9.9
as 9.900</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3159256" role="code"
xml-lang="en-US">#.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>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3155388" role="code"
xml-lang="en-US">#.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>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3145315" role="code" xml-lang="en-US">#
???/???</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3156152" role="tablecontent" xml-lang="en-US">.5 as
0.5</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149762" role="code"
xml-lang="en-US">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>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149763" role="code"
xml-lang="en-US">0.???</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="heading" id="hd_id3149276" xml-lang="en-US" level="3"
l10n="U" oldref="230">Thousands Separator</paragraph>
-<paragraph role="paragraph" id="par_id3154380" xml-lang="en-US" l10n="U"
oldref="21">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.</paragraph>
+
+<paragraph id="hd_id3149276" role="heading" level="3"
xml-lang="en-US">Thousands Separator</paragraph>
+<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.</paragraph>
+
<table id="tbl_id3150244">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id3154905" xml-lang="en-US" l10n="U"
oldref="22">Number Format</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id3150822" xml-lang="en-US" l10n="U"
oldref="23">Format Code</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3147264" xml-lang="en-US" l10n="U"
oldref="24">15000 as 15,000</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3151223" xml-lang="en-US" l10n="U"
oldref="25">#,###</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154935" xml-lang="en-US" l10n="U"
oldref="26">16000 as 16</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3153961" xml-lang="en-US" l10n="U"
oldref="27">#,</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154905" role="tablehead" xml-lang="en-US">Number
Format</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3150822" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3147264" role="tablecontent" xml-lang="en-US">15000
as 15,000</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3151223" role="code"
xml-lang="en-US">#,###</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154935" role="tablecontent" xml-lang="en-US">16000
as 16</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3153961" role="code" xml-lang="en-US">#,</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="heading" id="hd_id3154836" xml-lang="en-US" level="2"
l10n="U" oldref="79">Including Text in Number Format Codes</paragraph>
-<paragraph role="heading" id="hd_id3150398" xml-lang="en-US" level="3"
l10n="U" oldref="231">Text and Numbers</paragraph>
-<paragraph role="paragraph" id="par_id3154224" xml-lang="en-US" l10n="U"
oldref="80">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".</paragraph>
-<paragraph role="heading" id="hd_id3148979" xml-lang="en-US" level="3"
l10n="U" oldref="232">Text and Text</paragraph>
-<paragraph role="paragraph" id="par_id3153338" xml-lang="en-US" l10n="U"
oldref="82">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 role="heading" id="hd_id3154330" xml-lang="en-US" level="3"
l10n="U" oldref="233">Spaces</paragraph>
-<paragraph role="paragraph" id="par_id3156294" xml-lang="en-US" l10n="U"
oldref="81">To use a character to define the width of a space in a number
format, type an underscore ( _ ) 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 role="paragraph" id="par_id3156295" xml-lang="en-US" l10n="U"
oldref="256">To fill free space with a given character, use star character (*)
followed by this character. For instance:</paragraph>
-<paragraph role="code" id="par_id3156296" xml-lang="en-US" l10n="U"
oldref="257">*\0</paragraph>
-<paragraph role="paragraph" id="par_id3156297" xml-lang="en-US" l10n="U"
oldref="258">will display integer value (0) preceded by as many as needed
backslash characters (\) to fill column width. For accounting representation,
you may left align currency symbol with a format similar to:</paragraph>
-<paragraph role="code" id="par_id3156298" xml-lang="en-US" l10n="U"
oldref="259">$_-* 0.--;$-* 0.--;$_-* -</paragraph>
-<paragraph role="heading" id="hd_id3155994" xml-lang="en-US" level="2"
l10n="U" oldref="234">Color</paragraph>
-<paragraph role="paragraph" id="par_id3156423" xml-lang="en-US" l10n="U"
oldref="28">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="hd_id3154836" role="heading" level="2"
xml-lang="en-US">Including Text in Number Format Codes</paragraph>
+
+<paragraph id="hd_id3150398" role="heading" level="3" xml-lang="en-US">Text
and Numbers</paragraph>
+<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".</paragraph>
+
+<paragraph id="hd_id3148979" role="heading" level="3" xml-lang="en-US">Text
and Text</paragraph>
+<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="hd_id3154330" role="heading" level="3"
xml-lang="en-US">Spaces</paragraph>
+<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
( _ ) 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 star character (*) followed by this
character. For instance:</paragraph>
+<paragraph id="par_id3156296" role="code" 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 (\) 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" xml-lang="en-US">$_-* 0.--;$-*
0.--;$_-* -</paragraph>
+
+<paragraph id="hd_id3155994" role="heading" level="2"
xml-lang="en-US">Color</paragraph>
+<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>
+
<table id="tbl_id3157321">
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3154630" xml-lang="en-US" l10n="U"
oldref="29">CYAN</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3148676" xml-lang="en-US" l10n="U"
oldref="30">GREEN</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3154123" xml-lang="en-US" l10n="U"
oldref="31">BLACK</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3149167" xml-lang="en-US" l10n="U"
oldref="32">BLUE</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3158407" xml-lang="en-US" l10n="U"
oldref="33">MAGENTA</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3149560" xml-lang="en-US" l10n="U"
oldref="34">RED</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3147502" xml-lang="en-US" l10n="U"
oldref="35">WHITE</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3153368" xml-lang="en-US" l10n="U"
oldref="36">YELLOW</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154630" role="code"
xml-lang="en-US">CYAN</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3148676" role="code"
xml-lang="en-US">GREEN</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154123" role="code"
xml-lang="en-US">BLACK</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149167" role="code"
xml-lang="en-US">BLUE</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3158407" role="code"
xml-lang="en-US">MAGENTA</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149560" role="code"
xml-lang="en-US">RED</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3147502" role="code"
xml-lang="en-US">WHITE</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3153368" role="code"
xml-lang="en-US">YELLOW</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="heading" id="hd_id3147435" xml-lang="en-US" level="2"
l10n="U" oldref="111">Conditions</paragraph>
-<paragraph role="heading" id="hd_id3148575" xml-lang="en-US" level="3"
l10n="U" oldref="235">Conditional Brackets</paragraph>
-<paragraph role="paragraph" id="par_id3155312" xml-lang="en-US" l10n="U"
oldref="112">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 role="paragraph" id="par_id3159179" xml-lang="en-US" l10n="U"
oldref="115">You can use any combination of numbers and the <, <=, >,
>=, = and <> operators.</paragraph>
-<paragraph role="paragraph" id="par_id3159196" xml-lang="en-US" l10n="U"
oldref="236">For example, if you want to apply different colors to different
temperature data, enter:</paragraph>
-<paragraph role="example" id="par_id3150872" xml-lang="en-US" l10n="U"
oldref="113">[BLUE][<0]#.0 "°C";[RED][>30]#.0 "°C";[BLACK]#.0
"°C"</paragraph>
-<paragraph role="paragraph" id="par_id3157870" xml-lang="en-US" l10n="U"
oldref="114">All temperatures below zero are blue, temperatures between 0 and
30 °C are black, and temperatures higher than 30 °C are red.</paragraph>
-<paragraph role="heading" id="hd_id3154833" xml-lang="en-US" level="3"
l10n="U" oldref="90">Positive and Negative Numbers</paragraph>
-<paragraph role="paragraph" id="par_id3147295" xml-lang="en-US" l10n="U"
oldref="91">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 role="example" id="par_id3153727" xml-lang="en-US" l10n="U"
oldref="92">"plus" 0;"minus" 0;"null" 0</paragraph>
-
-<paragraph role="heading" id="hd_id3149260" xml-lang="en-US" level="2"
l10n="U" oldref="83">Percentages, Scientific Notation and Fraction
Representation</paragraph>
-<paragraph role="heading" id="hd_id3147218" xml-lang="en-US" level="3"
l10n="U" oldref="237">Percentages</paragraph>
-<paragraph role="paragraph" id="par_id3151168" xml-lang="en-US" l10n="CHG"
oldref="84">To display numbers as percentages, add the percent sign (%) to the
number format.</paragraph>
-<paragraph role="heading" id="hd_id3156005" xml-lang="en-US" level="3"
l10n="U" oldref="89">Scientific Notation</paragraph>
-<paragraph role="paragraph" id="par_id3146923" xml-lang="en-US" l10n="U"
oldref="85">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^5, and 0.000065 as 6.5 x 10^-5. <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.For instance: ###.##E+00</paragraph>
-<paragraph role="heading" id="hd_id3156006" xml-lang="en-US" level="3"
l10n="U" oldref="250">Fraction Representation</paragraph>
-<paragraph role="paragraph" id="par_id3146924" xml-lang="en-US" l10n="U"
oldref="251">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 role="paragraph" id="par_id3146925" xml-lang="en-US" l10n="U"
oldref="252">Denominator is calculated to get the nearest value of the fraction
with repsect to the number of placeholders. For example, PI value is
represented as 3 16/113 with format:</paragraph>
-<paragraph role="example" id="par_id3146926" xml-lang="en-US" l10n="U"
oldref="253"># ?/???</paragraph>
-<paragraph role="paragraph" id="par_id3146927" xml-lang="en-US" l10n="U"
oldref="254">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 role="example" id="par_id3146929" xml-lang="en-US" l10n="U"
oldref="255">?/16</paragraph>
-
-<paragraph role="heading" id="hd_id3159080" xml-lang="en-US" level="2"
l10n="U" oldref="98">Number Format Codes of Currency Formats</paragraph>
-<paragraph role="paragraph" id="par_id3147318" xml-lang="en-US" l10n="CHG"
oldref="99">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 role="paragraph" id="par_id3150032" xml-lang="en-US" l10n="U"
oldref="167">You can also specify the locale setting for the currency by
entering the locale code for the country after the symbol. For example,
[$â¬-407] 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="hd_id3147435" role="heading" level="2"
xml-lang="en-US">Conditions</paragraph>
+
+<paragraph id="hd_id3148575" role="heading" level="3"
xml-lang="en-US">Conditional Brackets</paragraph>
+<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" 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="hd_id3154833" role="heading" level="3"
xml-lang="en-US">Positive and Negative Numbers</paragraph>
+<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="hd_id3149260" role="heading" level="2"
xml-lang="en-US">Percentages, Scientific Notation and Fraction
Representation</paragraph>
+
+<paragraph id="hd_id3147218" role="heading" level="3"
xml-lang="en-US">Percentages</paragraph>
+<paragraph id="par_id3151168" role="paragraph" xml-lang="en-US">To display
numbers as percentages, add the percent sign (%) to the number
format.</paragraph>
+
+<paragraph id="hd_id3156005" role="heading" level="3"
xml-lang="en-US">Scientific Notation</paragraph>
+<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^5, and
0.000065 as 6.5 x 10^-5. <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.For instance: ###.##E+00</paragraph>
+
+<paragraph id="hd_id3156006" role="heading" level="3"
xml-lang="en-US">Fraction Representation</paragraph>
+<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 repsect to the number
of placeholders. For example, PI value is represented as 3 16/113 with
format:</paragraph>
+<paragraph id="par_id3146926" role="example" 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" xml-lang="en-US">?/16</paragraph>
+
+<paragraph id="hd_id3159080" role="heading" level="2" xml-lang="en-US">Number
Format Codes of Currency Formats</paragraph>
+<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, [$â¬-407] 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#waehrungtext"/>
-<paragraph role="heading" id="hd_id3157309" xml-lang="en-US" level="2"
l10n="U" oldref="238">Date and Time Formats</paragraph>
-<paragraph role="heading" id="hd_id3153740" xml-lang="en-US" level="3"
l10n="U" oldref="37">Date Formats</paragraph>
-<paragraph role="paragraph" id="par_id3152791" xml-lang="en-US" l10n="U"
oldref="38">To display days, months and years, use the following number format
codes. </paragraph>
-<paragraph role="warning" id="par_id610980" xml-lang="en-US" l10n="NEW">Not
all format codes give meaningful results for all languages.</paragraph>
+<paragraph id="hd_id3157309" role="heading" level="2" xml-lang="en-US">Date
and Time Formats</paragraph>
+
+<paragraph id="hd_id3153740" role="heading" level="3" xml-lang="en-US">Date
Formats</paragraph>
+<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>
+
<table id="tbl_id3147426">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id3152376" xml-lang="en-US" l10n="U"
oldref="39">Format</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id3159130" xml-lang="en-US" l10n="U"
oldref="40">Format Code</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3147380" xml-lang="en-US" l10n="U"
oldref="41">Month as 3.</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3146928" xml-lang="en-US" l10n="U"
oldref="42">M</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3145594" xml-lang="en-US" l10n="U"
oldref="43">Month as 03.</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3153052" xml-lang="en-US" l10n="U"
oldref="44">MM</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3145728" xml-lang="en-US" l10n="U"
oldref="45">Month as Jan-Dec</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3151073" xml-lang="en-US" l10n="U"
oldref="46">MMM</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3149909" xml-lang="en-US" l10n="U"
oldref="47">Month as January-December</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3155318" xml-lang="en-US" l10n="U"
oldref="48">MMMM</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3151218" xml-lang="en-US" l10n="U"
oldref="116">First letter of Name of Month</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3150420" xml-lang="en-US" l10n="U"
oldref="117">MMMMM</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154501" xml-lang="en-US" l10n="U"
oldref="49">Day as 2</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3156181" xml-lang="en-US" l10n="U"
oldref="50">D</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3146969" xml-lang="en-US" l10n="U"
oldref="51">Day as 02</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3156358" xml-lang="en-US" l10n="U"
oldref="52">DD</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3148495" xml-lang="en-US" l10n="U"
oldref="53">Day as Sun-Sat</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3161665" xml-lang="en-US" l10n="U"
oldref="54">NN or DDD</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154272" xml-lang="en-US" l10n="U"
oldref="118">Day as Sunday to Saturday</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3145164" xml-lang="en-US" l10n="U"
oldref="119">NNN or DDDD</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3146791" xml-lang="en-US" l10n="U"
oldref="55">Day followed by comma, as in "Sunday,"</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3146081" xml-lang="en-US" l10n="U"
oldref="56">NNNN</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3156275" xml-lang="en-US" l10n="U"
oldref="57">Year as 00-99</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3143236" xml-lang="en-US" l10n="U"
oldref="58">YY</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3148408" xml-lang="en-US" l10n="U"
oldref="59">Year as 1900-2078</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3151358" xml-lang="en-US" l10n="U"
oldref="60">YYYY</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3153355" xml-lang="en-US" l10n="U"
oldref="96">Calendar week</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3150744" xml-lang="en-US" l10n="U"
oldref="97">WW</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154302" xml-lang="en-US" l10n="U"
oldref="103">Quarterly as Q1 to Q4</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3159266" xml-lang="en-US" l10n="CHG"
oldref="104">Q</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3147583" xml-lang="en-US" l10n="U"
oldref="105">Quarterly as 1st quarter to 4th quarter</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3146918" xml-lang="en-US" l10n="U"
oldref="106">QQ</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3147534" xml-lang="en-US" l10n="U"
oldref="120">Era on the Japanese Gengou calendar, single character (possible
values are: M, T, S, H)</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3151249" xml-lang="en-US" l10n="U"
oldref="121">G</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3163806" xml-lang="en-US" l10n="U"
oldref="122">Era, abbreviation</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3155962" xml-lang="en-US" l10n="U"
oldref="123">GG</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3151187" xml-lang="en-US" l10n="U"
oldref="124">Era, full name</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3149568" xml-lang="en-US" l10n="U"
oldref="125">GGG</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3147344" xml-lang="en-US" l10n="U"
oldref="126">Number of the year within an era, without a leading zero for
single-digit years</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3147255" xml-lang="en-US" l10n="U"
oldref="127">E</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3148487" xml-lang="en-US" l10n="U"
oldref="128">Number of the year within an era, with a leading zero for
single-digit years</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3150298" xml-lang="en-US" l10n="U"
oldref="129">EE or R</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3152861" xml-lang="en-US" l10n="U"
oldref="138">Era, full name and year</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3149926" xml-lang="en-US" l10n="U"
oldref="139">RR or GGGEE</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3152376" role="tablehead"
xml-lang="en-US">Format</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3159130" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3147380" role="tablecontent" xml-lang="en-US">Month
as 3.</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3146928" role="code" xml-lang="en-US">M</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3145594" role="tablecontent" xml-lang="en-US">Month
as 03.</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3153052" role="code" xml-lang="en-US">MM</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3145728" role="tablecontent" xml-lang="en-US">Month
as Jan-Dec</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3151073" role="code"
xml-lang="en-US">MMM</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3149909" role="tablecontent" xml-lang="en-US">Month
as January-December</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3155318" role="code"
xml-lang="en-US">MMMM</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3151218" role="tablecontent" xml-lang="en-US">First
letter of Name of Month</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3150420" role="code"
xml-lang="en-US">MMMMM</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154501" role="tablecontent" xml-lang="en-US">Day
as 2</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3156181" role="code" xml-lang="en-US">D</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3146969" role="tablecontent" xml-lang="en-US">Day
as 02</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3156358" role="code" xml-lang="en-US">DD</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3148495" role="tablecontent" xml-lang="en-US">Day
as Sun-Sat</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3161665" role="code" xml-lang="en-US">NN or
DDD</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154272" role="tablecontent" xml-lang="en-US">Day
as Sunday to Saturday</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3145164" role="code" xml-lang="en-US">NNN or
DDDD</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3146791" role="tablecontent" xml-lang="en-US">Day
followed by comma, as in "Sunday,"</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3146081" role="code"
xml-lang="en-US">NNNN</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3156275" role="tablecontent" xml-lang="en-US">Year
as 00-99</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3143236" role="code" xml-lang="en-US">YY</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3148408" role="tablecontent" xml-lang="en-US">Year
as 1900-2078</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3151358" role="code"
xml-lang="en-US">YYYY</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3153355" role="tablecontent"
xml-lang="en-US">Calendar week</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3150744" role="code" xml-lang="en-US">WW</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154302" role="tablecontent"
xml-lang="en-US">Quarterly as Q1 to Q4</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3159266" role="code" xml-lang="en-US">Q</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3147583" role="tablecontent"
xml-lang="en-US">Quarterly as 1st quarter to 4th quarter</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3146918" role="code" xml-lang="en-US">QQ</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3147534" role="tablecontent" xml-lang="en-US">Era
on the Japanese Gengou calendar, single character (possible values are: M, T,
S, H)</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3151249" role="code" xml-lang="en-US">G</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3163806" role="tablecontent" xml-lang="en-US">Era,
abbreviation</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3155962" role="code" xml-lang="en-US">GG</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3151187" role="tablecontent" xml-lang="en-US">Era,
full name</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149568" role="code"
xml-lang="en-US">GGG</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3147344" role="tablecontent"
xml-lang="en-US">Number of the year within an era, without a leading zero for
single-digit years</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3147255" role="code" xml-lang="en-US">E</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3148487" role="tablecontent"
xml-lang="en-US">Number of the year within an era, with a leading zero for
single-digit years</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3150298" role="code" xml-lang="en-US">EE or
R</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3152861" role="tablecontent" xml-lang="en-US">Era,
full name and year</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149926" role="code" xml-lang="en-US">RR or
GGGEE</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="paragraph" id="par_id1002200811423518" xml-lang="en-US"
l10n="NEW">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 will need to know the formatting codes used in that other
locale. </paragraph>
-<paragraph role="paragraph" id="par_id1002200811423556" xml-lang="en-US"
l10n="NEW">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" 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 will 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>
+
<table id="tbl_id1002200811465915">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id1002200811563044" xml-lang="en-US"
l10n="NEW">Locale</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id1002200811563137" xml-lang="en-US"
l10n="NEW">Year</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id1002200811563164" xml-lang="en-US"
l10n="NEW">Month</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id1002200811563128" xml-lang="en-US"
l10n="NEW">Day</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id1002200811563135" xml-lang="en-US"
l10n="NEW">Hour</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id1002200811563289" xml-lang="en-US"
l10n="NEW">Day Of Week</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id100220081156322" xml-lang="en-US"
l10n="NEW">Era</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563233" xml-lang="en-US"
l10n="NEW">English - en</paragraph>
-<paragraph role="tablecontent" id="par_id1002200811563243" xml-lang="en-US"
l10n="NEW">and all not listed locales</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563352" xml-lang="en-US"
l10n="NEW">Y</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563396" xml-lang="en-US"
l10n="NEW">M</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563385" xml-lang="en-US"
l10n="NEW">D</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563472" xml-lang="en-US"
l10n="NEW">H</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563430" xml-lang="en-US"
l10n="NEW">N</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563488" xml-lang="en-US"
l10n="NEW">G</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563484" xml-lang="en-US"
l10n="NEW">German - de</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563518" xml-lang="en-US"
l10n="NEW">J</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563735" xml-lang="en-US"
l10n="NEW">T</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563823" xml-lang="en-US"
l10n="NEW">Netherlands - nl</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563852" xml-lang="en-US"
l10n="NEW">J</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563827" xml-lang="en-US"
l10n="NEW">U</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563916" xml-lang="en-US"
l10n="NEW">French - fr</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563970" xml-lang="en-US"
l10n="NEW">A</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811563980" xml-lang="en-US"
l10n="NEW">J</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564065" xml-lang="en-US"
l10n="NEW">O</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id100220081156407" xml-lang="en-US"
l10n="NEW">Italian - it</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id100220081156403" xml-lang="en-US"
l10n="NEW">A</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564042" xml-lang="en-US"
l10n="NEW">G</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id100220081156412" xml-lang="en-US"
l10n="NEW">O</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564119" xml-lang="en-US"
l10n="NEW">X</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564197" xml-lang="en-US"
l10n="NEW">Portuguese - pt</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564272" xml-lang="en-US"
l10n="NEW">A</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id100220081156423" xml-lang="en-US"
l10n="NEW">O</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564218" xml-lang="en-US"
l10n="NEW">Spanish - es</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564390" xml-lang="en-US"
l10n="NEW">A</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564319" xml-lang="en-US"
l10n="NEW">O</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id100220081156433" xml-lang="en-US"
l10n="NEW">Danish - da</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id100220081156444" xml-lang="en-US"
l10n="NEW">T</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564448" xml-lang="en-US"
l10n="NEW">Norwegian - no, nb, nn</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564549" xml-lang="en-US"
l10n="NEW">T</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564565" xml-lang="en-US"
l10n="NEW">Swedish - sv</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564556" xml-lang="en-US"
l10n="NEW">T</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564637" xml-lang="en-US"
l10n="NEW">Finnish - fi</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564627" xml-lang="en-US"
l10n="NEW">V</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564643" xml-lang="en-US"
l10n="NEW">K</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564763" xml-lang="en-US"
l10n="NEW">P</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id1002200811564715" xml-lang="en-US"
l10n="NEW">T</paragraph>
-</tablecell>
-<tablecell>
-</tablecell>
-<tablecell>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811563044" role="tablehead"
xml-lang="en-US">Locale</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563137" role="tablehead"
xml-lang="en-US">Year</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563164" role="tablehead"
xml-lang="en-US">Month</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563128" role="tablehead"
xml-lang="en-US">Day</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563135" role="tablehead"
xml-lang="en-US">Hour</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563289" role="tablehead"
xml-lang="en-US">Day Of Week</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id100220081156322" role="tablehead"
xml-lang="en-US">Era</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811563233" role="tablecontent"
xml-lang="en-US">English - en</paragraph>
+ <paragraph id="par_id1002200811563243" role="tablecontent"
xml-lang="en-US">and all not listed locales</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563352" role="tablecontent"
xml-lang="en-US">Y</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563396" role="tablecontent"
xml-lang="en-US">M</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563385" role="tablecontent"
xml-lang="en-US">D</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563472" role="tablecontent"
xml-lang="en-US">H</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563430" role="tablecontent"
xml-lang="en-US">N</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563488" role="tablecontent"
xml-lang="en-US">G</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811563484" role="tablecontent"
xml-lang="en-US">German - de</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563518" role="tablecontent"
xml-lang="en-US">J</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563735" role="tablecontent"
xml-lang="en-US">T</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811563823" role="tablecontent"
xml-lang="en-US">Netherlands - nl</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563852" role="tablecontent"
xml-lang="en-US">J</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563827" role="tablecontent"
xml-lang="en-US">U</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811563916" role="tablecontent"
xml-lang="en-US">French - fr</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563970" role="tablecontent"
xml-lang="en-US">A</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811563980" role="tablecontent"
xml-lang="en-US">J</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564065" role="tablecontent"
xml-lang="en-US">O</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id100220081156407" role="tablecontent"
xml-lang="en-US">Italian - it</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id100220081156403" role="tablecontent"
xml-lang="en-US">A</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564042" role="tablecontent"
xml-lang="en-US">G</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id100220081156412" role="tablecontent"
xml-lang="en-US">O</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564119" role="tablecontent"
xml-lang="en-US">X</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811564197" role="tablecontent"
xml-lang="en-US">Portuguese - pt</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564272" role="tablecontent"
xml-lang="en-US">A</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id100220081156423" role="tablecontent"
xml-lang="en-US">O</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811564218" role="tablecontent"
xml-lang="en-US">Spanish - es</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564390" role="tablecontent"
xml-lang="en-US">A</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564319" role="tablecontent"
xml-lang="en-US">O</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id100220081156433" role="tablecontent"
xml-lang="en-US">Danish - da</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id100220081156444" role="tablecontent"
xml-lang="en-US">T</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811564448" role="tablecontent"
xml-lang="en-US">Norwegian - no, nb, nn</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564549" role="tablecontent"
xml-lang="en-US">T</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811564565" role="tablecontent"
xml-lang="en-US">Swedish - sv</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564556" role="tablecontent"
xml-lang="en-US">T</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id1002200811564637" role="tablecontent"
xml-lang="en-US">Finnish - fi</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564627" role="tablecontent"
xml-lang="en-US">V</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564643" role="tablecontent"
xml-lang="en-US">K</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564763" role="tablecontent"
xml-lang="en-US">P</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id1002200811564715" role="tablecontent"
xml-lang="en-US">T</paragraph>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ <tablecell>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="heading" id="hd_id3149929" xml-lang="en-US" level="3"
l10n="U" oldref="227">Entering Dates</paragraph>
-<paragraph role="paragraph" id="par_id3148397" xml-lang="en-US" l10n="U"
oldref="228">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 role="paragraph" id="par_id3153274" xml-lang="en-US" l10n="U"
oldref="137">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 role="paragraph" id="par_id3153795" xml-lang="en-US" l10n="U"
oldref="216">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="hd_id3149929" role="heading" level="3"
xml-lang="en-US">Entering Dates</paragraph>
+<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>
+
<table id="tbl_id3145133">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id3145764" xml-lang="en-US" l10n="U"
oldref="217">Modifier</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id3152967" xml-lang="en-US" l10n="U"
oldref="218">Calendar</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3148390" xml-lang="en-US" l10n="U"
oldref="219">[~buddhist]</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3153781" xml-lang="en-US" l10n="U"
oldref="220">Thai Buddhist Calendar</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3157969" xml-lang="en-US" l10n="U"
oldref="133">[~gengou]</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154656" xml-lang="en-US" l10n="U"
oldref="134">Japanese Gengou Calendar</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3150086" xml-lang="en-US" l10n="U"
oldref="131">[~gregorian]</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3146070" xml-lang="en-US" l10n="U"
oldref="132">Gregorian Calendar</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3146808" xml-lang="en-US" l10n="U"
oldref="221">[~hanja] or [~hanja_yoil]</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3149207" xml-lang="en-US" l10n="U"
oldref="136">Korean Calendar</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3150304" xml-lang="en-US" l10n="U"
oldref="222">[~hijri]</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3149238" xml-lang="en-US" l10n="U"
oldref="223">Arabic Islamic Calendar, currently supported for the following
locales: ar_EG, ar_LB, ar_SA, and ar_TN</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3154903" xml-lang="en-US" l10n="U"
oldref="224">[~jewish]</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3151288" xml-lang="en-US" l10n="U"
oldref="225">Jewish Calendar</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="code" id="par_id3166442" xml-lang="en-US" l10n="U"
oldref="135">[~ROC]</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3145587" xml-lang="en-US" l10n="U"
oldref="226">Republic Of China Calendar</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3145764" role="tablehead"
xml-lang="en-US">Modifier</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3152967" role="tablehead"
xml-lang="en-US">Calendar</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3148390" role="code"
xml-lang="en-US">[~buddhist]</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3153781" role="tablecontent" xml-lang="en-US">Thai
Buddhist Calendar</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3157969" role="code"
xml-lang="en-US">[~gengou]</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3154656" role="tablecontent"
xml-lang="en-US">Japanese Gengou Calendar</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3150086" role="code"
xml-lang="en-US">[~gregorian]</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3146070" role="tablecontent"
xml-lang="en-US">Gregorian Calendar</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3146808" role="code" xml-lang="en-US">[~hanja] or
[~hanja_yoil]</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149207" role="tablecontent"
xml-lang="en-US">Korean Calendar</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3150304" role="code"
xml-lang="en-US">[~hijri]</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149238" role="tablecontent"
xml-lang="en-US">Arabic Islamic Calendar, currently supported for the following
locales: ar_EG, ar_LB, ar_SA, and ar_TN</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154903" role="code"
xml-lang="en-US">[~jewish]</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3151288" role="tablecontent"
xml-lang="en-US">Jewish Calendar</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3166442" role="code"
xml-lang="en-US">[~ROC]</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3145587" role="tablecontent"
xml-lang="en-US">Republic Of China Calendar</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="paragraph" id="par_id3152419" xml-lang="en-US" l10n="U"
oldref="140"><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:
+<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>
<switch select="appl">
<case select="CALC">
+
<table id="tbl_id3150490">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id3154194" xml-lang="en-US" l10n="U"
oldref="141">Initial Format</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id3149787" xml-lang="en-US" l10n="U"
oldref="142">Result Format</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3152993" xml-lang="en-US" l10n="U"
oldref="143">Date + Date</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3150292" xml-lang="en-US" l10n="U"
oldref="144">Number (Days)</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3150460" xml-lang="en-US" l10n="U"
oldref="145">Date + Number</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154371" xml-lang="en-US" l10n="U"
oldref="146">Date</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3145082" xml-lang="en-US" l10n="U"
oldref="147">Date + Time</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3156290" xml-lang="en-US" l10n="U"
oldref="148">Date&Time</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3152456" xml-lang="en-US" l10n="U"
oldref="149">Date + Date&Time</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3156169" xml-lang="en-US" l10n="U"
oldref="150">Number</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154527" xml-lang="en-US" l10n="U"
oldref="151">Time + Time</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3159625" xml-lang="en-US" l10n="U"
oldref="152">Time</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3146802" xml-lang="en-US" l10n="U"
oldref="153">Time + Number</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3146770" xml-lang="en-US" l10n="U"
oldref="154">Time</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3155500" xml-lang="en-US" l10n="U"
oldref="155">Time + Date&Time</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3155128" xml-lang="en-US" l10n="U"
oldref="156">Date&Time</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3152904" xml-lang="en-US" l10n="U"
oldref="157">Date&Time + Date&Time</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3159143" xml-lang="en-US" l10n="U"
oldref="158">Time</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3148909" xml-lang="en-US" l10n="U"
oldref="159">Date&Time + Number</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154806" xml-lang="en-US" l10n="U"
oldref="160">Date&Time</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3151269" xml-lang="en-US" l10n="U"
oldref="161">Number + Number</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154951" xml-lang="en-US" l10n="U"
oldref="162">Number</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154194" role="tablehead" xml-lang="en-US">Initial
Format</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149787" role="tablehead" xml-lang="en-US">Result
Format</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3152993" role="tablecontent" xml-lang="en-US">Date
+ Date</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3150292" role="tablecontent"
xml-lang="en-US">Number (Days)</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3150460" role="tablecontent" xml-lang="en-US">Date
+ Number</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3154371" role="tablecontent"
xml-lang="en-US">Date</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3145082" role="tablecontent" xml-lang="en-US">Date
+ Time</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3156290" role="tablecontent"
xml-lang="en-US">Date&Time</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3152456" role="tablecontent" xml-lang="en-US">Date
+ Date&Time</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3156169" role="tablecontent"
xml-lang="en-US">Number</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154527" role="tablecontent" xml-lang="en-US">Time
+ Time</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3159625" role="tablecontent"
xml-lang="en-US">Time</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3146802" role="tablecontent" xml-lang="en-US">Time
+ Number</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3146770" role="tablecontent"
xml-lang="en-US">Time</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3155500" role="tablecontent" xml-lang="en-US">Time
+ Date&Time</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3155128" role="tablecontent"
xml-lang="en-US">Date&Time</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3152904" role="tablecontent"
xml-lang="en-US">Date&Time + Date&Time</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3159143" role="tablecontent"
xml-lang="en-US">Time</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3148909" role="tablecontent"
xml-lang="en-US">Date&Time + Number</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3154806" role="tablecontent"
xml-lang="en-US">Date&Time</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3151269" role="tablecontent"
xml-lang="en-US">Number + Number</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3154951" role="tablecontent"
xml-lang="en-US">Number</paragraph>
+ </tablecell>
+ </tablerow>
</table>
</case>
</switch>
-<paragraph role="paragraph" id="par_id3149174" xml-lang="en-US" l10n="U"
oldref="163"><switchinline select="appl"><caseinline select="CALC">The
Date&Time format displays the date and time that an entry was made to a
cell with this format.
+<paragraph id="par_id3149174" role="paragraph" xml-lang="en-US"><switchinline
select="appl"><caseinline select="CALC">The Date&Time 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#jahreszahlen"/>
-<paragraph role="note" id="par_id3143225" xml-lang="en-US" l10n="U"
oldref="164">By default in <item type="productname">%PRODUCTNAME</item>, a date
with the value "0" corresponds to Dec 30, 1899.</paragraph>
+<case select="CALC">
+<embed href="text/shared/optionen/01010600.xhp#jahreszahlen"/>
+<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>
</case>
</switch>
-<paragraph role="heading" id="hd_id3155870" xml-lang="en-US" level="3"
l10n="U" oldref="61">Time Formats</paragraph>
-<paragraph role="paragraph" id="par_id3150108" xml-lang="en-US" l10n="U"
oldref="62">To display hours, minutes and seconds use the following number
format codes.</paragraph>
+
+<paragraph id="hd_id3155870" role="heading" level="3" xml-lang="en-US">Time
Formats</paragraph>
+<paragraph id="par_id3150108" role="paragraph" xml-lang="en-US">To display
hours, minutes and seconds use the following number format codes.</paragraph>
+
<table id="tbl_id3154830">
-<tablerow>
-<tablecell>
-<paragraph role="tablehead" id="par_id3149158" xml-lang="en-US" l10n="U"
oldref="63">Format</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="tablehead" id="par_id3154341" xml-lang="en-US" l10n="U"
oldref="64">Format Code</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154557" xml-lang="en-US" l10n="U"
oldref="65">Hours as 0-23</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3156348" xml-lang="en-US" l10n="U"
oldref="66">H</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3143218" xml-lang="en-US" l10n="U"
oldref="67">Hours as 00-23</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3155266" xml-lang="en-US" l10n="U"
oldref="68">HH</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
- <paragraph role="tablecontent" id="par_id3143219" xml-lang="en-US" l10n="U"
oldref="243">Hours as 00 up to more than 23</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3155267" xml-lang="en-US" l10n="U"
oldref="244">[HH]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3150139" xml-lang="en-US" l10n="U"
oldref="69">Minutes as 0-59</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3149588" xml-lang="en-US" l10n="U"
oldref="70">M</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3150531" xml-lang="en-US" l10n="U"
oldref="71">Minutes as 00-59</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3147409" xml-lang="en-US" l10n="U"
oldref="72">MM</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3150532" xml-lang="en-US" l10n="U"
oldref="245">Minutes as 00 up to more than 59</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3147410" xml-lang="en-US" l10n="U"
oldref="246">[MM]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3154854" xml-lang="en-US" l10n="U"
oldref="73">Seconds as 0-59</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3156173" xml-lang="en-US" l10n="U"
oldref="74">S</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3149506" xml-lang="en-US" l10n="U"
oldref="75">Seconds as 00-59</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3157981" xml-lang="en-US" l10n="U"
oldref="76">SS</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="tablecontent" id="par_id3149507" xml-lang="en-US" l10n="U"
oldref="247">Seconds as 00 up to more than 59</paragraph>
-</tablecell>
-<tablecell>
-<paragraph role="code" id="par_id3157982" xml-lang="en-US" l10n="U"
oldref="248">[SS]</paragraph>
-</tablecell>
-</tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3149158" role="tablehead"
xml-lang="en-US">Format</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3154341" role="tablehead" xml-lang="en-US">Format
Code</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154557" role="tablecontent" xml-lang="en-US">Hours
as 0-23</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3156348" role="code" xml-lang="en-US">H</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3143218" role="tablecontent" xml-lang="en-US">Hours
as 00-23</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3155266" role="code" xml-lang="en-US">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>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3155267" role="code"
xml-lang="en-US">[HH]</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3150139" role="tablecontent"
xml-lang="en-US">Minutes as 0-59</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3149588" role="code" xml-lang="en-US">M</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3150531" role="tablecontent"
xml-lang="en-US">Minutes as 00-59</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3147409" role="code" xml-lang="en-US">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>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3147410" role="code"
xml-lang="en-US">[MM]</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3154854" role="tablecontent"
xml-lang="en-US">Seconds as 0-59</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3156173" role="code" xml-lang="en-US">S</paragraph>
+ </tablecell>
+ </tablerow>
+ <tablerow>
+ <tablecell>
+ <paragraph id="par_id3149506" role="tablecontent"
xml-lang="en-US">Seconds as 00-59</paragraph>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3157981" role="code" xml-lang="en-US">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>
+ </tablecell>
+ <tablecell>
+ <paragraph id="par_id3157982" role="code"
xml-lang="en-US">[SS]</paragraph>
+ </tablecell>
+ </tablerow>
</table>
-<paragraph role="note" id="par_id3156039" xml-lang="en-US" l10n="U"
oldref="77">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 role="paragraph" id="par_id3148650" xml-lang="en-US" l10n="U"
oldref="217">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 role="paragraph" id="par_id3148649" xml-lang="en-US" l10n="U"
oldref="102">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>
-<paragraph role="heading" id="hd_id3158404" xml-lang="en-US" level="2"
l10n="U" oldref="169">Displaying Numbers Using Native Characters</paragraph>
-<paragraph role="paragraph" id="par_id3149998" xml-lang="en-US" l10n="U"
oldref="170">To display numbers using native number characters, use a
[NatNum1], [NatNum2], ... [NatNum11] modifier at the beginning of a number
format codes.</paragraph>
-<paragraph role="paragraph" id="par_id3154600" xml-lang="en-US" l10n="U"
oldref="171">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 role="example" id="par_id3152546" xml-lang="en-US" l10n="U"
oldref="172">[NatNum1][$-411]0</paragraph>
-<paragraph role="paragraph" id="par_id3147269" xml-lang="en-US" l10n="U"
oldref="173">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 role="paragraph" id="par_idN11234" xml-lang="en-US"
l10n="NEW">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 role="heading" id="par_id3153111" xml-lang="en-US" level="3"
l10n="CHG" oldref="174">[NatNum1] Transliterations</paragraph>
-<table id="tbl_id1136841">
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3146895" xml-lang="en-US" l10n="U"
oldref="175">Chinese: Chinese lower case characters; CAL: 1/7/7
[DBNum1]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3152536" xml-lang="en-US" l10n="U"
oldref="176">Japanese: short Kanji characters [DBNum1]; CAL: 1/4/4
[DBNum1]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3146125" xml-lang="en-US" l10n="U"
oldref="177">Korean: Korean lower case characters [DBNum1]; CAL: 1/7/7
[DBNum1]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3149945" xml-lang="en-US" l10n="U"
oldref="178">Thai: Thai characters</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3153264" xml-lang="en-US" l10n="U"
oldref="179">Arabic: Indic characters</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3148973" xml-lang="en-US" l10n="U"
oldref="180">Indic: Indic characters</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_idN112A3" xml-lang="en-US"
l10n="NEW">Hebrew: Hebrew letters<comment>UFI: api-features "Hebrew
numbering"</comment></paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3147520" xml-lang="en-US" l10n="U"
oldref="181">[NatNum2] Transliteration in</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3155383" xml-lang="en-US" l10n="U"
oldref="182">Chinese: Chinese upper case characters; CAL: 2/8/8
[DBNum2]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3153931" xml-lang="en-US" l10n="U"
oldref="183">Japanese: traditional Kanji characters; CAL: 2/5/5
[DBNum2]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3155097" xml-lang="en-US" l10n="U"
oldref="184">Korean: Korean upper case characters [DBNum2]; CAL: 2/8/8
[DBNum2]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3152976" xml-lang="en-US" l10n="U"
oldref="185">[NatNum3] Transliteration in</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3154353" xml-lang="en-US" l10n="U"
oldref="186">Chinese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3154669" xml-lang="en-US" l10n="U"
oldref="187">Japanese: fullwidth Arabic digits; CAL: 3/3/3 [DBNum3]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3150472" xml-lang="en-US" l10n="U"
oldref="188">Korean: fullwidth Arabic digits [DBNum3]; CAL: 3/3/3
[DBNum3]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3157811" xml-lang="en-US" l10n="U"
oldref="189">[NatNum4] Transliteration in</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3154592" xml-lang="en-US" l10n="U"
oldref="190">Chinese: lower case text [DBNum1]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3150350" xml-lang="en-US" l10n="U"
oldref="191">Japanese: modern long Kanji text [DBNum2]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3150930" xml-lang="en-US" l10n="U"
oldref="192">Korean: formal lower case text</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3153546" xml-lang="en-US" l10n="U"
oldref="193">[NatNum5] Transliteration in</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3155612" xml-lang="en-US" l10n="U"
oldref="194">Chinese: Chinese upper case text [DBNum2]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3155909" xml-lang="en-US" l10n="U"
oldref="195">Japanese: traditional long Kanji text [DBNum3]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3151304" xml-lang="en-US" l10n="U"
oldref="196">Korean: formal upper case text</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3155075" xml-lang="en-US" l10n="U"
oldref="197">[NatNum6] Transliteration in</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3150214" xml-lang="en-US" l10n="U"
oldref="198">Chinese: fullwidth text [DBNum3]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3154114" xml-lang="en-US" l10n="U"
oldref="199">Japanese: fullwidth text</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3155344" xml-lang="en-US" l10n="U"
oldref="200">Korean: fullwidth text</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3155538" xml-lang="en-US" l10n="U"
oldref="201">[NatNum7] Transliteration in</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3145123" xml-lang="en-US" l10n="U"
oldref="202">Japanese: modern short Kanji text</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3149424" xml-lang="en-US" l10n="U"
oldref="203">Korean: informal lower case text</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3153688" xml-lang="en-US" l10n="U"
oldref="204">[NatNum8] Transliteration in</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
-<paragraph role="paragraph" id="par_id3156122" xml-lang="en-US" l10n="U"
oldref="205">Japanese: traditional short Kanji text [DBNum4]</paragraph>
-</tablecell>
-</tablerow>
-<tablerow>
-<tablecell>
... etc. - the rest is truncated
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
