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.
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.
FIXED(1234) returns 1,234.00 as a text string.
FIXED(1234;-3;1) returns 1000 as a text string.
User Profile Reset: No
I can confirm this in LO 188.8.131.52.
The help page text/scalc/01/04060110.xhp should be updated.
Changing to NEW.
Alain Romedenne committed a patch related to this issue.
It has been pushed to "master":
tdf#140553 =FIXED documentation
An error has crept into the new examples. Once "," was used instead of ";".
(In reply to Olivier Hallot from comment #4)
> patch merged
I guess we can close it again