Apache OpenOffice (AOO) Bugzilla – Issue 125837
FIXED function only has one mandatory parameter
Last modified: 2017-05-20 09:54:55 UTC
OpenOffice documents FIXED as having two mandatory parameters, e.g. at * https://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_FIXED_function * In the file at http://sc.openoffice.org/excelfileformat.odt However Microsoft documents the function to have only one mandatory parameter, with a default value of "2" for "decimals" * http://office.microsoft.com/en-sg/excel-help/fixed-function-HP010342530.aspx * http://www.techonthenet.com/excel/formulas/fixed.php * http://office.microsoft.com/en-us/excel-help/fixed-function-HP010062565.aspx possibly also the implementation of the method should take this into account.
Already reported *** This issue has been marked as a duplicate of issue 30470 ***
In my opinion this is not a duplicate of: https://issues.apache.org/ooo/show_bug.cgi?id=30470 which deals with automatically specifying only 2 decimal places which currently you CAN do by appropriate cell formatting. Note to reporter: Here is the specification for the FIXED function according to the ODF 1.2 standard -- http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#FIXED Please note the ODF standard differs from whatever MS Excel is doing. The FIXED function works according to this specification. So the behavior you describe is not a defect.
I have to confess I don't know any OpenOffice internas, but the syntax "FIXED( Number N [ ; Integer D = 2 [ ; Logical OmitSeparators = FALSE() ] ] )" in the spec sounds like the second parameter is defined as optional as well. When I try it out in recent OpenOffice 4.1.1 I see that the method behaves with default "2" for D, so code-wise it seems to be fine. The current documentation in OpenOffice and the file defining the excelfileformat does not reflect that.
(In reply to dominik.stadler@gmx.at from comment #3) > I have to confess I don't know any OpenOffice internas, but the syntax > "FIXED( Number N [ ; Integer D = 2 [ ; Logical OmitSeparators = FALSE() ] ] > )" in the spec sounds like the second parameter is defined as optional as > well. > > When I try it out in recent OpenOffice 4.1.1 I see that the method behaves > with default "2" for D, so code-wise it seems to be fine. > > The current documentation in OpenOffice and the file defining the > excelfileformat does not reflect that. Ah! I see what you're saying. You are correct. The second parameter is required, not optional. Changing the component on this to Help instead of Editing and we will get this corrected. Sorry for any misunderstanding.