« Ranking and sorting data I | Main | I'm Back! »
May 17, 2005
My first OOo Calc addin : XNumbers
Any computer having hardware at 32-bit can perform arithmetic operations with 15 significant digits, at the most. The only way to overcome this finite fixed precision is to adopt special software that extends the accuracy of the native arithmeticThis preliminary version of Xnumbers for OOo Calc contains over 30 functions to assist In the processing of extended precision numbers.
Here is an example of one of the functions - xmult
Here, we calculate the sin, cos, and tan of an angle to 150 places...
Ultimately, Xnumbers for Calc will have 300+ functions. The existing functionality is a Solid foundation upon which the remaining functions can be developed.
The original XNumbers add-in was developed for Excel by Leonardo Volpi and the Foxes team.
Version 0.1 of XNumbers can be downloaded here
Posted by Dave at May 17, 2005 10:47 PM
Comments
I dont get it? When I open the document parts of the formula are #NAME?. When I look at the macro it doesnt run and there is a password box. What do I do now? Kim
Posted by: kim at June 18, 2005 06:02 PM
Howdy! Where'd the posting go? I actually read these things! ... --Avid Openoffice User :)
Posted by: OpenOffice User at July 22, 2005 06:35 PM
How do you install your macro? Just opening the XNumbers_01.sxc in Calc does not work. It loads and displays the Calc sheet, but has no additional functionality.
Posted by: Joe Conner at August 25, 2005 09:44 AM