Sometimes I have found that the "#VALUE!" is because the number doesn't fit in the width of the cell. Making the width of the column has resolved the problem. *I doubt if the movie Black Swan was making fun of me in my Linux mascot guise!*
On 4 June 2011 13:38, Tom Davies <tomdavie...@yahoo.co.uk> wrote: > 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.libreoff...@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+h...@libreoffice.org > > In case of problems unsubscribing, write to > postmas...@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+h...@libreoffice.org > In case of problems unsubscribing, write to > postmas...@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+h...@libreoffice.org In case of problems unsubscribing, write to postmas...@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
