[Libreoffice-commits] help.git: source/text
Laurent Balland-Poirier
laurent.balland-poirier at laposte.net
Wed Jan 27 08:03:58 PST 2016
source/text/shared/01/05020301.xhp | 20 +++++++++++++++++---
1 file changed, 17 insertions(+), 3 deletions(-)
New commits:
commit ed8d3d936d9008a34a1f59baee2c241157588dba
Author: Laurent Balland-Poirier <laurent.balland-poirier at laposte.net>
Date: Tue Jan 26 22:34:23 2016 +0100
tdf#40517 Update for '?' in decimal number format
Add help to use '?' in user defined number format
Correction of ordered list
Change-Id: Ia14a34cbc0d2d9cff4601a0bd19b392a3aaae268
Reviewed-on: https://gerrit.libreoffice.org/21827
Reviewed-by: jan iversen <jani at documentfoundation.org>
Tested-by: jan iversen <jani at documentfoundation.org>
diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp
index 301db2c..b8998c9 100644
--- a/source/text/shared/01/05020301.xhp
+++ b/source/text/shared/01/05020301.xhp
@@ -47,14 +47,12 @@
<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>
-</list>
-<list type="ordered">
<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>
</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) or the number sign (#) 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.</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>
<table id="tbl_id3149760">
@@ -76,6 +74,14 @@
</tablerow>
<tablerow>
<tablecell>
+<paragraph role="code" id="par_id3152801" xml-lang="en-US" l10n="U" oldref="239">?</paragraph>
+</tablecell>
+<tablecell>
+<paragraph role="tablecontent" id="par_id3145090" 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>
@@ -134,6 +140,14 @@
<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_id3156152" 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_id3149762" xml-lang="en-US" l10n="U" oldref="242">0.???</paragraph>
+</tablecell>
+</tablerow>
</table>
<paragraph role="heading" id="hd_id3149276" xml-lang="en-US" level="3" l10n="U" oldref="230">Thousands Separator</paragraph>
More information about the Libreoffice-commits
mailing list