Download it now!
Bug 124948 - Calc EDITING: Frequent "Fatal Error: Invalid child index" while editing long multi-line comments in cells crashing LibreOffice Calc
Summary: Calc EDITING: Frequent "Fatal Error: Invalid child index" while editing long ...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: All Mac OS X (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 124949 (view as bug list)
Depends on:
Blocks: Crash
  Show dependency treegraph
 
Reported: 2019-04-25 09:37 UTC by t0rt1e
Modified: 2020-05-16 18:10 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Anonymised generic grades table as test case (15.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-05-10 12:17 UTC, t0rt1e
Details

Note You need to log in before you can comment on or make changes to this bug.
Description t0rt1e 2019-04-25 09:37:51 UTC
Description:
I have a table in a LibreOffice Calc document, which calculates the final grade and some statistics for student projects of a course I give. Besides the points, there is a column for comments, in which I note down my observations of the work of the individual groups. Each cell in the column holds typically a multi-line text, where the first character of each line is either '+' (positive), '-' (negative), or '*' (neutral) followed by a short note text. I enter this text live during the project presentation so that the current cell is in mode editing for several minutes. This has been working fine for me since 2015 and LibreOffice Calc would run reliably without crashes as far as I can remember.

Since LibreOffice 6.2.0.3, I am observing frequent crashes (approx. 3 to 5 times per 90 minute session) while editing these multi-line comments. The comment cells have no particular assigned cell format. However, it may be relevant for the bug to trigger, that I copy the multi-line comment using a formula to other lines of the comment column using a cell formula, e.g., "=G6". The error message preceding the crash is always the same "Fatal Error: Invalid child index". After confirming it, LibreOffice Calc crashes and needs to be restarted. The file recovery succeeded so far each time, however entered comments were losts: at least the one I was actively editing and sometimes also previously edited comments (depending on the last moment of saving the document).

So far, I was able to reproduce this error on LibreOffice 6.2.0.3 as well as 6.2.2.2, which were always running on macOS High Sierra 10.13.16 of a MacBook Pro 15 inch 2017 model.

Steps to Reproduce:
1. Repeatedly edit multi-line comments, where the lines start with '+', '-', or '*'
2. Have these comments copied to other cells using a cell formula, e.g., "=G6"
3. Don't assign any particular cell format such as "Text"

Actual Results:
Application crashes while editing multi-line comments containing characters, which may be treated as mathematical operators

Expected Results:
Application does not crash due to editing multi-line comments containing characters, which may be treated as mathematical operators


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.2.2
Build-ID: 2b840030fec2aae0fd2658d8d4f9548af4e3518d
CPU-Threads: 8; BS: Mac OS X 10.13.6; UI-Render: Standard; VCL: osx; 
Gebietsschema: de-CH (de_CH.UTF-8); UI-Sprache: de-DE
Calc: threaded
Comment 1 Xisco Faulí 2019-04-25 10:05:22 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)

I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
Comment 2 Julien Nabet 2019-04-25 12:44:28 UTC
*** Bug 124949 has been marked as a duplicate of this bug. ***
Comment 3 t0rt1e 2019-05-10 12:17:44 UTC
Created attachment 151291 [details]
Anonymised generic grades table as test case

Sorry, that it took so long to provide the requested test case. I just now managed to find some time to anonymise fully the grades table. I observed the repeated crashes of Libreoffice Calc while editing the cells in the "Feedback" column of table "Project". Thanks you for looking into this bug report! I hope that you can localise and fix the source of the crashes!
Comment 4 Xisco Faulí 2019-08-14 10:17:44 UTC
Thanks for providing the file.
So, how do you reproduce the crash? You double click on many cells in column P until it crashes ?
Comment 5 t0rt1e 2019-08-14 10:34:13 UTC
The crash happens while editing the feedback comments entered into the cells of column P. I do this primarily using the keyboard (F2, arrow keys, various editing shortcuts, CMD-Return to enter a newline in the cell, etc.). I hardly use the mouse / touchpad for navigating the table. I was not able to narrow the crashes to a particular sequence of key strokes. However, it happens very frequently for me while repeatedly adding/editing the multi-line comments, where the lines start with '+', '-', or '*'. As I do write down the comments during the project presentation and evaluation of its report, editing a cell may take several minutes. To reduce the risk of loosing notes, I try to remember to save the cell entry frequently by pushing Return after entering a longer sequence of notes. Sometimes, I save the whole document at this moment and other times, I will simply continue adding notes to a cell by pressing F2 again.
Comment 6 Roman Kuznetsov 2019-09-21 13:35:41 UTC
no crash in

Version: 6.2.7.1
Build ID: 23edc44b61b830b7d749943e020e96f5a7df63bf
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: ru-RU (ru_RU.UTF-8); UI-Language: en-US
Calc: threaded
Comment 7 Roman Kuznetsov 2019-09-21 13:36:35 UTC
try update LibreOffice to 6.2.7.1 and your macOS to 10.14.6
Comment 8 Xisco Faulí 2019-09-24 11:31:06 UTC
(In reply to Roman Kuznetsov from comment #7)
> try update LibreOffice to 6.2.7.1 and your macOS to 10.14.6

Hello t0rt1e@gmx.de,
Could you please try to reproduce it with the latest version of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 9 Jens 2019-10-21 13:24:50 UTC
Hi, 
I can reproduce this bug in the current version (6.2.8.2) on MacOS 10.14.6 as follows:

1. create a new empty calc document
2. enter in first cell below some multi line text with three lines (must be three lines)
3. click on any other cell to select it
4. click into input line and the error occurs

Sometimes the error does not occur after step 4. but when I repeat steps 2. to 4. the error occurs. 

Version: 6.2.8.2
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 6; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: de-DE (de_DE.UTF-8); UI-Language: en-US
Calc: threaded
Comment 10 t0rt1e 2019-10-21 13:35:10 UTC
I can confirm the steps to reproduce this issue posted by Jens. With them, my Libreoffice 6.2.5.2 installation on macOS High Sierra 10.13.6 (17G8037) crashes systematically.
Comment 11 t0rt1e 2019-10-21 13:44:05 UTC
Also Libreoffice 6.3.2.2 is affected on macOS High Sierra 10.13.6 (17G8037). Sorry, I cannot test on a more recent version of macOS.
Comment 12 Alex Thurgood 2019-11-08 06:29:54 UTC
(In reply to Jens from comment #9)

Tried with Version: 6.3.1.2
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
Threads CPU : 4; OS : Mac OS X 10.15.1; UI Render : par défaut; VCL: osx; 
Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR
Calc: threaded

> 
> 1. create a new empty calc document
> 2. enter in first cell below some multi line text with three lines (must be
> three lines)
> 3. click on any other cell to select it
> 4. click into input line and the error occurs
> 
> Sometimes the error does not occur after step 4. but when I repeat steps 2.
> to 4. the error occurs. 
> 


Still unreproducible for me. Never get a crash. Even tried starting the text entry with characters like +, *, -, etc made no difference.
In first cell I entered at least 4 lines of text, then select another cell with mouse, then the line input with the mouse, entered some more multiline text, chose another cell, repeat, etc, no crash.
Comment 13 Alex Thurgood 2019-11-08 06:38:00 UTC
Can someone tell me the difference between Shift-Return and Cmd-Return when doing multi-line entry ?

I've tried both in attempting to reproduce this bug, but still no crash, sorry.
Comment 14 Alex Thurgood 2019-11-08 06:46:14 UTC
Tried to reproduce with test file submitted by OP. Still no repro.

The only common theme I see so far in the versions that crash is the German locale (whether de_CH or de_DE).
Comment 15 3c75qui6edcb 2019-12-02 05:00:40 UTC
I can reproduce this bug using the test file submitted by OP. I can get it to crash by changing the background color of cells in column P. I can also get it to crash using the steps specified by OP.

Version: 6.3.1.2
Build ID: b79626edf0065ac373bd1df5c28bd630b4424273
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: default; VCL: osx; 
Locale: en-AU (en_AU.UTF-8); UI-Language: en-US
Calc:
Comment 16 t0rt1e 2019-12-15 17:38:56 UTC
Sorry for the big delays in responding to this issue. I have less frequently access to my MacBook Pro these days, as I had to shift my day-to-day work on a different computer. I am still observing the issue with Libreoffice:

Version: 6.3.4.2
Build-ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU-Threads: 8; BS: Mac OS X 10.13.6; UI-Render: Standard; VCL: osx; 
Gebietsschema: de-CH (de_CH.UTF-8); UI-Sprache: de-DE
Calc: threaded

The steps reported by @Jens still trigger the issue reliably. Steps 2 to 4 just need to be repeated several times. On macOS, a new line is inserted into a cell using CMD-Return. Shift-Return moves to the cell above the current cell.
Comment 17 Timur 2019-12-15 19:34:38 UTC
I am not with Mac but I see this was reproduced.
Comment 18 divinerites 2020-04-24 10:14:49 UTC
Confirmed with :

- LibreOffice 6.4.3.2
- MAC OSX Mojave 10.14.6 (18G4032)

Same crash with multi-line text in cells
Comment 19 t0rt1e 2020-04-24 12:32:48 UTC
I also still observe the bug in 

LibreOffice Version: 6.4.3.2
Build-ID: 747b5d0ebf89f41c860ec2a39efd7cb15b54f2d8
CPU-Threads: 8; BS: Mac OS X 10.13.6; UI-Render: Standard; VCL: osx; 
Gebietsschema: de-CH (de_CH.UTF-8); UI-Sprache: de-DE
Calc: threaded

@divinerites: Did you find by any chance a more simple way to provoke the crash in a reproducible way?