[OASIS Issue Tracker] Commented: (OFFICE-2006) CEILING and FLOOR:allow 2nd parameter to be missing

[OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>]

    [ http://tools.oasis-open.org/issues/browse/OFFICE-2006?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14995#action_14995 ] 

Andreas Guelzow  commented on OFFICE-2006:
------------------------------------------

I thin kthe proposal is insufficient, since the proposed statement:

"If significance is omitted or an empty parameter (two consecutive ;; semicolons)
it is assumed to be -1 if N is negative and +1 if N is positive, making the function act like the
normal mathematical floor function. "

is incorrect. Whether the function acts like the normal mathematical floor function is now dependent on teh value of mode if given.



> CEILING and FLOOR: allow 2nd parameter to be missing
> ----------------------------------------------------
>
>                 Key: OFFICE-2006
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-2006
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Improvement
>          Components: OpenFormula
>    Affects Versions: ODF 1.2
>            Reporter: Eike Rathke
>            Assignee: Eike Rathke
>            Priority: Critical
>             Fix For: ODF 1.2
>
>
> The current definitions of CEILING and FLOOR have the syntax (here using only FLOOR for illustration)
> FLOOR( Number N [ ; Number significance [ ; Number mode ] ] )
> Documents imported from alien file formats may encounter the forms FLOOR(N) or FLOOR(N;) and when saving to ODFF have to append the 3rd parameter to indicate the proper calculation mode. As the default value of 'significance' depends on the value of N, it is not possible to write a fixed value for 'significance'. We thus have to allow 'significance' as  an empty (two consecutive ;; semicolons) parameter.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://tools.oasis-open.org/issues/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira