[OASIS Issue Tracker] Updated: (OFFICE-3354) Public Comment:Comment on ODF 1.2 OpenFormula (6.17 Rounding Functions)

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

     [ http://tools.oasis-open.org/issues/browse/OFFICE-3354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Eike Rathke updated OFFICE-3354:
--------------------------------

    Proposal: 
#1:
From 6.17.1 General remove the sentence
"
Rounding functions convert an arbitrary Number into an Integer.
"
The resulting section 6.17.1 General would then be empty, so completely remove it.


#2:
In 6.17.2 CEILING replace
"
the amount of N is rounded away from zero to a multiple of significance and then the sign applied
"
with
"
the absolute value of N is rounded away from zero to a multiple of the absolute value of significance and then the sign applied
"


#3:
In 6.17.4 FLOOR replace
"
the amount of N is rounded toward zero to a multiple of significance and then the sign applied
"
with
"
the absolute value of N is rounded toward zero to a multiple of the absolute value of significance and then the sign applied
"


#4:
In 6.17.7 ROUNDDOWN replace
"
If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X.
"
If Digits is zero, or absent, round to the largest decimal integer whose absolute value is smaller or equal to the absolute value of X.


#5:
In 6.17.8 ROUNDUP replace
"
If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X.
"
with
"
If Digits is zero, or absent, round to the smallest decimal integer whose absolute value is larger or equal to the absolute value of X.
"


#6:
In 6.17.9 TRUNC replace
"
Syntax: TRUNC( Number a ; Number b )
"
with
"
Syntax: TRUNC( Number a ; Integer b )
"

Remove
"
If b is not an integer, it is truncated.
"
as the conversion from Number to Integer is defined.


Note: the OP's example results of -120 and -100 in #6 TRUNC are wrong, they should be 120 and 100 instead. OOo's result of 100 is faulty.

> Public Comment: Comment on ODF 1.2 OpenFormula (6.17 Rounding Functions)
> ------------------------------------------------------------------------
>
>                 Key: OFFICE-3354
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-3354
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 CD 05
>            Reporter: Robert Weir 
>            Assignee: Eike Rathke
>             Fix For: ODF 1.2 CD 06
>
>
> Copied from office-comment list
> Original author: Andrea Pescetti <pescetti@openoffice.org> 
> Original date: 3 Aug 2010 21:26:33 -0000
> Original URL: http://lists.oasis-open.org/archives/office-comment/201008/msg00002.html

-- 
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