https://bugs.documentfoundation.org/show_bug.cgi?id=105227
Bug ID: 105227
Summary: Sumproduct function in LO 5 breaks compatibility from
LO 4
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 130294
--> https://bugs.documentfoundation.org/attachment.cgi?id=130294&action=edit
Example of sumproduct formula producing error on text cell
In LibreOffice 4, when a cell used in sumproduct contained text, it was ignored
and the sum was done with the values of other cells. The same file in
LibreOffice5 produces an error.
See attached file :
cell A1 contains 5
cell B1 contains 8
Cell A2 contains 4
cell B2 contains 2
cell A4 contains formula =SOMMEPROD(A1:B1*A2:B2) (using French local)
This returns value 36 as expected.
If I replace B2 by somme text, for example "-" then cell A4 returns value 20 in
LibreOffice 4 (ignoring completely cells B1 and B2) and #VALEUR ! in
LibreOffice 5.
Of course there is logic in both behaviours and I can even understand why some
might find LO 5 's handling of the situation to be better.
But alas this change renders lots of files (in my case anyway) and make them
totally useless. IMO formulas should not be version dependant. Compatibility
matters !
Thanks any way for the excellent work and a great office suit.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
