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