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 ir...@openoffice.org Wed Dec 15 15:18:33 +0000 2010 ------- Actually you're absolutely correct. That special case is more like an unintended possibility. So we might use the grouping even for the SI idea: i.e. a format code of ,0.00E+00 (although a lot "strange") could mean use SI with 2 decimals. So the xml settings would become: integers=1, decimals=2, exponents=1, grouping=yes. This can clearly be differentiated from the proposed Eng format trick of using ,000.00E+00 : integers=3, decimals=2, exponents=2, grouping=yes. Since the number of integers govern the exponent multiples ... which is what exactly when it's one one? And we can even accommodate other exponent multiples, e.g. ,00.00E+00 would show 1234 as 12.34E+02. The settings would be: integers=2, decimals=2, exponents=2, grouping=yes. And it "shouldn't" cause problems with normal scientific format, since we can still have that working as is. In any case when using the above format strings with the comma (denoting 1000 grouping) the comma is interpreted as a string to add to the number. I.e. as is a format of ,000.00E+00 on a number of 1234 currently displays as ,123.40E+01 ... which is clearly impossible for the user to have wanted. Where there may be an issue is if (as stated) some extremely strange guy wants to format like this: 0,000.00E+00 where 123456 would become 1,234.56E+02. If we do go with this wangling idea, the only possible format option this fictitious guy would have is 0000.00E+00, giving him 1234.56E+02. Because as soon as he includes a comma (anywhere) into the format string he'll get: 12.35E+04 And yes it would also be a good idea to manually edit the style.xml file inside an ODS (to match these proposed fixes) and see what happens when opening it in current and older Calcs. You never know if for some reason there's a hiccup. --------------------------------------------------------------------- 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