Bug 141603 - Calc crashes with "Invalid child index" error on different operations, but only on certain ODS documents
Summary: Calc crashes with "Invalid child index" error on different operations, but on...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.5.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-04-10 11:37 UTC by Emil Prpic
Modified: 2021-09-13 20:09 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Error alert screenshot (14.18 KB, image/png)
2021-04-10 11:38 UTC, Emil Prpic
Details
LibreOffice about window screenshot (619.17 KB, image/png)
2021-04-10 11:38 UTC, Emil Prpic
Details
Document that exhibits the problem (46.50 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-04-10 11:40 UTC, Emil Prpic
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Emil Prpic 2021-04-10 11:37:22 UTC
Description:
While EDITING or FORMATTING certain ODS documents only (also when these same documents are in XLS or XLSX format), Calc crashes at different times and while doing different operations, always popping up an alert 

Libre Office 7.0 - Fatal Error 
Invalid child index

The problem is present for 4-5 years now, but it doesn't happen too often (I don't use these specific documents too often).

I can't recognize any trigger pattern. Sometimes it crashes when I directly double-click into a cell (to edit the content of that cell) if that window didn't have focus before double-clicking it. But not always. Sometimes it crashes when I change font size of a cell, but not always. Sometimes it crashes when I hit cmd+s (it crashes before saving the document), but not always. 

I'm attaching one document that has this problem. I also can't say for sure what is it in this document that causes the problem. I thought that maybe an original document that I created was corrupt in some way, and I always used it as a template for the other documents later. So recently I recreated a fresh document from scratch, but the problem is still present. So, it must be about some specific formatting or some specific content inside.

What I can think of as being different than other spreadsheets I use, is:

- the font used is Geneva

- there is a large number of rows of great height (a lot of text in one of the columns) - usually there are about a hundred to several hundred rows all toghether, and maybe about 20% of them of great height

- inside cell contents, a hard line break (cmd+enter) is extensively used

- inside cell contents with a lot of text (very high rows), there is a lot of text formatting - like using bold text and different font sizes inside the same cell

- page header has multiple lines

Steps to Reproduce:
1. Open document
2. Try editing and formating the contents (sometimes everything works fine for hours)
3. Calc crashes out of the blue on some usual editing or formatting operation

Actual Results:
Calc crashed, everything since last save is lost

Expected Results:
Calc not crashing, editing works fine. :-)


Reproducible: Sometimes


User Profile Reset: Yes



Additional Info:
Copy&paste from About window doesn't work. See screenshot attached for version information.
I alse tested the same document attached here under Libre Office Safe mode. It crashed after 3-4 minutes of editing, when I clicked on Print Preview tool button.
Comment 1 Emil Prpic 2021-04-10 11:38:00 UTC
Created attachment 171076 [details]
Error alert screenshot
Comment 2 Emil Prpic 2021-04-10 11:38:39 UTC
Created attachment 171077 [details]
LibreOffice about window screenshot
Comment 3 Emil Prpic 2021-04-10 11:40:46 UTC
Created attachment 171078 [details]
Document that exhibits the problem
Comment 4 psidiumcode 2021-06-02 16:01:52 UTC
I could not reproduce it after editing several styles mentioned in the comments. 

Version: 7.0.6.2
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded

Version: 7.2.0.0.alpha1+ / LibreOffice Community
Build ID: 3b57ebb445df8a2bc3d916ea79f8af45e20e4e62
CPU threads: 12; OS: Mac OS X 10.15.7; UI render: default; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
Comment 5 Emil Prpic 2021-06-03 05:02:31 UTC
Can someone using OS 10.13 try to reproduce, just to compare? Meanwhile I even completely removed LibreOffice, and all the application settings, preferences and everything else I found (~/Library/...), reinstalled from scratch, and the problem is still present. 
I'm not in a position to update to a later OS as some essential every-day tools don't work on OS later than 10.13.
Comment 6 Roman Kuznetsov 2021-09-02 19:46:35 UTC
Emil, can you update your LibreOffice to 7.1.5 version and try repeat your problem there?
Comment 7 Emil Prpic 2021-09-13 18:50:58 UTC
Sorry for a late reply. I installed 7.1.6.2 an hour ago. I've been playing with the same document as uploaded here for a while ("a while" being long enough to cause a crash usually) and nothing happened (i.e. no crash). This doesn't mean that the problem is solved, but I'll try testing some more in the following days. I'm not 100% optimistic because the problem is present for years now and none of the version updates made any difference so far.
Comment 8 Roman Kuznetsov 2021-09-13 20:09:30 UTC
(In reply to Emil Prpic from comment #7)
> Sorry for a late reply. I installed 7.1.6.2 an hour ago. I've been playing
> with the same document as uploaded here for a while ("a while" being long
> enough to cause a crash usually) and nothing happened (i.e. no crash). This
> doesn't mean that the problem is solved, but I'll try testing some more in
> the following days. I'm not 100% optimistic because the problem is present
> for years now and none of the version updates made any difference so far.

It means the problem was solved really. LibreOffice gets over 20 patches every day. One from its can fix the problem easily.

I suggest close this one as WFM, but if you'll get the crash again, then feel free to reopen this report.