Issue 125837

Summary:	FIXED function only has one mandatory parameter
Product:	Calc	Reporter:	dominik.stadler <dominik.stadler>
Component:	help	Assignee:	AOO issues mailing list <issues>
Status:	CLOSED NOT_AN_OOO_ISSUE	QA Contact:
Severity:	Normal
Priority:	P3	CC:	dominik.stadler, kschenk, oooforum
Version:	4.1.1
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

Description dominik.stadler@gmx.at 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 dominik.stadler@gmx.at 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 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.