To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=109721
------- Additional comments from a...@openoffice.org Wed Jun 16 08:17:02 +0000 2010 ------- It seems to me that treating non-numeric text as a number is an obvious error. It should be treated as text to be ignored. (In other words, as having no impact on the calculations in question, equivalent to a value of zero.) To generate an error message is treating the text as a number -- albeit an invalid number. Since non-numeric text would not appear to be a number, there is no reason to expect that the user would want -- or expect -- the text to change in any respect the result of the calculations. But creating an error *does* change the result of the calculations. It is however, entirely reasonable to treat text that converts to a valid number as a number instead of text, since visually it would appear to be a number. A poorly conceived change in function should be recognised as a defect to be corrected, rather than an enhancement. --------------------------------------------------------------------- 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