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 [email protected]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
