To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109572 Issue #|109572 Summary|Calc incorrectly treats integers in some cells of xls Component|Spreadsheet Version|OOO320m12 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|j4m0
------- Additional comments from j...@openoffice.org Wed Feb 24 12:50:08 +0000 2010 ------- The attached document contains the simple formula which is calclulated incorrectly. Take a look at cell G26. It contains following formula: =SUM(G23:G25). The specified cells (G23 G24 G25) contain respected integers: 31 31 30. Somehow, the displayed result is 90. Why is it so? We have a lot of such documents in our archive. It would be great also to know of any workaround or recommendation if there are any ways to detect and handle such errors. --------------------------------------------------------------------- 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