To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116740 Issue #|116740 Summary|strange VALUE error Component|Spreadsheet Version|OOo 3.3 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|tab
------- Additional comments from t...@openoffice.org Tue Feb 1 03:24:16 +0000 2011 ------- In BadValu.ods, the formula in cell B3 gives a VALUE error. Why? Now, do this: 0: put anything, eg, 'h' in cell A2; 1: select cell B3, hit f2 to edit it; 2: delete and reinsert any character, such as 'r' or '3'; 3: hit Enter: no more error! But, if you omit either step 0 or 2, the error remains. --------------------------------------------------------------------- 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