[Libreoffice-bugs] [Bug 144500] Insert Sheet From External File Crashes Calc

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144500

--- Comment #2 from IBC <ibc at clarkefest.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210914/4e13ac6c/attachment.htm>