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 mrprogram...@openoffice.org Wed Jan 26 21:00:41 +0000 2011 ------- The attachments today from irneb and efa were close what I had in mind, but I should have made my own attachment with an example. I will show two ways to produce engineering notation, one using conditional formatting as described previously, and one using the STYLE() function. Note that it is not necessary to take the absolute value of MOD(INT(LOG10(Bn));3) because MOD(…;3) is by definition always non-negative. Using the STYLE() function allows the three conditional formats to be used for other purposes at the expense of complicating the target cell's formula to add "+STYLE(…)". --------------------------------------------------------------------- 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