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 [EMAIL PROTECTED] Wed Jul 18 13:25:52 +0000 2007 ------- Sorry for duplicate post of this bug. Now that I am on the right thread... Those who claim that current functionality of OO is not broken probably have never worked in real life situations with spreadsheets. They are not always prepared by excel/OO gurus, who do everything correctly. They are prepared by very average people and at least by now most of the time in excel. I just happened to approove price offering sent by a supplier only to discover that some fields in his excel spreadsheed were formatted as text and thus caused 0,00 to appear in all the consequitive calculations for some items. Being a coder myself I know it is important to work by strict standards, but relying that user input will always be high quality is stupid. If OO was truly strict about what input is used it would not voluntary convert cells formatted as text to zero for the sake of calculation. So (as mentioned above) OO should do one of three: 1. Use value of the cell when calculating formulas, deisregarding formatting (the bahavior of excel!); 2. Check spreadsheet when opened for numeric entries that are formatted as text and offer a choice between changing their formatting to number or leave as is; 3. Show error messahe in the formula calculation, so that user knows that the result of formula is not correct!!! The only incorrect beahvior is now, because user will most likely not notice the errorous calculation, particulary in big spreadsheets! --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
