https://bugs.documentfoundation.org/show_bug.cgi?id=159510
--- Comment #1 from ady <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
