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] Mon Jan 24 22:04:36 +0000 2011 ------- Like it or not excel is the standard. It allows engineering format in a particular way using the # formatting character. Gnumeric also behaves the same as excel. Surely the best thing to do is to finally make calc also behave (or have the option to) the same way by default as excel/gnumeric? So that by default a spreadsheet using the # formating character will display the same way in all three programs? Anything else must surely be a calc display only option, that does not affect the data written to the file? Hence the suggestion of calc display options. The points like "it is important that the engineering notation have a stable and specifiable number of signifiant figures" are reasonable and valid, but seriously miss the point of first dragging calc to the point of compatibility with excel/gnumeric. Implement these other ideas as a calc display option for cells formating using the # character if you wish, but leave the default option as that compatible with excel/gnumeric. Yes you can always apply conditional formating and/or macros to display what you want, but this is much more complicated that using the # formatting character in excel/gnumeric Introducing an entirely new formatting option does not seem sensible as this would not be compatible with other programs. Does anyone know what Lotus 1-2-3 used to do with cells formatted using the # character? --------------------------------------------------------------------- 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]
