« Introducing XNumbers for Calc | Main
June 22, 2005
XNumbers 0.11 now available
In version 0.11, the following functions are implemented – 50 in total ...Version 0.11 of XNumbers for OOo 2.0 beta can be downloaded here
Arithmetic Functions (19)
- Addition Xadd()
- Subtraction Xsub()
- Multiplication Xmult()
- Division Xdiv()
- Inverse Xinv()
- Integer Division Xdivint()
- Integer Remainder Xdivrem()
- Sum Xsum()
- Product Xprod()
- Raise to Power Xpow()
- Square Root Xsqr()
- Nth Root Xroot()
- Absolute Xabs()
- Change Sign Xneg()
- Integer Part Xint()
- Decimal Part Xdec()
- Truncation Xtrunc()
- Rounding Xround()
- Relative Rounding Xroundr()
Extended Numbers Manipulation (6)
- Significant Digits Count Xdgts()
- Compare Numbers Xcomp()
- Extended Number Check IsXNumber()
- Strip Separator chars Xunformat()
- Extract Mantissa Xsplitm()
- Extract Exponent Xsplite()
Statistical Functions (9)
- Factorial Xfact()
- Factorial with Double-step Xfact2()
- Combinations Xcomb()
- Permutations Xperm()
- Arithmetic Mean Xmean()
- Geometric Mean Xgmean()
- Quadratic Mean Xqmean()
- Standard Deviation Xstdev()
- Variance Xvar()
Trigonometric Functions (7)
- Sin Xsin()
- Cos Xcos()
- Tan Xtan()
- Arcsine Xasin()
- Arccos Xacos()
- Arctan Xatan()
- Complement of right angle Xanglecompl()
Complex Arithmetic (9)
- Complex Addition Xcplxadd()
- Complex Subtraction Xcplxsub()
- Complex Multiplication Xcplxmult()
- Complex Division Xcplxdiv()
- Polar Conversion Xcplxpolar(0
- Rectangular Conversion Xcplxrect()
- Complex Absolute Xcplxabs()
- Complex Power Xcplxpow()
- Complex Roots Xcplxroot()
Version 0.11 of XNumbers for OOo 2.0 beta can be downloaded here
Installation of XNumbers 0.11
First, open the OpenOffice.org Basic Macros dialog as shown below.
There are five modules to be installed. Click on organizer
We will move each module in trun from the Standard library in the install document to the Standard library under My Macros using drag and drop technique.
Once the modules are transferred, the install document can be closed and the XNumbers functions will be available every time OOo Calc is invoked.
Posted by Dave at June 22, 2005 07:23 AM
Comments
My workmate was saying how he spent ages trying to write an extended precision program in C. Then he discovered it was already done in Java. Well, now it's in OOoCalc! Super dooper! Now I won't need to remember PI to the 40,000 decimal place any more.
Posted by: anvilsoup at August 10, 2005 12:47 PM