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 Fri Dec 3 12:40:48
+0000 2010 -------
Irnéb
I think we stop at this point and say that forcing leading zeros becomes a
textual formatting issue. If
you are using engineering format, you want the display to be a multiple of 3
(or something else), and
that has to override the existing formatting.
Suggested decision tree:
1) Scientific format Yes/No
2) Engineering exponent: Yes - what multiple / No - stay with scientific
exponent
3) leading digits: Yes/No
- how many digits - maximum?
- how many digits - must show?
(this could be 5 digits max, with 3 that must be shown)
4) decimal digits
-how many max
- how many minimum
-show trailing zeros?
A lot of these details are buried in the formatting string syntax. If we make
each of these items explicit
on the formatting screen, then the user gets a clearer picture of what they are
configuring.
On Dec 2, 2010, at 11:48 PM, Irné Barnard wrote:
BTW, Excel even does the following:
000.00E+00 ... where I'd want at least 3 digits (zero padded) but still have
true engineering notation.
I.e. 1000 shows as 001.00E+03.
But how to get rid if that if what you actually want is for it to show
100.00E+01, as OOo.Calc would do
at present?
--
Irné B
---------------------------------------------------------------------
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
