[Libreoffice-bugs] [Bug 140014] New: Calc crashes when using COUNTIF, SUMIF, etc. on columns "far away" without data

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: pierre.auckenthaler at orange.fr

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210130/6c257c93/attachment.htm>