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

 


Help: OASIS Mailing Lists Help | MarkMail Help

office message

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


Subject: [OASIS Issue Tracker] Updated: (OFFICE-1874) (needs discussion)Description of Roundup is confusing



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

Eric Patterson updated OFFICE-1874:
-----------------------------------

    Proposal: 
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.


> (needs discussion) 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: Eric Patterson
>            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
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        


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