Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.