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 users+help@libreoffice.org
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.