[Libreoffice-commits] help.git: source/text
Laurent Balland-Poirier
laurent.balland-poirier at laposte.net
Sat Aug 13 19:11:24 UTC 2016
source/text/shared/01/05020301.xhp | 4 ++++
1 file changed, 4 insertions(+)
New commits:
commit 6193c8a5f97aa5d6922b412019c6da0bfda97590
Author: Laurent Balland-Poirier <laurent.balland-poirier at laposte.net>
Date: Sat Aug 13 12:56:21 2016 +0200
Add format star to repeat character
Number format modifier (*)
Change-Id: I9362ce7f8e87b2f9b957085da241c040316ed813
Reviewed-on: https://gerrit.libreoffice.org/28100
Reviewed-by: Olivier Hallot <ohallot at collabora.co.uk>
Tested-by: Olivier Hallot <ohallot at collabora.co.uk>
diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp
index 934a9bf..45bfdb8 100644
--- a/source/text/shared/01/05020301.xhp
+++ b/source/text/shared/01/05020301.xhp
@@ -193,6 +193,10 @@
<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>
<table id="tbl_id3157321">
More information about the Libreoffice-commits
mailing list