# Public Comment: Comment on ODF 1.2 OpenFormula (6.17 Rounding Functions)

XMLWordPrintable

#### Details

• Type: Bug
• Status: Applied
• Priority: Major
• Resolution: Fixed
• Affects Version/s: ODF 1.2 CD 05
• Fix Version/s:
• Component/s:
• Labels:
None
• Proposal:
Hide

#1:
From 6.17.1 General remove the sentence
"
Rounding functions convert an arbitrary Number into an Integer.
"
The resulting section 6.17.1 General would then be empty, so completely remove it.

#2:
In 6.17.2 CEILING replace
"
the amount of N is rounded away from zero to a multiple of significance and then the sign applied
"
with
"
the absolute value of N is rounded away from zero to a multiple of the absolute value of significance and then the sign applied
"

#3:
In 6.17.4 FLOOR replace
"
the amount of N is rounded toward zero to a multiple of significance and then the sign applied
"
with
"
the absolute value of N is rounded toward zero to a multiple of the absolute value of significance and then the sign applied
"

#4:
In 6.17.7 ROUNDDOWN replace
"
If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X.
"
If Digits is zero, or absent, round to the largest decimal integer whose absolute value is smaller or equal to the absolute value of X.

#5:
In 6.17.8 ROUNDUP replace
"
If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X.
"
with
"
If Digits is zero, or absent, round to the smallest decimal integer whose absolute value is larger or equal to the absolute value of X.
"

#6:
In 6.17.9 TRUNC replace
"
Syntax: TRUNC( Number a ; Number b )
"
with
"
Syntax: TRUNC( Number a ; Integer b )
"

Remove
"
If b is not an integer, it is truncated.
"
as the conversion from Number to Integer is defined.

Show
#1: From 6.17.1 General remove the sentence " Rounding functions convert an arbitrary Number into an Integer. " The resulting section 6.17.1 General would then be empty, so completely remove it. #2: In 6.17.2 CEILING replace " the amount of N is rounded away from zero to a multiple of significance and then the sign applied " with " the absolute value of N is rounded away from zero to a multiple of the absolute value of significance and then the sign applied " #3: In 6.17.4 FLOOR replace " the amount of N is rounded toward zero to a multiple of significance and then the sign applied " with " the absolute value of N is rounded toward zero to a multiple of the absolute value of significance and then the sign applied " #4: In 6.17.7 ROUNDDOWN replace " If Digits is zero, or absent, round to the largest decimal integer smaller or equal to X. " If Digits is zero, or absent, round to the largest decimal integer whose absolute value is smaller or equal to the absolute value of X. #5: In 6.17.8 ROUNDUP replace " If Digits is zero, or absent, round to the smallest decimal integer larger or equal to X. " with " If Digits is zero, or absent, round to the smallest decimal integer whose absolute value is larger or equal to the absolute value of X. " #6: In 6.17.9 TRUNC replace " Syntax: TRUNC( Number a ; Number b ) " with " Syntax: TRUNC( Number a ; Integer b ) " Remove " If b is not an integer, it is truncated. " as the conversion from Number to Integer is defined.

#### Description

Copied from office-comment list

Original author: Andrea Pescetti <pescetti@openoffice.org>
Original date: 3 Aug 2010 21:26:33 -0000
Original URL: http://lists.oasis-open.org/archives/office-comment/201008/msg00002.html

#### People

• Assignee:
Eike Rathke (Inactive)
Reporter:
Robert Weir (Inactive)
• Watchers:
0 Start watching this issue

#### Dates

• Created:
Updated:
Resolved: