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 21:11:05 +0000 2010 ------- Great to see some progress at last... 1) File storage of format specification: When considering how the format is encoded in spreadsheet files, please bear in mind that OOo also supports some excel formats. It would be great to see values an excel user formatted as 'engineering' shown as engineering. At present if OOo reads an excel97/200/xp file that has values that were formatted as "##0.0E+0" in excel, they are shown in 000.0E+0 format. 2) Excel 'engineering' format vs. true engineering format Excel's 'engineering' format has a variable number of significant digits - not a fixed number of significant digits as traditionally used as engineering format. Excel got it wrong. A little bit less than 1.00E+0 should be 990.E-3, not 990.00E-3 which pretends to be more accurate than it should. Offering true engineering format would be a real bonus for OOo although I expect many will say compatibility with excel is also important. For true engineering format we would need to specify the number of mantissa digits and accept that the decimal point will be inserted after the first, second or third digit according to the value being displayed. How to express that intention in a custom format would be an interesting question ( perhaps 0?00E+0 0?000E+0 0?0000E+0 ) I have no wish to see progress on this issue halted. I believe it is more important to provide any form of engineering notation than it is to fine-tune that format. If only one engineering format is possible, my vote would be for what I describe here as true engineering format. Keep up the good work! --------------------------------------------------------------------- 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]
