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