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

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 <tomdavies04@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.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

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