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 20:34:39 +0000 2011 ------- Correction to previous post. My apologies: 1) Those who would want the current excel/gnumeric engineering format (using # characters) to display numbers in the range 0 to 999.999 as non exponent numbers. So that the end result would be a set of numbers displayed like: 100e3, 10e3, 1e3, 999, 100, 10, 1, 0, 999.999e-3, 100e-3, 10e-3, 1e-3, 100e-6, 10e-6, 1e-6 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, 999.999m, 100m, 10m, 1m, 100u, 10u, 1u 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 Alt display [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] I personally would be happy just if the "excel/gnumeric" option was the only one implemented. Other options could be added if required. For instance making the range of numbers in "1)" that are displayed without an exponent a user definable range. --------------------------------------------------------------------- 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]
