https://bugs.documentfoundation.org/show_bug.cgi?id=143183
Bug ID: 143183
Summary: Format Basic function needs better description of its
'format' argument
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Documentation
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: mikekagan...@hotmail.com
CC: olivier.hal...@libreoffice.org
In bug 114418, a link to Number format codes [1] was added to Format function
help page [2].
The next step should be to clarify the textual description of the 'format'
argument of the function, specifically:
1. Remove the incomplete information from [2] that duplicates part of [1], and
instead, put another reference to [1], with a clarification that only format
string elements for en-US are accepted in Basic format string;
2. Extend the "Predefined format" section, mentioning all the accepted special
Basic-only predefined formats, namely:
* "<" (lowercase)
* ">" (uppercase)
* "c" (same as "General Date")
* "n" (minute (1-2-digit))
* "nn" (minute (2-digit))
* "w" (weekday)
* "y" (day of year)
* "General Date" (short date format, optionally with "H:MM:SS AM/PM")
* "General Number" (0.############)
* "Currency" (depends on current locale settings)
* "Fixed" (0.00)
* "Standard" (@0.00)
* "Percent" (0.00%)
* "Scientific" (#.00E+00)
* "Yes/No" (Yes or no, localized)
* "True/False" (True or False, localized)
* "On/Off" (On or Off, localized)
[1]
https://help.libreoffice.org/7.2/en-US/text/shared/01/05020301.html?&DbPAR=BASIC
[2]
https://help.libreoffice.org/7.2/en-US/text/sbasic/shared/03120301.html?DbPAR=BASIC
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
