Hi Yue, On Wednesday, 2008-03-19 12:38:05 +0800, Lvyue wrote:
> For i86643, I restrict the precondition to errNoName, > because I found if there is an illegal param in the list and not the last one, > and also empty cell or range in the list. > the result will be 1 more than the right number. > For example, COUNTA( AAAA; F5 )=2 and F5 is an empty cell. > and COUNTA( AAAA; 5 )=2, COUNTA( AAAA; F5; 3 )=3, > COUNTA( F5; AAAA )=1, COUNTA( 5; AAAA )=2. That's not only for undefined names. Any error should be treated like that, e.g. with F5 being empty COUNT(1/0;F5) should give 0, COUNTA(1/0;F5) should give 1. So nGlobalError should be always reset. 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.
pgp4DTtu5NC0Y.pgp
Description: PGP signature
