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] Sun Jan 23 15:04:14 +0000 2011 ------- This has been an open issue since 2002. May I be bold (foolish?) enough to make a suggestion as to a resolution? It would seem sensible for any change to keep/add compatibility with other spreadsheet programs, such as excel and gnumneric in the areas of: * Saving and reading the data from a file * Having the option to display the data as it appears in other programs The simplest way to achieve this point would seem to be the option to have calc treat the # formatting character the same as in excel and gnumeric. This would not address the issues/concerns expressed of: 1) Those who would want the current excel/gnumeric engineering format (using # characters) to display numbers in the range 0.999 to 999.999 as non exponent numbers. So that the end result would be a set of numbers like: 100e3, 10e3, 1e3, 999, 100, 10, 1, 0, 0.1, 0.01 0.001, 0.999, 1e-3, 10e-3 etc 2) Those who would like the exponents displayed as SI prefixes, so the end result would be a set of numbers like: 100k, 10k, 1k, 999, 100, 10, 1, 0, 0.1, 0.01 0.001, 0.999, 1m, 10m etc 3) Backwards compatibility with how the # formating character currently works in calc This could to be achieved by having an option inside of calc that affected how a cell formatted using # formating characters was displayed: "Engineering format display" * Standard (default) [excel/gnumeric] * Engineering numeric [as 1) above, exponents as numeric numbers] * Engineering SI display [as 2) above, exponents as SI prefixes] * Pre calc 3.x display [as 3) above, backwards compatibility] Other options could be added if required. I am envisaging that the implementation for the change of display formatting could be based on the way code currently works when a cell is formatted as a percentage, in which the displayed number changes and a % character is added into the cell display, but for all other calculation purposes it is as if nothing has changed. Would this proposal address 95% percent of peoples' concerns expressed in this issue? --------------------------------------------------------------------- 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]
