https://bugs.documentfoundation.org/show_bug.cgi?id=140014
Bug ID: 140014
Summary: Calc crashes when using COUNTIF, SUMIF, etc. on
columns "far away" without data
Product: LibreOffice
Version: 7.0.3.1 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Open Calc, type "=COUNTIF(BM5:BM9,0)" in a cell. Calc crashes.
It is the same for the other functions of the same family (SUMIF, COUNTIFS,
etc.). It works until BL column, but fails for column after that.
If these columns have data, then the formula works ok.
What makes the bug worse: if the columns have data, then the formula is added,
then the data is removed, the file can be saved. But then LibreOffice crashes
as soon as the file is opened, making it unusable and causing data loss.
Steps to Reproduce:
1. Open Calc on an empty file
2. Type "=COUNTIF(BM5:BM9,0)" in a cell
Actual Results:
Calc crashes
Expected Results:
No crash
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.0.3.1
Build ID: 00(Build:1)
CPU threads: 4; OS: Linux 5.9; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
7.0.3-5
Calc: threaded
That's the version I have currently, but the problem is older than that.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs