To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=48096 Issue #:|48096 Summary:|2.3453 + 3 = 3? should produce an ERROR Component:|Spreadsheet Version:|OOo 2.0 Beta Platform:|PC URL:|http://www.hydrology.uni-kiel.de/~schorsch/error.ods OS/Version:|Windows XP Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|FEATURE Priority:|P3 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|hlschorsch
------- Additional comments from [EMAIL PROTECTED] Sun Apr 24 23:18:07 -0700 2005 ------- I have an extremely annoying non-error error: (please see file for an example) short description: I type a long number in cell A1 which is not recognized as a number by oo (e.g. 2.345345345349 in the German Version, maybe you have to use "," in the englsh version). If I create a formula "a1+3" the result is 3. This should raise an error-condition (#VALUE, like in Excel), because such conditions occur frequently if I import files with an english decimal point into the German version. Because OO IGNORES custom decimal points this is a really bad situation and causes dead wrong results. Adding numbers to text should never give a valid result! This behaviour makes OO-Calc unusable for real world applications: I often have to import files from data loggers - with OO I can never be shure that the result is computed correctly and I can not control 5000 lines manually. Gruss Georg --------------------------------------------------------------------- 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]
