[Libreoffice-bugs] [Bug 143183] New: Format Basic function needs better description of its 'format' argument

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: mikekaganski at hotmail.com
                CC: olivier.hallot at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210704/0354e325/attachment-0001.htm>