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 15:55: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.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.

Thanks, that should do. Adapted proposal.

> 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
>             Fix For: ODF 1.2 Part 2 CD 3
>
>
> 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
-