[Libreoffice-bugs] [Bug 140553] New: FIXED Function Documentation is not up to date

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=140553

            Bug ID: 140553
           Summary: FIXED Function Documentation is not up to date
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: dscheikey at gmail.com
                CC: olivier.hallot at libreoffice.org

Description:
In the help page of the FIXED function, the option Decimal places is not shown
as optional. How I found in OASIS Open
https://docs.oasis-open.org/office/OpenDocument/v1.3/cs02/part4-formula/OpenDocument-v1.3-cs02-part4-formula.html#FIXED
the second function is no longer absolutely necessary. It is conditionally
optional because a default value of 2 is used here if no value is entered.
In addition, the LO help does not report the option of entering negative values
to round the value to the left of the decimal point. An example should also be
given.

Changes:

FIXED(Number [; Decimals = 2 [; NoThousandsSeparators]]) 

Decimals (optional – default=2) refers to the number of decimal places to be
displayed. If no value is entered, 2 is used as the default value. If decimals
is negative, the function rounds to the nearest 10, 100, 1000, etc. 

Example: (additional)

FIXED(1234) returns 1,234.00 as a text string.
FIXED(1234;-3;1) returns 1000 as a text string.

Actual Results:


Expected Results:



Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
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/20210220/602a69c4/attachment.htm>