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: UNCONFIRMED
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: 2024-04-30 11:24 UTC (History)
3 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.