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-1874) Description of Roundupis confusing

• From: OASIS Issues Tracker <workgroup_mailer@lists.oasis-open.org>
• To: office@lists.oasis-open.org
• Date: Tue, 11 May 2010 14:41:24 -0400 (EDT)

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

Eike Rathke updated OFFICE-1874:
--------------------------------

Proposal:
5.17.7	ROUNDDOWN
Summary: Rounds the value X towards zero to the number of digits specified by Digits
Syntax: ROUNDDOWN( Number X [ ; Integer Digits = 0 ] )
Returns: Number
Constraints: None
Semantics: Round X towards zero, to the precision specified by Digits. The number returned is a multiple of 10^Digits. If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X. If Digits is positive, round towards zero to the specified number of decimal places. If Digits is negative, round towards zero to the left of the decimal point by -Digits places.

5.17.8	ROUNDUP
Summary: Rounds the value X away from zero to the number of digits specified by Digits
Syntax: ROUNDUP( Number X [ ; Integer Digits = 0 ] )
Returns: Number
Constraints: None
Semantics: Round X away from zero, to the precision specified by Digits. The number returned is a multiple of 10^Digits. If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X. If Digits is positive, round away from zero to the specified number of decimal places. If Digits is negative, round away from zero to the left of the decimal point by -Digits places.

was:
5.17.8	ROUNDUP
Summary: Rounds the value X away from zero to the number of digits specified by Digits
Syntax: ROUNDUP( Number X [ ; Number Digits = 0 ] )
Returns: Number
Constraints: None
Semantics: Round X away from zero, to the precision specified by Digits. The number returned is the smallest number that is not less than X and is a multiple of 10Digits. If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X. If Digits is positive, round up (away from zero) to the specified number of decimal places. If Digits is negative, round down (away from zero) to the left of the decimal point by -Digits places.

Having (for ROUNDUP) "is the smallest number that is not less than X" does not fit with the behavior observed, removed that from the proposal. Fixed the "round down (away from zero)" vs "round up (away from zero)" descriptions. Added proposal for ROUNDDOWN as well. Note that Digits is an Integer in the Syntax.

> Description of Roundup is confusing
> -----------------------------------
>
>                 Key: OFFICE-1874
>                 URL: http://tools.oasis-open.org/issues/browse/OFFICE-1874
>             Project: OASIS Open Document Format for Office Applications (OpenDocument) TC
>          Issue Type: Bug
>          Components: OpenFormula
>    Affects Versions: ODF 1.2 Part 2 CD 2
>            Reporter: Andreas Guelzow
>            Assignee: Eike Rathke
>            Priority: Minor
>
> According to the description
> If Digits is positive, round to the specified number of decimal places. If Digits is negative, round to the left of the decimal point by -Digits places.
> So
> =ROUNDUP(1.45673; -2)
> should round to he left of the decimal point and yield 100.
> Similarly
> =ROUNDUP(9;1)
> should be 9 but this seems to be inconsistent with:
> The number returned is the smallest number that is not less than X and is a multiple of 10^Digits.
> Tha sentence should probably be:
> The number returned is the smallest number that is not less than X and is a multiple of 10^-Digits.

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