https://bugs.freedesktop.org/show_bug.cgi?id=61228
Priority: medium
Bug ID: 61228
Assignee: [email protected]
Summary: TABLE: Function summe() does not sum up but returns
last item
Severity: minor
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.3.2 release
Component: Writer
Product: LibreOffice
In the German versions of LibreOffice Writer (tested in 3.6.3.2/Windows and
3.6.4.3/Linux, both 64 bit) a function summe() exists which behaves quite
strange.
The function summe() is similar but not identical to the command sum.
=summe(<A1:A3>)
returns the sum of the cells A1 to A3, but
=<A1:A3>
does this, too. So the command sum in
=sum <A1:A3>
seems to be superfluous.
What looks weird to me is that summe() can be used only once in each formula,
so
=summe(<A1:A3>)+summe(<C1:C3>)
leads to an error ** Fehlerhafter Ausdruck ** (expression is faulty). On the
other hand the command sum (or its absence) works perfectly this way:
=sum<A1:A3>+sum<C1:C3>
=<A1:A3>+<C1:C3>
Things become completely strange when you try to use summe() to really sum up a
list of items. The formula
=summe(item1;item2;item3)
always returns item3 and not the sum of the three items. I tried it both with
cell references and numbers.
To use a comma as separator is a bit tricky, for the comma is used as a decimal
point in Germany. Additional spaces have to be used. The result is the same as
above.
=summe(3, 4, 5)
always returns "5".
When I entered
=sum 3;4;5
the behaviour was the same, too. The cell showed just "5".
Having sum already identified as being useless, I tried
= 3;4;5
and got only "5", too.
This is a totally unexpected behaviour.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
