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