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 Tue Nov 30 23:18:42 +0000 2010 ------- Paul 1) Your post got me to double check the behavior of Excel (Mac 2008): ###.00e+00 or ##0.00E+00 or #00.00E+00 all give a multiple of 3 exponent. But with varying leading zeros in the formatting. A leading 0 is put into the display number if needed: i.e. #00.00E+00 gives 01.23E+04 - Ughh. Very mechanical. But the main point is that any leading # gives rise to exponents as fixed multiples of some base number (again by 2, 3, 4, etc). My second point is that fixing the corner conditions of the display specification is fraught with interpretation issues. At some point in the counting there will be a nonlinearity in display step, and we need to accept it. 2) I learned engineering notation as going from 1..1999 before rolling back to 3 significant digits as 2.00e3 (think voltmeter displays) because the small increment going from 999 to 1000 swamps the mechanical shift to 1.00E3, as you say. 3) What everyone most wants is to be able to pin the exponent to multiples of 3 (and potentially other numbers) for faster visual comprehension and comparison, and we are discussing how best to do it. A full blown exponential format would be nice, but may be unnecessary if we can accept as described earlier to use the difference in mantissa integer digits and total mantissa digits along with the 'group' flag to interpret that as the exponent's multiple. I would wait until we are adding support for SI units which will need a new storage format, to then also support a more explicit engineering display format with an added flag for number/unit selection. -------- An open question: I've been looking through the source code, especially in the zforscan.hxx .cxx and zformat.cxx files trying to interpret them. I'm limited because I don't have a build environment to recompile OO, and am only guessing where the call to create the output string or the call to analyze the format string start. --------------------------------------------------------------------- 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