Missing a Frac() function

Johnny Rosenberg <[email protected]> Sun, 7 Aug 2011 16:55:50 +0200
Newsgroups gmane.comp.openoffice.devel.api
Message-ID <CADo7T4cg3LUVdMyEZUPN3UrdQuDn23j6J4y0k656zw3V8kcGTA@mail.gmail.com>
Am I the only one who miss a Frac() function in OpenOffice.org Basic
and as a cell function?

I always have to use my own function, which is probably slower than a
built in function would be:

Function Frac(Value As Double) As Double
    Frac=3DValue-Fix(Value) ' Using =E2=80=9DInt=E2=80=9D instead of =E2=80=
=9DFix=E2=80=9D doesn't work
properly for negative values.
End Function

For example, Frac(-12.3456789) =E2=87=A8 -0.3456789

I use Frac() all the time and I can't be the only one who need it, can I? A=
mong
other things it's nice for separating time from time+date, even if there are
other ways to do that.

In case there is a Frac() function after all, what's it called?

Kind regards

Johnny Rosenberg
=E3=82=B8=E3=83=A7=E3=83=8B=E3=83=BC=E3=83=BB=E3=83=AD=E3=83=BC=E3=82=BC=E3=
=83=B3=E3=83=90=E3=83=BC=E3=82=B0
--=20
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help