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 l...@openoffice.org Wed Dec 1 12:04:10 +0000 2010 ------- Hi, If we are talking about a robust, new solution, I suggest two things: 1) For nick_ee second thought (engineering notation as going from 1..1999 before rolling back to 3 significant digits) I suggest to have a way to fix the exponent for a specific value. Imagine a table containing current values in milliampers. It could be good, if all the values in the table has az "E-03" exponent (or "mA", but I don't want to talk about the SI notation now), even if there are some values less than 1mA or some values are not less than 1000 (or 2000) mA. It makes the numbers more comparable for the human eyes. 2) Maybe there is a better solution instead of "format string". Why we need to think about and learn a complicated, "coded" way to express the number of digits, thousands separator, and colored negatives, etc? Maybe it was a good and compact solution 20 years ago. Maybe a better UI can exist for setting the parameters of the number (representing the sign, the left and right part of the decimal separator and the exponent). Most likely this UI is not yet invented, and our job it to do it. I'd like to query why it is thought an expression like [>=10000000]"RS "##\,##\,##\,##0;[>=100000]"RS " ##\,##\,##0;"RS "##,##0 is more user friendly than an UI containing some radio buttons and some fields defining the number of digits. And we can use more than one but only very basic format string instead of a big, complicated one. Maybe I've went too far, and I'm wrong but I feel there are too many functions stuffed into the format string, and it become too complicated (for an average user). And we are talking about to put a new function into it, make it more complicated. --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org