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=Value-Fix(Value) ' Using ”Int” instead of ”Fix” doesn't work
properly for negative values.
End Function
For example, Frac(-12.3456789) ⇨ -0.3456789
I use Frac() all the time and I can't be the only one who need it, can I? Among
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
ジョニー・ローゼンバーグ
--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help
