Description: I am in the process of migrating to Libre Office from MS Office. So far it has been going well with Writer and Calc being the apps in scope right now. I maintain a spreadsheet of significant household purchases and I include a soft copy of the invoice or receipt for each in purchase inserted into a cell of each purchase row. The soft copy files are a mix of JPGs and PDFs. This time I needed to convert an Outlook email into a saveable format for the spreadsheet and so converted it to a .HTM file as there were a limited number of choices. I then discovered the process for inserting a file into Calc worked quite differently from MS Office. I tried a number of different methods within Calc to do it, but they twice resulted in Calc crashing (and a dialogue coming up to submit a bug report). Calc then offered to recover the files I had open and I clicked Ok to do that. I can't recall all the steps in the process, but Calc eventually became unresponsive and I had to reboot the laptop. I opened the spreadsheet in Calc again and found it had lost all the previously inserted JPGs and PDFs. Excel confirmed this. Thankfully I was able to recover my corrupted spreadsheet from backup. I went back to Excel and inserted the .HTM file as required and it all worked normally. Calc can now open the spreadsheet and I can view the newly inserted .HMT file. This was a real shock to have an office app crash so badly and corrupt data in the process. What happened here??? Steps to Reproduce: 1.The process as far as I can recall it is shown in the Description 2. 3. Actual Results: As per the description Expected Results: As per the description Reproducible: Didn't try User Profile Reset: No Additional Info: Nothing to add.
Created attachment 194744 [details] Screenshot of Help>>About
FWIW, in the Help > About, near "Version information" there is an icon to copy the info to the clipboard, so you can paste it in your report, as plain text. Since LO 7.5 is EOL by now, I would suggest trying with a newer version. I am not saying that it will solve whichever caused the crash, but surely version 7.5 will not receive any new updates. With a newer version, please report whether you have a similar behavior, or any relevant information. For example, is the crash happening repeatedly? Are the steps repeatable and ending with the same result? Can this be reproduced with multiple files?
Hi I hadn’t realised how far out of date my install had got – I installed it ages ago and didn’t use it again until very recently, when I started the migration process. Thanks re that icon near the version info I had looked in that dialogue box but didn’t see it. So I am now on: Version: 24.2.4.2 (X86_64) / LibreOffice Community Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2 CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: en-NZ (en_NZ); UI: en-GB Calc: CL threaded That problem IS repeatable on the new version of LO too I have found out by accident. > Opened the problematic spreadsheet with the new version of Calc and it looked OK though the icons for the inserted files were all a bit out of alignment with their cells. So I moved them all to tidy it up. > Closed the file and re-opened it and the icons/files had all gone. Closed the file and opened it in Excel – the files were absent there too. > I again restored the file from backup, and won’t be using Calc on this file again until I know if it is a bug that will be fixed. > Does Calc support inserted files in this way, or am I doing something it was never intended to support? thx
I also tried creating a new spreadsheet in Calc and inserting various files through the Insert>OLE Object>OLE Object>Further Objects>Insert Object>Create from File sequence. PDFs and JPGs inserted and opened fine. Save and closed the spreadsheet, then re-opened and the files had gone. Opened with Excel and it sees the same result.
*** This bug has been marked as a duplicate of bug 150120 ***