summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorLaurent Balland-Poirier <laurent.balland-poirier@laposte.net>2016-01-26 22:34:23 +0100
committerjan iversen <jani@documentfoundation.org>2016-01-27 16:03:16 +0000
commited8d3d936d9008a34a1f59baee2c241157588dba (patch)
tree3cb38aea8d51e78b9b0fe1bf1c12487ac4102259
parentbfc1c602d8fd1fc1df98ce8a5d061635f0b8b9ea (diff)
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@documentfoundation.org> Tested-by: jan iversen <jani@documentfoundation.org>
-rw-r--r--source/text/shared/01/05020301.xhp20
1 files changed, 17 insertions, 3 deletions
diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp
index 301db2c21..b8998c9c7 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&#160;&#160; (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>