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

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

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