On 4 Jun 2011 at 6:06, plino wrote: Date sent: Sat, 4 Jun 2011 06:06:55 -0700 (PDT) From: plino <[email protected]> To: [email protected] Subject: [libreoffice-users] Re: Calc: Has anyone tested the backward-compatibility of LibreOffice 3.4? Send reply to: [email protected]
> 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 [email protected] > In case of problems unsubscribing, write to [email protected] > 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:[email protected] mailto:[email protected] 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 [email protected] In case of problems unsubscribing, write to [email protected] 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
