source/text/shared/01/05020301.xhp | 12 ++++++------
1 file changed, 6 insertions(+), 6 deletions(-)
New commits:
commit 90643687005e1a21c4067f253cc6adeda0c421e0
Author: Laurent Balland-Poirier <laurent.balland-poir...@laposte.net>
Date: Wed Mar 1 14:53:04 2017 +0100
Clarify examples for l10n using space as thousands separator
Number Format Code
In locale using space as thousands separator, some examples
may be not correctly interpreted.
This patch adds some text to explain how to solve this.
Beautify a little bit some examples.
Complete fraction description: any digit symbol (0, # or ?)
can be used to described any of the three parts of the fraction.
Change-Id: I5bab1da21b33cddfa0a63fbe5e3d53d64ed0103c
Reviewed-on: https://gerrit.libreoffice.org/34755
Reviewed-by: Olivier Hallot <olivier.hal...@edx.srv.br>
Tested-by: Olivier Hallot <olivier.hal...@edx.srv.br>
diff --git a/source/text/shared/01/05020301.xhp
b/source/text/shared/01/05020301.xhp
index 9c5ba9834..d2db2494a 100644
--- a/source/text/shared/01/05020301.xhp
+++ b/source/text/shared/01/05020301.xhp
@@ -66,7 +66,7 @@
<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_id3153323" role="paragraph" xml-lang="en-US">Use question
marks (?), zeroes (0) or number signs (#) 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">
@@ -168,7 +168,7 @@
<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>
+<paragraph id="par_id3154380" role="paragraph" xml-lang="en-US">Depending on
your language setting, you can use a comma, a period or a blank as a thousands
separator. You can also use the separator to reduce the size of the number that
is displayed by a multiple of 1000 for each separator. The examples below use
comma as thousands separator:</paragraph>
<table id="tbl_id3150244">
<tablerow>
@@ -201,7 +201,7 @@
<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="par_id3154224" role="paragraph" xml-lang="en-US">To include
text in a number format that is applied to a cell containing numbers, place a
double quotation mark (") in front of and behind the text, or a backslash (\)
before a single character. For example, enter <emph>#.# "meters"</emph> to
display "3.5 meters" or <emph>#.# \m</emph> to display "3.5 m". If you use
space as thousands separator, you need to insert spaces between quotes in the
previous examples: <emph>#.#" meters"</emph> or <emph>#.#\ \m</emph> to get the
correct result.</paragraph>
<paragraph id="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>
@@ -271,7 +271,7 @@
<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="par_id3146923" role="paragraph" xml-lang="en-US">Scientific
notation lets you write very large numbers or very small fractions in a compact
form. For example, in scientific notation, 650000 is written as 6.5 x
10<sup>5</sup>, and 0.000065 as 6.5 x 10<sup>-5</sup>. <comment>Translators:
use the decimal delimiter of your language (period or comma) for all number
format codes in Calc.</comment>In <item type="productname">%PRODUCTNAME</item>,
these numbers are written as 6.5E+5 and 6.5E-5, respectively. To create a
number format that displays numbers using scientific notation, enter a # or 0,
and then one of the following codes E-, E+, e- or e+. If sign is omitted after
E or e, it won't appear for positive value of exponent. To get engineering
notation, enter 3 digits (0 or #) in the integer part: <emph>###.##E+00</emph>
for instance.</paragraph>
<paragraph id="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>
@@ -282,7 +282,7 @@
<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>
+<paragraph id="par_id3150032" role="paragraph" xml-lang="en-US">You can also
specify the locale setting for the currency by entering the locale code for the
country after the symbol. For example, <emph>[$â¬-407]</emph> represents Euros
in Germany. To view the locale code for a country, select the country in the
<emph>Language</emph> list on the <emph>Numbers</emph> tab of the <emph>Format
Cells</emph> dialog.</paragraph>
<embed href="text/shared/01/05020300.xhp#waehrungtext"/>
<paragraph id="hd_id3157309" role="heading" level="2" xml-lang="en-US">Date
and Time Formats</paragraph>
@@ -1832,7 +1832,7 @@
<paragraph id="hd_id231020161309281519" role="heading" level="3"
xml-lang="en-US">Extended LCID</paragraph>
<paragraph id="par_id23102016124541451" role="paragraph" xml-lang="en-US">If
compatible, native numbering and calendar are exported to MS-Excel using
extended LCID. Extended LCID can also be used in string format instead of
NatNum modifier.</paragraph>
-<paragraph id="par_id23102016130928602" role="paragraph"
xml-lang="en-US">Extended LCID consists of 8 hexadecimal digits:
<emph>[$-NNCCLLLL]</emph>, with 2 first digits NN for native numerals, CC for
calendar and LLLL for LCID code. For instance, [$-0D0741E] will be converted to
[NatNum1][$-41E][~buddhist]: Thai numerals (0D) with Buddhist calendar (07) in
Thai locale (041E).</paragraph>
+<paragraph id="par_id23102016130928602" role="paragraph"
xml-lang="en-US">Extended LCID consists of 8 hexadecimal digits:
<emph>[$-NNCCLLLL]</emph>, with 2 first digits NN for native numerals, CC for
calendar and LLLL for LCID code. For instance, <emph>[$-0D0741E]</emph> will be
converted to <emph>[NatNum1][$-41E][~buddhist]</emph>: Thai numerals (0D) with
Buddhist calendar (07) in Thai locale (041E).</paragraph>
<paragraph id="par_id231020161309295474" role="paragraph"
xml-lang="en-US"><emph>Native Numerals</emph></paragraph>
<paragraph id="par_id231020161309291913" role="paragraph" xml-lang="en-US">Two
first digits NN represents native numerals:</paragraph>
_______________________________________________
Libreoffice-commits mailing list
libreoffice-comm...@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-commits
