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: [email protected]
Reporter: [email protected]
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.
