OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

# office message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]

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

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Thu, 23 Sep 2010 09:50:14 -0400 (EDT)

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