Hi Eike,
Happy to hear from you.
So we can decide what to do on i71158.
And there are no other differences between the first and
the last version.
My sc has been updated. :)
About i86171, I find 7 functions using bTextAsZero.
They are MIN, MAX, AVERAGE, VAR, VARP, STDEV and STDEVP.
They all have the same result as MINA(range)=MIN(range),
and it's not right.
I made some change, and also have some question.
You may see my attachment of i86171.
and I wonder what nNumFmtType and nNumFmtIndex are
used for.
Wish you a nice weekend!
Best regard
Lvyue
2008-02-22
发件人： Eike Rathke
发送时间： 2008-02-22 02:25:33
收件人： [email protected]
抄送：
主题： Re: [sc-dev] GCD/LCM in other spreadsheet
Hi Lvyue,
On Wednesday, 2008-02-20 14:19:13 +0800, Lvyue wrote:
> In Excel:
> Negative will cause error, no matter how small it is.
> I have tried -1.00E-307, GCD still return err.
>
> And in Gnumeric:
> The handle of negative is the same to Excel.
>
> Shall we be consistent with them, or keep our direction?
Let's be consistent and check for <0 before doing the approxFloor()
call. So this would basically be the first version of your patch. Are
there other differences between that and the last version you attached?
> BTW, I'm updating sc to the -rcws_src680_odff tagged
> revisions. but it runs slow. I think it will be finished tomorrow.
Did it run well?
> and I will see the issue86171. If I get any progress or
> meet troubles, I will tell you as quickly as possible. :)
Hopefully silence means good news in this case ;-)
Eike
--
OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer.
SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
Please don't send personal mail to the [EMAIL PROTECTED] account, which I use
for
mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED]
Thanks.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.7 (GNU/Linux)
iD8DBQFHvb54Zcn5tYf41BIRAs4HAKCJFkJSX8vMT8Sa8fh0zkr+XA0EbACfbf4T
5nw/00qVXNrykdPdN4+ba0Y=
=5aiU
-----END PGP SIGNATURE-----
