To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109721 Issue #|109721 Summary|In calc, calculations no longer treat non-numeric text | as zero Component|Spreadsheet Version|OOo 3.2 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|editing Assigned to|spreadsheet Reported by|andr55
------- Additional comments from and...@openoffice.org Tue Mar 2 03:50:00 +0000 2010 ------- Often one wishes to insert text in place of zero in calculation fields. It could be any text, depending on the context. For example, instead of "0", one might want "n/a" or "inactive" or some other comment, in different places in the same spreadsheet. This no longer works in OOo 3.2. It worked in OOo 3.1. This means that if a formula refers directly or indirectly to a cell containing non-numeric text, one gets an error message instead of the appropriate value. (In my case, as well as being inconvenient for new entries, requires changing up to thousands of existing fields by spreadsheet.) Non-numeric text should be treated as zero in calculations. Specified as P2 since a major function is broken. All calculations that use this feature are corrupted, in all existing spreadsheets. Adapting such spreadsheets can be very time-consuming. Re-adapting spreadsheets to use this feature, after this bug is fixed, will also be time-consuming. --------------------------------------------------------------------- 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