https://bugs.documentfoundation.org/show_bug.cgi?id=168422
Bug ID: 168422
Summary: SUMPRODUCT() refuses to work under unclear conditions.
Shows unexpected #VALUE! error.
Product: LibreOffice
Version: 25.8.1.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 202845
--> https://bugs.documentfoundation.org/attachment.cgi?id=202845&action=edit
The announced erxample
V 25.8.1.1. , Win 10
Strange thing. I have only one example which I will attach.
If the bug is reproducible by others it should be "crucial", "regression".
The attached example was made in pursuit of the user question
https://ask.libreoffice.org/t/automatically-expanding-sumproduct-range-according-to-date/126695
I had suggested an alternative solution without SUMPRODUCT(), but tried to
demonstrate the equivalence with a solution based on SUMPRODUCT().
It didn't work. Onöy erratically the entered formula worked sometimes for one
cell, but failed when filled down (#VALUE!).
I now saved the document with V 25.8.1. (release) and opened it with V 7.5.4.2
(from a PortableApps install, 32 bit).
It worked flawlessly as expected, and filling did not cause errors.
Some QA agent should test if this is reproducible.
(It is on my system.)
--
You are receiving this mail because:
You are the assignee for the bug.
