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 paulwolstenho...@openoffice.org Tue Dec 14 21:09:51 +0000 2010 ------- I disagree with irneb who said: "E.g. 0,000.00E+00 would get translated to ####.00E+00." Excel actually interprets ####.00E+00 as meaning that exponents must be a multiple of 4. Excel custom codes do not seem to support 1000's grouping in scientific format without also forcing the exponent to be a multiple of 4 or more, such as excel custom codes 0,000.00E+00 or #,###.00E+00. My tests on excel 2002 indicate that excel counts the total number of integer digits in the custom code (the number of '#' or '0' characters before the '.') and makes the exponent a multiple of that number. I believe there is no existing excel custom code that can simultaneously specify scientific format, 1000's grouping and 'Minimum number of integer digits' = 1, 2 or 3. This combination of attributes is actually not required because there is no value that would ever use 1000's grouping. We can safely use this combination of attributes to represent engineering format. I'm not sure why we would want engineering format with leading 0's but the codes do support it - and so does excel. So I'm suggesting we interpret a combination of ODF file attributes of: * 1000's grouping, * scientific format, and * 'Minimum number of integer digits' <= 3 as denoting engineering notation. --------------------------------------------------------------------- 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