On 4 Jun 2011 at 6:26, prholland wrote: Date sent: Sat, 4 Jun 2011 06:26:56 -0700 (PDT) From: prholland <[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]
> The following screenshot is taken from a spreadsheet that previously showed > "00:00" in LibreOffice 3.3.2, where LibreOffice 3.4.0 is now showing > "#VALUE!" (NB: all the cells are formatted as Time values, and the "text" > cells contain "-"): > > http://nabble.documentfoundation.org/file/n3023141/%23VALUE-screenshot.png > In a quick test, this give the results you want? =IF(AND(ISNUMBER(B7),ISNUMBER(C7)),C7-B7,0) > > -- > View this message in context: > http://nabble.documentfoundation.org/Calc-Has-anyone-tested-the-backward-compatibility-of-LibreOffice-3-4-tp3022764p3023141.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
