To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=111520 Issue #|111520 Summary|CONVERT_ADD uses wrong definintion for "Pica" Component|Spreadsheet Version|OOo 3.2 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P5 Subcomponent|programming Assigned to|spreadsheet Reported by|jes
------- Additional comments from j...@openoffice.org Mon May 10 19:21:26 +0000 2010 ------- Fresh from the department of pointless and pedantic trivia... The CONVERT_ADD function in OOo Calc converts 1 inch to 72 picas. This is not correct. The correct definitions[1,2] are: 1 foot = 72 pica 1 inch = 6 pica 1 inch = 72 point =CONVERT_ADD(1;"in";"Pica") -> 72 (the correct result is 6) Excel also uses the wrong definition; Gnumeric follows Excel. IMHO, errors should be corrected--period. But the fact that no one in the last 13+ years seems to have noticed this problem is a strong indication that no one actually uses this conversion, and therefore it doesn't matter much how it is resolved. The wrong definition also appears in the ODFF spec. I suppose, at the very least, the spec should mention that the common implementation is incorrect. [1] http://en.wikipedia.org/wiki/Pica_(typography) [2] http://en.wikipedia.org/wiki/Point_(typography) --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org