To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=87468 Issue #|87468 Summary|Scientific notation for negative numbers broken in sol |ver. Cell value =1E-6 Component|Spreadsheet Version|DEV300m4 Platform|All URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|rolmol
------- Additional comments from [EMAIL PROTECTED] Wed Mar 26 13:47:52 +0000 2008 ------- When typing "1E-2" (minus quotation marks) in a cell it works as expected, however using the same code in an expression or equation is broken: "=1E-2" results in the error message: OOo-dev Calc found an error in the formula entered. Do you want to accept the correction proposed below? =E1-2 [Yes] yields the proposed correction, [No] results in #NAME? Reproducible: Always (regardless of which *negative* number entered) Steps to reproduce: Empty cell, type "=1E-2" without quotation marks Expected result: "1E-2" to be interpreted as 0,01. --------------------------------------------------------------------- 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]