Bug 157901 - Crash when I try to copy any cell that contains a formula
Summary: Crash when I try to copy any cell that contains a formula
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.7.2 release
Hardware: All macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-10-23 16:37 UTC by ganndan
Modified: 2025-02-19 03:11 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
example file where the copy-paste causes a crash (114.84 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-04-22 14:41 UTC, ganndan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description ganndan 2023-10-23 16:37:01 UTC
Description:
When I try to copy/paste a formula, frequent (approx 20%) crash as soon as I hit Copy.

Steps to Reproduce:
1.select a cell that contains a formula, that you want to duplicate
2.hit Command+C to copy
3.

Actual Results:
immediate crash

Expected Results:
well... copy the cell content and stay alive, I presume...


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
Version: 7.4.7.2 / LibreOffice Community
Build ID: 723314e595e8007d3cf785c16538505a1c878ca5
CPU threads: 4; OS: Mac OS X 13.4.1; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded
Comment 1 Stéphane Guillou (stragu) 2023-10-23 19:45:58 UTC
Thanks for the report.
LO 7.4 won't see further updates. Can you please test again in a recent version, preferable 7.6?
Thank you!
Comment 2 QA Administrators 2024-04-21 03:15:57 UTC Comment hidden (obsolete)
Comment 3 ganndan 2024-04-22 13:42:09 UTC
originally reported in release 7.4.x and still present in release 7.6.5.2

The problem occurs in a file where I use numerous lookup formulas. Very frequently (although not systematically), when I try to copy-paste such a formula, LibreOffice crashes as soon as the copy is executed (once the file is recovered, the paste is found to have been correctly executed, so apparently the crash happens when transitioning back from the paste.)

Example of a formula that causes the crash:
=IF(INDEX(Verbes!B:B;$F6)="";"";INDEX(Verbes!B:B;$F6))

I had to stop using LO for this file and get back to Excel, where it works fine :(
Comment 4 Stéphane Guillou (stragu) 2024-04-22 14:29:26 UTC
If you are able to, please attach a example file that consistently reproduced the crash.

One more question: do you use some kind of clipboard manager? If so, does the crash still happen when it is turned off?
Comment 5 ganndan 2024-04-22 14:41:02 UTC
Created attachment 193803 [details]
example file where the copy-paste causes a crash

using the standard MacOS clipboard manager
Comment 6 ganndan 2024-04-22 14:43:21 UTC
Last time it crashed, I was copying celles in tab "Aléatoire" area O3-U11
(The file is in .xlx but the previous .odt version crashes as well)
Comment 7 QA Administrators 2024-04-23 03:15:47 UTC Comment hidden (obsolete)
Comment 8 raal 2024-04-29 21:23:22 UTC
No repro with Version: 24.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 5740d3fa83e9725a2771e5f00ba4aaf9965f0be2
CPU threads: 4; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded Jumbo
Comment 9 Stéphane Guillou (stragu) 2024-04-30 05:00:28 UTC
Not reproduced in:

Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 4; OS: macOS 10.15.7; UI render: Skia/Raster; VCL: osx
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Comment 10 Dennis Roczek 2024-04-30 11:24:57 UTC
(In reply to ganndan from comment #6)
> Last time it crashed, I was copying celles in tab "Aléatoire" area O3-U11
> (The file is in .xlx but the previous .odt version crashes as well)

I cannot reproduce the crash either using 
Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 4; OS: macOS 11.7.10; UI render: Skia/Raster; VCL: osx
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded


2 Questions:
1.) What do you mean with 03-U11? Cell U11 is hidden? Are you trying to copy multiple cells?
2.) can you try to reset your user profile? See https://wiki.documentfoundation.org/UserProfile or use the safe mode.
Comment 11 MikeLW 2024-07-03 10:09:29 UTC
I think I am seeing the same crash as ganndan. It happens with one particular file, and it used to happen occasionally but is now more frequent and is getting rather annoying. At least the recovery from crash is good in LO so I don't lose anything. It crashes as soon as I hit Cmd-C to copy. When I reopen the file, I can select the same cell and copy it ok, but it will then crash randomly later on another copy. I'd say it's crashing on about 10% of copies. Like ganndan my spreadsheet has numerous lookup formulas, but it can happen on any cell, not just cells with a formula.

The file contains some sensitive personal data, so I would not be keen to send it to you, but I would be happy to run it in debug mode or whatever if that could give you some more useful information. I will also make a note of each crash and what I was doing just before to see if I can spot a pattern.

Version: 24.2.4.2 (AARCH64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: macOS 14.5; UI render: Skia/Raster; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Calc: threaded
Comment 12 Dennis Roczek 2024-07-03 13:46:51 UTC
(In reply to MikeLW from comment #11)
> The file contains some sensitive personal data, so I would not be keen to
> send it to you, but I would be happy to run it in debug mode or whatever if
> that could give you some more useful information. I will also make a note of
> each crash and what I was doing just before to see if I can spot a pattern.
Try this one
https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission

Test if it still happens and provide the modified file. I guess (at the moment) that it is not a prolem on the content itself, but structure or the formulas.
Comment 13 ady 2024-07-03 14:42:59 UTC
(In reply to MikeLW from comment #11)
> It crashes as soon as I hit Cmd-C to copy.

Version 24.2.5 (and the development versions) will include patches for similar problems (that might or might not solve this one too). There is a testing pre-release version available already in the LibreOffice download page.

See also tdf#161461 comment 14 (especially regarding the "xattr" command).
Comment 14 Buovjaga 2024-08-22 06:14:42 UTC
(In reply to ady from comment #13)
> (In reply to MikeLW from comment #11)
> > It crashes as soon as I hit Cmd-C to copy.
> 
> Version 24.2.5 (and the development versions) will include patches for
> similar problems (that might or might not solve this one too). There is a
> testing pre-release version available already in the LibreOffice download
> page.
> 
> See also tdf#161461 comment 14 (especially regarding the "xattr" command).

Adding MikeLW to Cc to ask about this.

Would be interesting to also hear from ganndan about how 24.2.5 works.
Comment 15 QA Administrators 2025-02-19 03:11:26 UTC
Dear ganndan,

This bug has been in NEEDINFO status with no change for at least
6 months. Please provide the requested information as soon as
possible and mark the bug as UNCONFIRMED. Due to regular bug
tracker maintenance, if the bug is still in NEEDINFO status with
no change in 30 days the QA team will close the bug as INSUFFICIENTDATA
due to lack of needed information.

For more information about our NEEDINFO policy please read the
wiki located here:
https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO

If you have already provided the requested information, please
mark the bug as UNCONFIRMED so that the QA team knows that the
bug is ready to be confirmed.
 
Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-NeedInfo-Ping