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 30 07:50:48 +0000 2010 ------- imeb - you clarify a great deal with your post. Thanks for the documentation links. To my understanding: -Scientific and Engineering numbers always start out with a non-zero digit, except for zero. Hence they are normalized as 1..999, with 0 leading only when dealing with the quantity is 0, and an exponent is not used -Excel only treats numbers as 'engineering' when the format contains exactly '#.' with a varying number of leading #'s. They don't seem to have a separate engineering format, per se. -Your storage description leaves out the grouping data element in the Oasis spec: {The <number:scientific-number> element has the following attributes: number:decimal-places 19.345.4, number:grouping 19.350, number:min-exponent-digits 19.353 and number:min-integer-digits 19.354.} which could be used in our favor without changing the storage format or specification. Grouping is a boolean flag which means thousands separators, which Excel does not use when displaying Engineering exponents, since by definition you will never have enough leading digits to require the separator. I.e. in Excel 123456789 becomes 123.456789E+06 with ###.000000E+00 formatting, 1234567890 would be 1.234568E+09. Also 1234.57E+05 with #####.00E+00 formatting. (In Excel ####0.00E+00 produces 1.23E+08, so we shouldn't use this interpretation since only 1 digit is produced before the decimal, the hash marks are optional and redundant when used with exponents) So I propose that any scientific formatted number with the the 'grouping' flag set be interpreted as 'Engineering' format when displayed. And that any scientific formatted cell set this flag when '#." occurs in the mantissa. This implies only a change in the cell format analyzer function and the formatting to a display string function. The number of min-integer-digits less the decimal-places would be the modulus increment for the exponent. --------------------------------------------------------------------- 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]
