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 <[email protected]> > To: [email protected] > 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 [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 > > -- 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
