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 Dec 11 21:23:12 +0000 2007 ------- The custom format for the competitive product that produces a useful engineering notation is: ###.000E+00 I would be happy with the results that are produced by that format: 1.000 -> 1.000E+00 0.100 -> 100.000E-03 0.010 -> 10.000E-03 0.001 -> 1.000E-03 10.00 -> 10.000E+00 100.0 -> 100.000E+00 1000. -> 1.000E+03 (etc.) Although I would prefer the mmmE+ee form where mmm is from 1 to 3 digits and ee is the power of ten as a number divisible by 3. I would call this "Engineering" in the category listing, just like 1E+06 is called "Scientific". An interesting Special format could interpret those into SI-named units, as in 100p, or 60K, etc. That would be even better if the actual engineering unit suffix could be included in the custom format definition, as in 800MHz, where the 800M is from the numerical value (8E+08), and the Hz is the added suffix. Given that I have wanted this since I first used spreadsheets I would give this the highest priority (i.e fixing the custom code that is shown to work in E**** and make it work in Scalc) and would rate the others as nice to have. --------------------------------------------------------------------- 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]
