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 ir...@openoffice.org Mon Sep 14 14:24:25 +0000 2009 ------- OK, I've just attached a spreadsheet with a sBasic macro for converting a number to Eng notation or Si notation. Unfortunately both cases are text, so direct calculations would not work. The Eng notation can easily be reverted back to normal Scientific notation through the VALUE formula. But, the Si notation would require a further macro to convert back ... should not be too difficult ... hopefully ... will come back when I've got some time to fix that up. Please note, this is a rough testing program. There's possibly quite a few errors, and I haven't even looked at enabling enforcement of a minimum number of digits pre- / post the decimal point. --------------------------------------------------------------------- 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