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 nick...@openoffice.org Thu Dec 2 00:20:20 +0000 2010 ------- Another way to do the formatting selection is to add an 'Engineering Exponent' check box to the Scientific Format screen. An example could be given at that point with a selectable increment number for the exponent corresponding to a maximum number of integer digits before the decimal point in the mantissa. Operationally this would adjust the number of #'s before the decimal without the user having to adjust things. The Excel "Custom:Type" or OO "Category: Format" windows show sample number formats according to the user's selection. Toggling the 'Engineering Exponent' check box would bring up the engineering templates: #.00E+01 ##.00E+02 ###.00E+03 ####.00E+04 This is a painless extension to the existing format example table. The 'leading zeros' could be replaced with 'exponent multiple' ranging from 1..something useful. Also, we don't need a new 'F' suffix, it is non-standard. For generic "Scientific Format", all numbers look similar from the user's perspective. The format specification string level is where they differ, but the user just sees a number with hidden normalization and truncation rules. Show the 'E' numbers with the desired exponent presentation. Everybody knows how to interpret 32.12E+03. Most would be confused by 32.12F+03. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org