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: [email protected]
Reporter: [email protected]
CC: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
