https://bugs.documentfoundation.org/show_bug.cgi?id=160616
Bug ID: 160616 Summary: SUMPRODUCT calculation is broken in some cases, if the ranges are beyond the last cell with data Product: LibreOffice Version: 24.8.0.0 alpha0+ Master Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: miguelange...@libreoffice.org Description: After tdf#159687 improvement to shortcut the calculations with SUMPRODUCT at the last cell with data, is some cases the calculation is now broken. It returns #VALUE while the calculation it's fine with 24.2. Regression with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 42f6e89d5e6458966de452af2978f206115394af CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Works fine before the change with: Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01 CPU threads: 16; OS: Windows 10.0 Build 22631; UI render: default; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL threaded Steps to Reproduce: Open attached file. Actual Results: . Expected Results: . Reproducible: Always User Profile Reset: Yes Additional Info: . -- You are receiving this mail because: You are the assignee for the bug.