LibreOfficeCac...

classic Classic list List threaded Threaded
2 messages Options
zed zed
Reply | Threaded
Open this post in threaded view
|

LibreOfficeCac...

Using libreoffice vLibreOffice 3.3.0 OOO330m19 (Build:5) tag
libreoffice-3.3.0.3, on LinuxMint Debian Edition.

Created two columns of figures

(a) Col B consists of 34 rows of figures. Rows B9,
B16, B20, B29, B34 are total categories, shown as figures not formula.

(b) Col C has figures in rows C8, C13, C14, C15, C19, C23.

(c) adding the figures in the rows given in (a) above, i.e. =B9+
B16+B20+B29+B34  returns the error #VALUE!.  I tried enclosing in brackets
with the same result.

(d) In Col C.  Highlighting rows C5:C34) and then hitting SUM only returns
the value of C23. Adding C8+C13+C14+C15+C19+C23 returns the error message
#VALUE.

Has anyone else come across this, please?  It appears to be a bug.

Incidentally, I do not have the same problem if I use OpenOffice Calc.  All
works as expected.

Zed
--
Zed
A sense of humor is just common sense, dancing.  --William James  

--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|

Re: LibreOfficeCac...

Am 01.02.2011 08:47, Zed wrote:

> Using libreoffice vLibreOffice 3.3.0 OOO330m19 (Build:5) tag
> libreoffice-3.3.0.3, on LinuxMint Debian Edition.
>
> Created two columns of figures
>
> (a) Col B consists of 34 rows of figures. Rows B9,
> B16, B20, B29, B34 are total categories, shown as figures not formula.
>
> (b) Col C has figures in rows C8, C13, C14, C15, C19, C23.
>
> (c) adding the figures in the rows given in (a) above, i.e. =B9+
> B16+B20+B29+B34  returns the error #VALUE!.  I tried enclosing in brackets
> with the same result.
>
> (d) In Col C.  Highlighting rows C5:C34) and then hitting SUM only returns
> the value of C23. Adding C8+C13+C14+C15+C19+C23 returns the error message
> #VALUE.
>
> Has anyone else come across this, please?  It appears to be a bug.
>
> Incidentally, I do not have the same problem if I use OpenOffice Calc.  All
> works as expected.
>
> Zed

I bet your are trying to sum up text values. Hit Ctrl+F8 which
highlights numbers in blue font.


--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***