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 mrprogram...@openoffice.org Tue Jan 25 17:14:48 +0000 2011 ------- Note that my suggestion yesterday *does* ensure that the exponent is a multiple of three. π is shown as 3.1416E+00, 10π as 31.416E+00, 100π as 314.16E+00, 1000π as 3.1416E+03, 10000π as 31.416E+03, π/10 as 314.16E-03, π/100 as 31.416E-03, etc. I will admit that I don't see a good way to handle the case where the user wants engineering notation but with only significant digit. (There are only two places to put the decimal point — either 0.E+00 or .0E+00 — without adding additional digit placeholders.) But presumably that case would be rare and Excel's "solution" doesn't handle it either. I agree that my suggestion is more complicated than Excel's kludge, but believe it is more correct. I would welcome direct support for engineering notation, hopefully with fixed precision, in a future release but wanted to offer this idea as a current workaround. And if we also have a way to support formats like ###.0E+00, even if they produce variable precision, even better. But I'd hope our goal would be to do it right, rather than simply be compatible. --------------------------------------------------------------------- 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