Created attachment 190500 [details] the trashed xls file this is the second time this has happened to me recently. this time i created this file today and updated/saved it a few times. then i closed it and when i reopened it, all the data had gone. not real happy! one common theme is that the spreadsheets had > 1 tab. this one had 4 tabs. you can see at the bottom it says sheet 1 of 4 but there is only the first tab/sheet displayed. all cells are empty. (when i open it in excel, there are 4 tabs but all are empty) this is x86 version of libre office windows 11. tks
Created attachment 190501 [details] this file is ok i started a brand new file and kept copies. this one is ok.
Created attachment 190502 [details] bad file then i entered the formula =MAX(B367:CD367) in row 367 and copied it to column a in rows 17 - 366 and saved and closed. on reopening, i have this empty spreadsheet (attached). same if i edit new - Copy (2) and do save as a new file.
the point is, while i keep it open and simply save changes, all is ok with the copy in memory. the problem seems to be with what is saved?
now i tried closing libre office and repeating and now it worked.
Please test in safe mode, Menu/Help/Restart in Safe Mode
i restarted in safe mode and the trashed xls file looks exactly the same as in normal mode. are you suggesting that i should run in safe mode until the problem recurs and then there will be some diagnostic information? as i see it, something gets corrupted in the runtime program after some time and then it starts saving the spreadsheet improperly and loses the data while the in memory copy carries on ok. the user doesn't know this has happened until they close and reopen the file and then it is too late and the data has gone. i do not have any extensions other than the bundled ones. i cannot recreate the problem at will - it needs to await libre office getting "corrupted", which has only happened twice. can you not look at the internals of the bad file and see why it might have got corrupted? tks
(In reply to simon.j.hunter from comment #0) > Created attachment 190500 [details] > the trashed xls file > > this is the second time this has happened to me recently. this time i > created this file today and updated/saved it a few times. then i closed it > and when i reopened it, all the data had gone. not real happy! > > one common theme is that the spreadsheets had > 1 tab. > > this one had 4 tabs. you can see at the bottom it says sheet 1 of 4 but > there is only the first tab/sheet displayed. all cells are empty. (when i > open it in excel, there are 4 tabs but all are empty) > > this is x86 version of libre office windows 11. > > tks There are three hiden sheets, Menu/Sheet/Show sheet.
ok, i can see the other 3 sheets, but they are all empty, their contents weren't saved.
i don't believe it but the first file that had this problem has had it again now that i open it today. it was last updated on 29/10, the day before i had the problem with the attached file. most likely, though i am not sure, libre office was open the whole time. so my hypothesis is that whatever is going wrong started on the 29th or before and persisted through the 30th causing problems for 2 files when they were saved.
[Automated Action] NeedInfo-To-Unconfirmed
If you save the file and use Menu/File/Reload, the file is fine or the data it's lost?
if i now open the bad file and then reload it, it is empty. i didn't try this earlier.
i thought i would try the 64 bit version (which i think i stopped using ages ago because of a lenovo display driver problem). anyway the problem is still happening and frequently. eg today libre office has been open since at least yesterday and i opened a file, saved it and it has lost its data (though in memory copy still displays ok). i can see this if i check - the file size shrinks. is there anything i can do while the file is still open to get some info on what is going on in the in memory copy?
Created attachment 190667 [details] windows error report i have seen this crash several times and it is related. i got it yesterday and then today, both times saving a 'bad' file. today, after office had been left open overnight, i opened the xls file. when i did save as .ods of the unmodified file, i got 'file cannot be written'. when i tried save as .xlsx, i got the crash. close office and retry - all ok. something in office is going wrong after it has been open for some hours.
(In reply to simon.j.hunter from comment #2) > Created attachment 190502 [details] > bad file > > then i entered the formula =MAX(B367:CD367) in row 367 and copied it to > column a in rows 17 - 366 and saved and closed. > > on reopening, i have this empty spreadsheet (attached). > > same if i edit new - Copy (2) and do save as a new file. I did what you said with the formula and after reopening the formulas remain present. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: c0c8cffd3541e3cd616c96791b04e7ebf2b2ed03 CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
My recommendations moving forward: - Update to LO 7.6 (because 7.5 is unlikely to get further fixes) - Start with a new user profile (after backing up the old one): https://wiki.documentfoundation.org/UserProfile - See if the issue persists. - And as a general recommendation: work on ODS or XLSX files, as the XLS binary format is harder to investigate and obsolete in many ways. (In reply to simon.j.hunter from comment #14) > Created attachment 190667 [details] > windows error report > i have seen this crash several times and it is related. I've linked your bug 158095 in "see also".
i upgraded to Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Vulkan; VCL: win Locale: en-AU (en_AU); UI: en-GB Calc: CL threaded and renamed my user profile folder. only options i then set were language english GB and default save file types as xlsx, docx, pptx. opened LO. 6 hours later i got the crash again when closing/saving a file i had left open during this time. Faulting module name: ucrtbase.dll, version: 10.0.22621.2506, time stamp: 0x097c794c Exception code: 0xc0000409 Fault offset: 0x000000000007f61e it was an xlsx file but it wasn't corrupted.
i have also had the "close XLS spreadsheet and all the data is lost" problem, same as before (was with a .xls file).
I see from bug 158095 that you use Skia/Vulkan. Might be worth it to: 1. Share with us the Skia log copied from: Tools ▸ Options... ▸ LibreOffice ▸ View 2. In the same menu, use "Force Skia software rendering" and see if you still have issues
went into safe mode and turned hardware accelerate off. waited a few hours and opened a xlsx. edited it and do file - close. crash. no data lost from sheet. went into safe mode and left hardware accelerate alone (?? use hardware acceleration checkbox is checked and disabled). checked use skia for rendering. restart. waited a few hours and opened a xlsx. edited it and do file - close. crash. no data lost from sheet. this is all there is in the skia log: RenderMethod: vulkan Vendor: 0x8086 Device: 0x3e92 API: 1.3.211 Driver: 0.404.1960 DeviceType: integrated DeviceName: Intel(R) UHD Graphics 630 Denylisted: no
this may well be related to the Skia rendering. i turned it off and restarted and left LO open for a few hours. got the contents deleted from an xls file and the 'can't write file' error for an ods file and also a crash (xlsx file i think). i will turn rendering back on and see how i go.
It never offers to send a crash report? A more convoluted way to get a backtrace of the crash would be https://wiki.documentfoundation.org/How_to_get_a_backtrace_with_WinDbg while using Win-x86@39 from https://dev-builds.libreoffice.org/daily/master/current.html Then the symbol path has to be this as mentioned in the wiki article CACHE*C:\symbols;SRV*https://dev-builds.libreoffice.org/daily/master/Win-x86@39/symbols;SRV*https://dev-downloads.libreoffice.org/symstore/symbols;SRV*https://msdl.microsoft.com/download/symbols
see bug 158095 i did sometimes get the dialog to send a crash report but not recently and one is there. LO just closes. i have downloaded windbg (win 11) but it doesn't bear much resemblance to the version described in the wiki. eg one doesn't seem to have to set the symbol path. it suggests you have to run the debugger on a separate machine, which i can't do. when i try and debug the LO process i can't do anything in LO, which i assume is because it is on the same PC? when i close windbg, LO closes too. but i don't know what i am doing in this area!
Dear simon.j.hunter, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
couldn't recreate in this version. i have been using .xlsx format instead of .xls since the problem was reported so wouldn't have been seeing it anyway. also i may have changed from 32 to 64 bit version. Version: 25.8.3.2 (X86_64) Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e CPU threads: 6; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; VCL: win Locale: en-AU (en_AU); UI: en-GB Calc: CL threaded
(In reply to simon.j.hunter from comment #26) > couldn't recreate in this version. > > i have been using .xlsx format instead of .xls since the problem was > reported so wouldn't have been seeing it anyway. also i may have changed > from 32 to 64 bit version. > > Version: 25.8.3.2 (X86_64) > Build ID: 8ca8d55c161d602844f5428fa4b58097424e324e > CPU threads: 6; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster; > VCL: win > Locale: en-AU (en_AU); UI: en-GB > Calc: CL threaded Thanks for following up. In bug 158095 you mentioned that you got daily crashes even with the 64-bit version (the 32-bit version is indeed now a thing of the past). I do see that there have been recent crash reports against 25.8 for the same signature WW8Export::RestoreMacroCmds()