To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5658
------- Additional comments from kar...@openoffice.org Wed Jun 3 10:32:34 +0000 2009 ------- > I have never come across the problem defined here. I do have. One of our suppliers sent an excel sheet with proposal. I reviewed it (in OOO) and approoved seeing that the totals were the cheapest of all the offers. Already later when the agreement was signed it turned out that totals in the same spreadsheet differed for me and him. After some ponderig I discovered that some of the items in the spreadsheet were formed as text, apparently to make them look the right way or whatever. And as his excel calculated all the numbers correctly, he was not aware of problems that will cause for me. And as my OOO did not hint in any way that it is going to ignore some numbers-formed-as-text I did not catch the error. Those who suggest retraining users -- please return to planet earth. You can't retrain everybody even if you wanted to. Spreadsheets originate from so many sources that you simply do not control. In fact relying on the user to enter data correctly in the system is wrong approach anyway. Any system should be prepared to receive all kinds of sh*t thrown at it and handle it correctly. To those who preach purity. Fine! But then do not ignore numbers formed as text silently. Either pop ut a notice when opening the file or put appropriate error notice in the cell that attempts to use numbers-formed-as-text. Silent ignoring is the only wrong approach! --------------------------------------------------------------------- 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