diff options
| author | Laurent Balland-Poirier <laurent.balland-poirier@laposte.net> | 2016-08-13 12:56:21 +0200 |
|---|---|---|
| committer | Olivier Hallot <ohallot@collabora.co.uk> | 2016-08-13 19:11:01 +0000 |
| commit | 6193c8a5f97aa5d6922b412019c6da0bfda97590 (patch) | |
| tree | 08ed5b079ad7ed5ecb5566f3e9bfb21e0f9f45cf /source | |
| parent | 6071229bf10bad31360c9347d8a785fe8446608a (diff) | |
Add format star to repeat character
Number format modifier (*)
Change-Id: I9362ce7f8e87b2f9b957085da241c040316ed813
Reviewed-on: https://gerrit.libreoffice.org/28100
Reviewed-by: Olivier Hallot <ohallot@collabora.co.uk>
Tested-by: Olivier Hallot <ohallot@collabora.co.uk>
Diffstat (limited to 'source')
| -rw-r--r-- | source/text/shared/01/05020301.xhp | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/source/text/shared/01/05020301.xhp b/source/text/shared/01/05020301.xhp index 934a9bf915..45bfdb86ce 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"> |