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 Nov 16 09:10:41 +0000 2010 ------- I compared behavior of OO vs Excel cell scientific formats: ###.00e+000 constrains Excel cell to have exponent as multiples of 3, with 1, 2, or 3 digits before decimal. Same format specification causes OO to fix 3 digits before the decimal, with varying exponent. Hypothesis: coding change required is to change from fixing the number of pre-decimal digits to making the exponent a multiple of the number of #'s before the '.' This implies that no new formatting type is needed, only recognition of '#*.' pattern. IE Excel sees ##.00e+00 as fixing exponent to multiples of two. ####.00e+00 fixes exponent to multiples of 4 - i.e. the number of hash marks immediately preceding decimal point in specification. --------------------------------------------------------------------- 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]
