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] Created: (OFFICE-1874) Error in testcases ordescription for ROUNDUP


Error in testcases or description for ROUNDUP
---------------------------------------------

                 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
            Reporter: Andreas Guelzow 
            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]