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 05:58:48 +0000 2010 ------- This is how a format of ###.00E+00 is saved inside the styles.xml inside the ODS file: <number:number-style style:name="N107"> <number:scientific-number number:decimal-places="2" number:min-integer-digits="3" number:min-exponent-digits="2"/> </number:number-style> And here's the spec: http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05-part1.html#a_16_27_5__number_scientific-number_ It never saves the custom format string. It always translates it into values for its properties. And seeing as the design of the properties don't allow for exponent factors .... :( As you can see the ### before the decimal "translates" incorrectly as: number:min-integer-digits. Now I can understand 000 being minimum digits, but not ###. Strictly speaking ### could format anything from a blank, through 0 to 999. 000 can only format from 000 to 999 ... noting else is possible. To have a "true" engineering format the custom format string should actually be ##0.00E+0, since you want at least one integer digit but a maximum of 3. The SI format spec shouldn't be "difficult" to define. The "difficult" portion is to get it into the spec, through the bureaucracy of the ODF council, and finally into the programs which use it. The same actually applies to the proposed change in the scientific format to accommodate engineering. This is usually why other programs start branching into proprietary formats. They want to introduce a new feature, but can't since the format (which they have little control over) doesn't allow for it. --------------------------------------------------------------------- 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]
