Bug 144500

Summary:	Insert Sheet From External File Crashes Calc
Product:	LibreOffice	Reporter:	IBC <ibc>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INSUFFICIENTDATA
Severity:	normal	CC:	serval2412
Priority:	medium	Keywords:	wantBacktrace
Version:	7.2.0.4 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description IBC 2021-09-14 14:40:50 UTC

Description:
In Calc destination file: Sheet > Insert Sheet (or right click on a sheet tab > Insert Sheet), select From file and applicable sheets, application crashes. Crash occurs regardless of Link checkbox selection. Crash also occurs when invoking Move or Copy Sheet from origin file to destination file.

Both files are .ods files and work fine otherwise. Issue occurs in Normal and Safe Mode and regardless of whether the origin file is open or not.

Steps to Reproduce:
1. Sheet > Insert Sheet
2. Check From file, select file
3. Highlight sheet(s) to be inserted
4. Click OK.
5. Witness crash

Actual Results:
Crashed application.

Expected Results:
Inserted sheet(s).


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Inserted the sheet(s).

Comment 1 Julien Nabet 2021-09-14 19:54:00 UTC

On Win10 with master sources updated some days ago, I don't reproduce this.
I tried with:
- a new ods file containing 2 sheets with just "test1" for first sheet and "test2" for second sheet
- a new ods file where I insert sheet 2 of first file above.

1) Do you use ods, xlsx, xls files?
2) Can you reproduce this by following what I did? If not, would it be possible you attach your files? (after sanitizing them, see https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission)

Comment 2 IBC 2021-09-14 23:21:16 UTC

Fully updated Windows 10.

1) The files are .ods, converted from .xlsx. They work fine indiviudally.

2) No. It worked fine with two new files. I can't really sanitize the originals without clearing out all their sensitive financial data, in essence emptying them completely. I was able to get around the issue by manually copying (Sheet 1: Ctrl-A, Ctrl-C; Sheet 2: Crtl-A, paste values/formats, recreate links within destination file) the sheets from one file into the other where I had manually inserted and renamed new sheets.

Note that I pasted values and formats, not formulas, so there were no links in the pasted data. The issue could be that the origin file had links to the destination file. Importing those now potentially circular links might cause a conflict, leading to the crash. 

I tried that in one cell with the new files and the linked cell formula I created in the original disappeared and displayed an #NAME? error in the imported sheet, and the contents were reduced to an equal sign. My files have way more than just one linked cell.

I suppose this ticket can be closed though I suggest that the applicable help pages be updated to warn users of such link conflicts, especially where there are many links.

Many thanks.

Comment 3 Julien Nabet 2021-09-15 19:18:28 UTC

Would it be possible you retrieve a backtrace (see https://wiki.documentfoundation.org/QA/BugReport/Debug_Information#Windows:_How_to_get_a_backtrace) ?

It takes a bit of time but a backtrace with symbols may provide some hints about root cause.

Comment 4 IBC 2021-09-15 19:48:26 UTC

Sorry, no. It looks way too involved and I don't want to chew up 300 MB of my hard drive. Please close this ticket as I had already worked around the issue.

Comment 5 Julien Nabet 2021-09-15 20:20:56 UTC

Ok then, let's put this one with INSUFFICIENTDATA since we don't have files to reproduce this or backtrace.
Hopefully you found a workaround and also, if you want to, you may test it again with next LO releases.