| Summary: | Crash when I try to copy any cell that contains a formula | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | ganndan |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | UNCONFIRMED --- | ||
| Severity: | normal | CC: | dennisroczek, raal, stephane.guillou |
| Priority: | medium | ||
| Version: | 7.4.7.2 release | ||
| Hardware: | All | ||
| OS: | macOS (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | example file where the copy-paste causes a crash | ||
|
Description
ganndan
2023-10-23 16:37:01 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! 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 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 :( 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? Created attachment 193803 [details]
example file where the copy-paste causes a crash
using the standard MacOS clipboard manager
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) [Automated Action] NeedInfo-To-Unconfirmed 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 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 (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. 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 (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. (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). |