To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=5930
------- Additional comments from [EMAIL PROTECTED] Tue Sep 12 03:20:51 -0700 2006 ------- This issue is now sitting unresolved since FOUR years! Is anybody ever going to work on it? Please keep in mind that for non-programmers the display of a number like 1E-7 is extremely unfamiliar. Displaying it like this makes spreadsheets unreadable to the general public. OK, after this small rant I have a few suggestions: 1) Display floating point numbers in correct scientific format: That is 1E-7 should be displayed as 1*10^-7 (of course without hat and with the exponent "-7" put as superscript and the asterisk being actually displayed as center dot). Like in every text book. We could reserve the lower case "e" format code for this: "0,00e+0" 2) For the scientific format there should be an alternative to display with exponents as multiple of 3 and (optionally) with the exponent being shown as SI unit prefix "E-3" shown as "m" for milli, "E-9" shown as "n" for nano, etc. Combining this with a text format code would naturally result in a correct display of physical units. Example: With a format code of "0,0S \m" the number 1E-8 would be displayed as "10.0 nm". Here I invented the format code "S" for this purpose. --------------------------------------------------------------------- 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]