Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||FIXED function only has one mandatory parameter|
|Component:||help||Assignee:||AOO issues mailing list <issues>|
|Status:||CLOSED NOT_AN_OOO_ISSUE||QA Contact:|
|Priority:||P3||CC:||dominik.stadler, kschenk, oooforum|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
Description firstname.lastname@example.org 2014-11-07 11:54:57 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.
Comment 1 oooforum (fr) 2014-11-07 13:39:56 UTC
Already reported *** This issue has been marked as a duplicate of issue 30470 ***
Comment 2 Kay 2014-11-09 23:39:03 UTC
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.
Comment 3 email@example.com 2014-11-10 13:16:20 UTC
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.
Comment 4 Kay 2014-11-10 17:12:23 UTC
(In reply to firstname.lastname@example.org 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.