Summary: | Loss of all data in a "Calc" file when saving and closing LibreOffice/Calc. The file still exists but is empty, it contained more than 23 sheets with data in each sheet. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | BOB <albator15> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEEDINFO --- | ||
Severity: | enhancement | CC: | stephane.guillou |
Priority: | medium | Keywords: | dataLoss |
Version: | 7.6.4.1 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Windows (All) | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=155472 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
BOB
2024-02-01 19:35:01 UTC
As a __simple user__ as I am, before anything else, I would suggest making a copy of the file that you currently have. Whichever attempts to recover the data with whichever software, you should perform such attempts on a copy of the file, instead of your current file. I wonder whether something different happened this time with this file, different than in the past. Perhaps the problem is generated with a particular version of Calc, whereas opening the same file (now, its copy) with an older version the data would still be shown. In any case, I would suggest "installing in parallel", and never to have 2 versions opened at the same time. Since this file has been around for 23 years, I guess it is an XLS file(?) There might be some regression introduced in some newer version of Calc regarding compatibility with the file format. For instance (and without any kind of direct relation to this particular case that I know in advance), LO Calc 7.4 officially supports 16384 columns, but XLS files support 65536 columns only. Similarly, some spreadsheet functions used to support a limited amount of arguments, which might have been increased over time but the XLS file format might not support. I cannot say that this is what is happening here and that this is the reason for the possible data loss; I am just mentioning this as a potential regression case that might need testing. A different approach (to be attempted on a copy of the file) is to try a different spreadsheet tool instead of LO Calc. Perhaps AOO's Calc might be able to recover the info? I don't know whether the "online" version of Excel (365) supports XLS files, but a some older "offline" version should. I think that Google Sheets does not support the XLS file format, but I am not completely sure. An additional possibility would be to transfer a copy of the file to a different computer and attempt a recovery there, with whichever spreadsheet tool that is known to support the file type that you have been using for 23 years. Specialized recovery tools (as opposed to spreadsheet tools) might have better results, if the spreadsheet tools fail. Again, I am just a simple user. Someone else posting here might have better suggestions. (In reply to ady from comment #1) > For instance (and without any kind of direct relation to this particular > case that I know in advance), LO Calc 7.4 officially supports 16384 columns, > but XLS files support 65536 columns only. Sorry I messed up that paragraph. Of course I meant 16384 columns vs 1024 columns for older versions of LO Calc, and the XLS format supports only 256 columns. Do you remember what changes you made to the file before saving? Did Ady's recommendations help in any way? Without reproducible steps, and possibly a sample file, it will be very difficult to pinpoint the issue, unfortunately. I am not aware of any existing issue like yours, confirmed elsewhere. Hopefully you were able to recover the data, or use a backed up version of the file. Note that version 24.2 brings changes regarding autorecovery and backup versions of files: https://wiki.documentfoundation.org/ReleaseNotes/24.2#Core_/_General |