Description: I store several .ods files in a 7Zip archive with password. To edit such a calc table I open the archive in 7Zip, open the file under Users\MyNamw\AppDAta\Temp\..., edit it, write it back and exit LibreOffice. Then 7Zip asks me if I want to update the archive, works very nice. However if I forget to CLOSE ALL LibreOffice files before opening the target file then it happens very often that LibreOffice does not report the file closing to 7Zip, it does not ask me to save and and ALL MY EDITINGS GET LOST. I use LibreOffice 7.1.3.2 (x86) Build: https://git.libreoffice.org/core/+log/47f78053abe362b9384784d31a6e56f8511eb1c1 with Windows 10.0 Build 19042 I found the same problem with OpenOffice as well. Steps to Reproduce: 1. Make a 7Zip archive with a calc x.ods file, open and change it. 2. Open a different LibreOffice file and do NOT close it. 3. Save the first file and exit from calc. 7Zip does not ask if update the archive and my changes get lost. Actual Results: See above Expected Results: My changes get lost Reproducible: Sometimes User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: at Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no Versionsinformation 7.1.3.2 (x86) / LibreOffice Community 47f78053abe362b9384784d31... CPU-Threads: 2; BS: Windows 10.0 Build 19042 Ul-Render: Skia/Raster; VCL: win de-DE (de_DE); Ul: de-DE Calc: threaded
I could not reproduce on Ubuntu 18.04, opening the .7z archive with GNOME Archive Manager 3.28.0. In both case, Archive Manager was able to prompt me to update the archive. Version: 7.1.8.1 / LibreOffice Community Build ID: e1f30c802c3269a1d052614453f260e49458c82c CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Version: 7.2.4.1 / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Can you please try again: - with your user profile reset - with one for the two versions above (there was a security fix in the latest 7.1 version so it's a good idea to update anyway) It might be a Windows-specific issue, or it might be a 7zip issue, but in any case, we will need you to try the above. And can you please give use the version of 7Zip that you are using. Is it up to date? Instructions for user profile reset or safe mode: https://wiki.documentfoundation.org/UserProfile#Help_wizard_.28LibreOffice_5.3_and_newer.29 Download a recent version of LO: https://www.libreoffice.org/download/download/
Created attachment 177092 [details] A .7z archive with a simple calc table
Created attachment 177093 [details] A simple Writer document A requested I updated to LibreOffice 7.1.8 and deleted the user profile I updated to 7Zip 21.06 and the problem still exists. Please repeat following steps. 1. Open test0.7z with 7zip 2. Load test1.ods from the archive 3. Change test1.ods and save + exit 4. 7Zip asks: 'The file "test1.ods" has been changed, do you want to update the archive?' 5. I press OK and the file is updated. 6. Open test2.odt 7. Repeat steps 1-3, there is no question for update, the changes are lost
Unfortunately I have to work with Windows. As requested I updated to LibreOffice 7.1.8 and deleted the user profile I updated to 7Zip 21.06 and the problem still exists. Please repeat following steps. 1. Open test0.7z with 7zip 2. Load test1.ods from the archive 3. Change test1.ods and save + exit 4. 7Zip asks: 'The file "test1.ods" has been changed, do you want to update the archive?' 5. I press OK and the file is updated. 6. Open test2.odt 7. Repeat steps 1-3, there is no question for update, the changes are lost
[Automated Action] NeedInfo-To-Unconfirmed
Confirmed for any LO module with: Version: 7.2.4.1 (x64) / LibreOffice Community Build ID: 27d75539669ac387bb498e35313b970b7fe9c4f9 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win Locale: en-AU (en_AU); UI: en-US Calc: threaded And 7-Zip 18.01 If you close all instanced of LibreOffice while 7-Zip is still opened, 7-Zip prompts the user to update the archive and save the changes. But it 7-Zip is closed while a second document is still opened, the changes are actually lost. However, I also tested with Microsoft Word and could reproduce the same issue: editing an archived DOCX file with MS Word, opening another document, saving the changes in the first one: the archive does not update. So I'm going to call this one "not our bug", but I'm happy to be convinced otherwise?
"But it 7-Zip is closed while a second document is still opened, the changes are actually lost." I DO NOT CLOSE 7-ZIP (why should I do it?), leave the second document open and close my Calc file, then 7-Zip does not ask me and my changes are lost.
I agree with you Thomas, I was just adding another observation to cover all bases, which are: - close and save only the changed file but not the second one, 7-Zip still opened: not prompted to update, changes losts when reopening the file. - close both files while 7-Zip still open: prompted to update the archive, changes are kept. - close and save changed file, then close 7-Zip, then close second file: not prompted to update the archive, changes are lost. You described correctly a real issue, and thank you for that. But again, it looks like this is not specific to LibreOffice, as it also happens when editing zipped files with other applications. Examples: - This seems to hint at the issue, using MSO: https://sourceforge.net/p/sevenzip/discussion/45798/thread/fec17482/ - This too, still MSO: https://sourceforge.net/p/sevenzip/discussion/45797/thread/88941bd1/#1420 - But it's not just MSO and LO, this one is with Notepad++: https://sourceforge.net/p/sevenzip/bugs/2070/ Hence me closing this as "NOTOURBUG".
- May I add that earlier I worked with OpenOffice and I ALWAYS lost my editing if there was any other OO-file open any time during my Calc editing procedure. With LibreOffice it is a bit better, sometimes if I notice the other file and close it before saving my edited Calc file, then SOMETIMES 7Zip asks me to update. I haven't investigated the connections exactly. - I also have to add that the "other" file is a "normal" one, it does not come from an archive. - The cases you mentioned are really similar to mine, hopefully there will be a solution soon.
I doubt the statement "NOTOURBUG". As a workaround I installed OpenOffice in additional to LibreOffice - I open the document to be edited from the 7Zip archive with LibreOffice - All other additional documents will be opened with OpenOffice - I edit the the archive document as necessery - I save and close it and 7Zip ALWAYS ask me to save and thanks to OpenOffice I never lose my editing! Pls. recheck the case
(In reply to Thomas Farkas from comment #10) > I doubt the statement "NOTOURBUG". > As a workaround I installed OpenOffice in additional to LibreOffice > - I open the document to be edited from the 7Zip archive with LibreOffice > - All other additional documents will be opened with OpenOffice > - I edit the the archive document as necessery > - I save and close it and 7Zip ALWAYS ask me to save and thanks to > OpenOffice I never lose my editing! > > Pls. recheck the case Hi Thomas Could you please test it the other way around too? (Open the archived document with OpenOffice, open additional documents with LibreOffice.) I suspect the reason it works is that you use two different applications, not that OpenOffice behaves differently. In which case it would suggest it is indeed 7zip's issue, not LibreOffice's.
Hi Stéphane, I tested the issue several times and I am astonished: the problem has disappeared with LibreOffice and with OpenOffice as well! In the meantime I had a number of software updates - probably there is the reason. I am going to deactivate OpenOffice, use LibreOffice only and if I find no problem till the end of this year we can close the issue. Thx and best regards Thomas
Thank you for commenting back with the good news, Thomas! Could you by any chance provide us with your current version number of 7Zip? It might point us to what might have fixed the issue on their side. Cheers!
I have 7-Zip 21.06 (x86) 1021-11-24, I started this issue after that date. As I wrote, it works, but I feel uneasy because 7Zip asks me for update only after ALL LibreOffice files are closed. If I worked on this project I would try to find a solution where 7Zip is notified IMMEDIATELY after the edited archive-file is saved and closed, not much later.
Now I use LibreOffice only and the problem has appeared again, see following reproducible procedure. - Open the CSV-file with my new bank transactions. - Open my bank account data in a .ODS file from the password protected 7Zip archive. - Add the new transactions to the bank account file, save and close it. - Close the .CSV file. - 7Zip does NOT ask for save, my changes are lost. If I open the .CSV-file with OpenOffice, my changes are saved in the archive.