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 19:27:56 +0000 2011 ------- I believe we can use Format, Styles and Formatting with Format, Conditional Formatting to obtain engineering notation in Calc. As an example for 5 significant digits, make three styles, Zero, One, and Two that use number formats 0.0000E+00, 00.000E+00, 000.00E+00, respectively. Apply style Zero to the cell, say B2. This is scientific notation. Using conditional formatting on the cell, set condition 1 formula MOD(INT(LOG10(B2));3)=1 to apply style One, and then set condition 2 formula MOD(INT(LOG10(B2));3)=2 to apply style Two. Note that the Excel "solution" provides variable precision. Using ##0.00E+00, numbers whose exponent is a multiple of three are displayed with three significant digits. But numbers with exponents of the form 3N+1 and 3N+2 are shown with four and five significant digits. I would think that most engineers and scientists would not think that using variable precision to display numbers is a real solution. The technique using styles and conditional formatting provides the same number of significant digits for all exponents. --------------------------------------------------------------------- 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]
