Bug 144001 - Crash while deleting work or opening workbook
Summary: Crash while deleting work or opening workbook
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-22 07:44 UTC by dongshili
Modified: 2022-04-06 03:45 UTC (History)
3 users (show)

See Also:
Crash report or crash signature: std::_Hash<std::_Umap_traits<ScLookupCache::QueryKey,ScLookupCache::QueryCriteriaAndResult,std::_Uhash_compare<ScLookupCache::QueryKey,ScLookupCache::QueryKey::Hash,std::equal_to<ScLookupCache::QueryKey> >,std::allocator<std::pair<ScLookupCache::QueryKey

Attachments
this attach (774.27 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-08-23 15:20 UTC, dongshili 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description dongshili 2021-08-22 07:44:56 UTC 
Description:
Crash while deleting work or opening workbook

Steps to Reproduce:
1.The program crashed while opening the workbook
2.
3.

Actual Results:
Crash report has been successfully uploaded.

Soon you will find the report in the following location:

https://crashreport.libreoffice.org/stats/crash_details/62e7d290-6076-465b-846e-a3521406dd41

Expected Results:
Fix the BUG


Reproducible: Always


User Profile Reset: Yes



Additional Info:
none
Comment 1 Roman Kuznetsov 2021-08-22 09:36:32 UTC 
PLease attach the file that you tried to open
Comment 2 dongshili 2021-08-23 15:20:54 UTC 
Created attachment 174497 [details]
this attach
Comment 3 QA Administrators 2021-08-24 03:48:55 UTC Comment hidden (obsolete)
Comment 4 Henrik Palomäki 2021-08-26 06:51:14 UTC 
Cannot reproduce the bug.

The attached file seems to open without any errors. Only some cells contain weird "jaa" words that don't exists when opening the file in MS Excel. I guess they have some meaning. Also, deleting cells with a "Del", "Delete Rows" or "Delete  Columns" keys seem to work and does not crash the Calc. Finally, Opening an existing workbook works as excepted. It opens normally.

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 0224d859b8a497779611cc15943c017ec42f9b90
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win
Locale: fi-FI (fi_FI); UI: en-US
Calc: CL
Comment 5 Telesto 2021-08-26 15:25:14 UTC 
No crash with
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: f58f35b2c8ca1efbacec642a8f3de5b0c499bc6b
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: Skia/Raster; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL

They external file connected to the attached file is lacking - 2021年最新版营口耘垦牧业有限公司员工电子花名册-核对完-欣(13)(1).xlsx 

It looks like an look-up issue. So the file is maybe needed to reproduce the crash
Comment 6 Timur 2021-08-27 08:18:50 UTC 
Henrik and Telesto, you need to first test with user's version. In this case, also no repro.
Then, see Needinfo for reporter to check and add the external file.

dongshili, you wrote User Profile Reset: Yes, please also confirm you did reset or delete user profile. And that crash happens always.
Comment 7 dongshili 2021-09-04 00:22:03 UTC 
According to my recent use, the most common problem is the problem of external links. When there are external links in the table and the external links are not available, the table will jam, crash and fail to respond, but not every time. Therefore, this is a little troublesome, and I don't know how to reproduce it for you, As for whether to reset the user data, I think I made a mistake. In fact, I didn't perform this operation.
Comment 8 QA Administrators 2021-09-04 04:02:38 UTC Comment hidden (obsolete)
Comment 9 Timur 2021-09-06 10:25:13 UTC 
dongshili, thanks for response. 
I put this in Needinfo because, although crash is there, bug cannot be confirmed without steps. 
Attached XLSX is trying to update from another file that we don't have, but it doesn't crash. 

So please:
1. try with User Profile Reset and Help-Restart in Safe Mode.
2. if bug is again reproduced, please try to make minimal sample and reproducible steps.
Comment 10 QA Administrators 2022-03-06 03:32:27 UTC Comment hidden (obsolete)
Comment 11 QA Administrators 2022-04-06 03:45:52 UTC 
Dear dongshili,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp