[libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4?

Michael D. Setzer II wrote:
> If you use count on a range it only counts numeric cells, but 
> counta counts numeric and non-empty cells, so if they don't give 
> the same results for the same range, there is an error?

Yes, that would work but it forces me to do this verification for each
column. And still it won't tell me where the error is (although I can find
it with some filters)

It would be much better if there was some AI in these functions warning me
that "Data in Cell A12345 is not a number.  What do you want to do? A) Jump
to cell A12345 and manually fix it or B) Ignore this warning and Sum all
other cells?"

Why not use the computing power of the PC to help us?

--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023698.html
Sent from the Users mailing list archive at Nabble.com.

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted