To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=60098 Issue #:|60098 Summary:|Spreadsheet: SUM Function displays invalid result Component:|Spreadsheet Version:|OOo 2.0 Platform:|All URL:| OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|viewing Assigned to:|spreadsheet Reported by:|npmaling
------- Additional comments from [EMAIL PROTECTED] Thu Jan 5 13:45:17 -0800 2006 ------- OpenOffice.org 2.0 Calc Enter series of 0.0000000001 into cells B2:M2 and type =SUM(B2;C2;D2;E2;F2;G2;H2;I2;J2;K2;L2;M2) or =SUM(B2:M2) into cell N2. The result should be 0.0000000012 but is displayed as 0.0000000000 Typing =0.0000000001*12 into a different cell shows the correct result. . The options/view has the display zero values box checked. . The display (Number Format: Add Decimal Place) has been set to show 10 decimal places. . The column width has been set to "optimal column width" sufficient to show 10 decimal places. The file scalc.exe is dated 10/5/2005 1:18 PM --------------------------------------------------------------------- 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]
