Hi Eike, I have checked MIN, MAX, AVERAGE, VAR, VARP, STDEV and STDEVP, these functions behave correctly now.
and I have submitted another patch according to your comment. just simplified the condition. please check this one. I hope it won't take you many time. I have seen the website you gave me. FOSDEM looks like a big party for Free and Open Source developers. and I noticed there is a Free Beer Party! I guess your weekend would be quite nice. :) did you take any photo? There's no photo of FOSDEM2008 on the web yet. Lvyue 2008-02-25 发件人： Eike Rathke 发送时间： 2008-02-22 20:39:16 收件人： [email protected] 抄送： 主题： [sc-dev] Functions with bTextAsZero (was: [sc-dev] GCD/LCM in otherspreadsheet) Hi Lvyue, On Friday, 2008-02-22 15:37:42 +0800, Lvyue wrote: > 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. As expected.. > I made some change, and also have some question. > You may see my attachment of i86171. See my comment I just added there. > and I wonder what nNumFmtType and nNumFmtIndex are > used for. These can be used later in a call to ScValueIterator::GetCurNumFmtInfo(), in the bTextAsZero case of pure text cells they are predetermined and don't have to be obtained through calls to GetNumberFormat() and the like. For formula cells situation is a bit more complicated and should be left as is for now. > Wish you a nice weekend! Thanks, nice weekend to you too! I'm going to FOSDEM now, http://fosdem.org/2008/ 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) iD8DBQFHvr7QZcn5tYf41BIRAnE5AKC1fBfYJ7oS7zadH6Dux9XB6iI3PACfXUjy 5Jspa4WAj5AB8RBNDYl7SXo= =yCxX -----END PGP SIGNATURE-----
