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] Fri Nov 17 03:55:03 -0800
2006 -------
Further to my suggestion that Engineering format be supported in the OO spread
sheet, I found this
formatting code on the web - consider incorporating it in some form....
def number_to_engineering(value, precision=3)
expof10 = ((Math.log10(value)/3.0).floor)*3
value *= 10**(-expof10)
case
when value>=1000.0 :
value /= 1000.0
expof10 +=3
when value>=100.0 : precision -= 2
when value>=10.0 : precision -= 1
end
"%.*fe%d" % [precision-1, value, expof10]
end
number_to_engineering(15000) => "15e3"
to ruby formatting number by Kevin on Tue Aug 23 07:40:20 GMT 2005
http://www.bigbold.com/snippets/user/Kevin
----------
The idea of SI support is one I did not consider, but boy that would be good
too.
So the selection entry sould be 'SI'. Simple, great.
---------------------------------------------------------------------
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]
