To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=113628 Issue #|113628 Summary|ODF 1.2 conformance: TRUNC() with negative, non-intege |r second argument Component|Spreadsheet Version|OOO330m1 Platform|Unknown URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|pescetti
------- Additional comments from [email protected] Tue Aug 3 21:26:00 +0000 2010 ------- Paragraph 6.17.9 of the latest OpenFormula draft http://lists.oasis-open.org/archives/tc-announce/201007/msg00004.html defines TRUNC(a;b) as: --- Truncate number a to the number of digits specified by b. If b is zero, or absent, truncate to a decimal integer. If b is positive, truncate to the specified number of decimal places. If b is negative, truncate to the left of the decimal point. If b is not an integer, it is truncated. --- According to the definition, one would have TRUNC(123.456;-1.2)=TRUNC(123.456;TRUNC(-1.2))=TRUNC(123.456;-1)=-120 while OpenOffice.org gives TRUNC(123.456;-1.2)=-100. It is unclear to me whether this is a bug in OOo or in the standard draft, so I reported this in my comments at http://lists.oasis-open.org/archives/office-comment/201008/msg00002.html --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
