Apache OpenOffice (AOO) Bugzilla – Issue 110123
Incorrect operation
Last modified: 2010-03-26 14:36:57 UTC
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!
Your problem is probably here : http://www.openoffice.org/dev_docs/features/3.2/#calc_strings Regards. JBF
Well, such a feature is UNgood in my case! I have dozens of such text-in-a numeric-cell not only in this sheet but in others as well. Oh, yeah - it DOESN'T parse textual numbers, either - for example: the string " ' $40.00 " will generate the #VALUE! error! This is a typical entry BTW - I have other formulas, including logicals (IF statements), that derive adjustments from other cells, and the text-in-the-numeric-cell is a reminder of what the reference amount is; the amount has already been deducted in a previous cell.
Known issue *** This issue has been marked as a duplicate of 109165 ***
duplicate -> closed