To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110123 Issue #|110123 Summary|Incorrect operation Component|Spreadsheet Version|OOo 3.2 Platform|Other URL| OS/Version|Windows 2000 Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|viewing Assigned to|spreadsheet Reported by|rftom
------- Additional comments from [email protected] Mon Mar 15 03:45:15 +0000 2010 ------- I have a spreadsheet configured as my check register. I just updated to 3.2, and now, the spreadsheet no longer works correctly. Specifically, I occasionally enter text instead of numbers into a cell; previously, this was treated as a "zero" value by the formula. I now have an error message "!#VALUE" - instead of the expected result. The formula is simple - contents of the cell above, plus the cell to the left, minus the second cell to the left. Previously, if any of these cells contained text instead of numbers, the result was as if the cell had a value of zero. This is consistent with Lotus 123, by the way - non-numeric, non-formula contents are assigned a numeric value of zero, just as if the cell were empty. I don't have Excel (never did) but I believe that it also assigns ZERO to non-numeric entries. Please find out what happened, and fix this ASAP! Thanks! --------------------------------------------------------------------- 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]
