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 18.104.22.168, 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 22.214.171.124 as well as 126.96.36.199, 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"
Application crashes while editing multi-line comments containing characters, which may be treated as mathematical operators
Application does not crash due to editing multi-line comments containing characters, which may be treated as mathematical operators
User Profile Reset: No
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
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.
*** Bug 124949 has been marked as a duplicate of this bug. ***
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!
Thanks for providing the file.
So, how do you reproduce the crash? You double click on many cells in column P until it crashes ?
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.