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 rainerbielef...@openoffice.org Sat Jun 26 08:00:38 +0000 2010 ------- I think I will have to revise my opinion. This is a real bug and problem. I am using CALC for business calculations (quotations, ...), and there i am used to use comments in the cells like "Option", "unavailable" or similar instead of prices in some cells. These comments appear in the final quotation, and for all SUM calculations the cells will be counted with value "0", what's ok for this application. Starting with 3.2. I will no longer be able to use CALC in the way I am used to because of the new behaviour, pls. see attached example "quotation.ods", what seems to be a typical CALC application. I can not confirm that regina's workaround is a solution with "Ooo-Dev 3.3 multilingual version English UI WIN XP: [DEV300m83 (Build 9511)]", pls see attached "quotation.ods" with 3.3. screenshot. If it would be my decision, I would renounce the text to number conversion in favor of compatibility to existing spreadsheets, EXCEL compatibility and usability. --------------------------------------------------------------------- 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