https://bugs.documentfoundation.org/show_bug.cgi?id=174266
Bug ID: 174266
Summary: Calc: threaded XLSX loading gives wrong MIN results in
a 100-row recurrence
Product: LibreOffice
Version: 7.2.0.4 release
Hardware: ARM
OS: macOS (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A four-column recurrence using MIN(B2:C2)-1 produces incorrect numbers when
recalculated during threaded file loading.
Steps to Reproduce:
1. In Calc Settings/Options > Calc > Formula, set Excel 2007 and newer to
Always recalculate. Enable multi-threaded calculation under Calc > Calculate;
disable OpenCL if available.
2. Restart LibreOffice, then open threaded-row-range-in-recurrence.xlsx.
3. Inspect D2 and A3:D3 before editing or recalculating.
Actual Results:
D2 is -1; A3:D3 is -1, 0, 1, -1. In total, 397 of 400 data cells are incorrect.
Expected Results:
Every row in A2:D101 should contain 5, 6, 7, 5.
Reproducible: Always
User Profile Reset: No
Additional Info:
macOS 27.0.1 ARM64: fails in 7.2.0.4, 7.2.7.2, 7.6.7.2, 26.8.0.3 and
27.2.0.0.alpha0+ master 7528c0d40601 (2026-10-31).
Linux ARM64: fails in 7.3.7.2 (Ubuntu 22.04); passes in 6.0.7.3 (Ubuntu 18.04)
and 6.1.6.3 (Ubuntu 18.10). Current master was not tested on Linux.
Fresh-profile automated load tests, OpenCL off. Disabling threading before
reopening, or Recalculate Hard after loading, gives correct results. Reducing
to 99 data rows also passes. Introduction commit unknown.
Checked bug 133161 (MIN, WORKSFORME): its original attachment now calculates
correctly on master. Bug 128863 is resolved by recalculation on load, already
enabled here. Bug 128329 remains a broader open calculation issue. No exact
duplicate confirmed.
Opening this attachment in the compiled macOS GUI also reproduces the error.
--
You are receiving this mail because:
You are the assignee for the bug.
