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