https://bugs.documentfoundation.org/show_bug.cgi?id=174267
Bug ID: 174267
Summary: Calc: MIN of cells returning empty strings gives
Err:519 during threaded XLSX loading
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:
In the attached 100-row workbook, MIN(B2,C2) fails on file load although both
referenced cells contain error-free empty strings.
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-min-of-empty-strings.xlsx.
3. Inspect D2 before editing or recalculating.
Actual Results:
D2 is #VALUE! (Err:519). D3:D101 correctly contain 0.
Expected Results:
D2:D101 should all contain 0: MIN ignores text in referenced cells.
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 fixed bugs 97587 (SUM empty values) and 77969 (MIN/MAX empty matrix):
related, but no exact duplicate confirmed. Bug 135551 is NOTABUG because its
arguments already contain errors; these arguments do not.
--
You are receiving this mail because:
You are the assignee for the bug.
