diff options
| author | Laurent Balland-Poirier <laurent.balland-poirier@laposte.net> | 2016-01-26 22:34:23 +0100 |
|---|---|---|
| committer | jan iversen <jani@documentfoundation.org> | 2016-01-27 16:03:16 +0000 |
| commit | ed8d3d936d9008a34a1f59baee2c241157588dba (patch) | |
| tree | 3cb38aea8d51e78b9b0fe1bf1c12487ac4102259 /source/text/shared/01/05020301.xhp | |
| parent | bfc1c602d8fd1fc1df98ce8a5d061635f0b8b9ea (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>
Diffstat (limited to 'source/text/shared/01/05020301.xhp')
| -rw-r--r-- | source/text/shared/01/05020301.xhp | 20 |
1 files changed, 17 insertions, 3 deletions
diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp index 301db2c216..b8998c9c77 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> |