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

On 4 Jun 2011 at 6:06, plino wrote:

Date sent:              Sat, 4 Jun 2011 06:06:55 -0700 (PDT)
From:                   plino <pedlino@gmail.com>
To:                     users@libreoffice.org
Subject:                [libreoffice-users] Re: Calc: Has anyone tested 
the backward-compatibility of
        LibreOffice 3.4?
Send reply to:          users@libreoffice.org

> Actually I had never noticed that spreadsheets (all including Excel) ignore
> text values mixed with numbers. This worries me a lot!
>
> I work with 300.000+ line spreadsheets and if one line has a text value
> (because of a typo) I wouldn't notice that.

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?



> Is there any setting that triggers a warning (instead of ignoring the
> cell(s)) in this situation?
>
> --
> View this message in context: 
> http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023116.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


+----------------------------------------------------------+
  Michael D. Setzer II -  Computer Science Instructor      
  Guam Community College  Computer Center                  
  mailto:mikes@kuentos.guam.net                            
  mailto:msetzerii@gmail.com
  http://www.guam.net/home/mikes
  Guam - Where America's Day Begins                        
  G4L Disk Imaging Project maintainer 
  http://sourceforge.net/projects/g4l/
+----------------------------------------------------------+

http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned:  19,471
Processing time:  32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)

BOINC@HOME CREDITS
SETI        10835199.920471   |   EINSTEIN     5971444.300851
ROSETTA      3209136.449584   |   ABC          6134395.303758


-- 
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