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

Hi :)
I think "#VALUE!" appears when some duff value is trying to be shown, such as 
trying to divide by 0 or trying to add nonsensical values together such as word 
added to numbers and being shown in a cell formatted to show numbers.  It's 
likely there is a tpyo somewhere, either in the formula or in the values in the 
table.  

Regards from
Tom :)




----- Original Message ----
> From: PLO <protect.libreoffice@inboxshield.co.uk>
> To: users@libreoffice.org
> Sent: Sat, 4 June, 2011 11:28:15
> Subject: Re: [libreoffice-users] Calc: Has anyone tested the 
> backward-compatibility of LibreOffice 3.4?
>
> Hello prholland,
>
> On Sat, 4 Jun 2011 02:54:53 -0700 (PDT) (your time) you  said:
>
> > In OpenOffice.org and LibreOffice 3.3 if you used =SUM() to  find the total
> > of the numeric values in a row or column where some of  the cells were
> > blank or just text, then it worked! Now I've just opened  a spreadsheet
> > with LibreOffice 3.4 and #VALUE! is appearing  everywhere.
>
> That's odd. I don't get that. This works for me:
>
> A1 is  =SUM(A2:A7,B1:G1)
> A7 is =SUM(52/4)
> G1 is =SUM(365/52)
>
> E1 and A5 are  empty
> A6 and F1 are text
>
>
>    A       B        C       D       E        F       G
> 1  =SUM()  1        2       3                TEST    =SUM()
> 2  1
> 3  2
> 4  3
> 5
> 6   TEST
> 7  =SUM()
>
>
> -- 
> Si (PLO)
> #27176. Do Gee Owns Whir?  ¶
>
> Auxiliary Information:
>  • LibreOffice 3.4.0 OOO340m1 (Build:12)
>   • Windows XP Pro 5.1.2600 Service Pack 3
>
>
> -- 
> 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
>

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