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

On 4 Jun 2011 at 6:26, prholland wrote:

Date sent:              Sat, 4 Jun 2011 06:26:56 -0700 (PDT)
From:                   prholland <ooo@hollandnumerics.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

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