Created attachment 142088 [details] The file damaged - warning - in Norwegian I am experiencing a file opening error - file damaged - edited with Libreoffice calc in MS excel 2010 - warning/Damaged file... I interchange files using dropbox repository https://www.dropbox.com/s/3oqz5nl7myrgh30/All-Time%20English%20Football%20Top%20Flight%20Table%20from%20Season%201888-89%20to%202016-17.xlsx?dl=0 Download and open it in MS excel 2010 Please also note I reported bug 116939 - Problem opening excelfile in latest release - due to overflow for file https://www.dropbox.com/s/2h8c7cf0fjlx6zr/Trafikkd%C3%B8d%20i%20Norge%2C%201947-2016%2C%20etc.xlsx?dl=0 That bug has incorrect state: Resolved despite that is _not_ resolved and related to lack of compatibility across different office platforms. Cheers Sverre
Do you have worked in file format xlsx all the time? Or do you have worked in LibreOffice format .ods as well? If yes, please attach the .ods file here. You have selected "6.0.3.2 release" as earliest affected version, but the file says "LibreOffice 5.3.4.2"? Which versions do you have used? Have you worked on the file with Excel too? Or is it the first time, you have tried to use it in Excel? Is the file really damaged? Or does the "repaired" file contains all the information? I see the problem with the linked file and Excel 365, but it would be good to know, how the file was generated.
Created attachment 142104 [details] Version history in dropbox, created August 22, 2017 The file was created last Summer (august 22) using the latest published libreoffice version at that time (August 22, 2017). So it was Libreoffice5.x and always save and work only with .xlsx format. I have also set up this as default but that information you are welcome to find out, yourself. I only report this problem. The data is probably copied from some web source/page and sorted using libreoffice5 calc.
I found out that the file was last changed in July 17, 2017, and no problem opening the file using Libreoffice, 6.04 x64 (win 10). But file sharing across platforms is an important compatibility issue. That is the problem (MS office 2010, 32-bit fails)
Sverre, if you report bugs, please always give full history info like Regina asked. Also attach file here, not Dropbox links. And if you give screenshot make sure it's English UI with English errors. And do not complain here about other bugs - that were dealt with BTW, unlike some that are open for years, having no volunteers to fix them. Good practice is to first save as source .ods and than to save as .xlsx. So if you attach. ods that we can reproduce an issue. Filesave issue in LO is different to fileopen in MSO. If we have only the final damaged file, than it's guessing and I'd close this as InsufficinetData. MSO says: Repaired Records: Worksheet properties from /xl/workbook.xml part (Workbook) Or you can recreate .ods with the same data (not via save as) and than save as .xlsx and open with MSO and see if and when error happens. You can use LO 6.0.4.
I think you should be happy that users report of problems. The file says it all, imo. So please resolve the problem without problemising that Libreoffice creates incompatible office files!
I even just tested opening the xlsx file in office 2016 x64 on win10. Same problem so it is better that you debug problem with your product than blaming the many users that certainly need to share office files across platforms using yes dropbox and other file sharing resources. So I believe this problems affects all MS office variants. Incompatible issues is close to saying goodbye to the the same office platforms that do not provide fully compatible formats. I know of a few in addition to the handful reported...
Created attachment 142327 [details] The file damaged - warning - in Norwegian I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2 and may have found out at least missing information (repaired in MS office). See attmt 4
Created attachment 142328 [details] The file damaged - warning - in Norwegian step 2 [2] I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2 and may have found out at least missing information (repaired in MS office). See attmt 4
Created attachment 142329 [details] The file damaged - warning - in Norwegian [3] I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2 and may have found out at least missing information (repaired in MS office). See attmt 4
Created attachment 142330 [details] The file damaged - warning - in Norwegian [4] I experienced a similar conflict with a document edited in Libreoffice 6.0.4.2 and may have found out at least missing information (repaired in MS office). I think the problem is that Libreoffice allows too long sheet names. This limit should/must be compatible with MS office PS I do not want to share the office docmt due to that it is private/privacy. You should just test it yourself. The problem is to me proved (I know the sheet name is longer than attmt 4 shows (MS off. 2010, repaired...)
In other words, the longer sheet name created in Libreoffice 6.0.4.2 Rydding, turveier, Plankemyra-S is not compatible with MS excel 2010 (and others). I beieve the full name was Rydding, turveier, Plankemyra-Strømsbubukt (it could be other reasons, I just pinpoint what I noticed is "repaired")
In the original trouble report - there is also a long sheet name maratontabell, fiks tusendel, s which is not revealed due to overflow conflict. I will test this when I get home to see if borth files can be fixed by using shorter sheet names (up to 31 chars)
Created attachment 142368 [details] Original sheet name - gives error in MS Office Hence, Libreoffice should not allow long sheet names (max 31 chars)
Created attachment 142369 [details] Work around - rename sheet name Both files are now possible to open in MS office without this sticky repair warning/loss of data... Hence, you know what to fix (compatibility, crucial)
I've opened https://www.dropbox.com/s/3oqz5nl7myrgh30/All-Time%20English%20Football%20Top%20Flight%20Table%20from%20Season%201888-89%20to%202016-17.xlsx?dl=0 in Version: 6.1.0.0.beta1+ Build ID: da49f4aeb8d5e9a7d2cba8855d911e7cc1d2f1e2 CPU threads: 4; OS: Linux 4.13; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group Could you please try to reproduce it with a master build from http://dev-builds.libreoffice.org/daily/master/ ? You can install it alongside the standard version.
Well, I resolved what I suspected was the problem - which should be clearly described both by examining the screen shots (attachments). The problem is that Libreoffice allows longer sheet names than MS office supports. So the reason why you don't experience this problem now is that the link is updated with a compatible shorter sheet name. BUT you must surely dissalow such stick long sheet names (max 31 chars, it seems) - as it seems impossible to get any hints of what is repaired by MS office (at least I am not able to get the details - which are competely omitted...) Do you follow me and resolve the compatibility problem to prevent the maximum no of chars to 31 chars for sheet names. This observation is also emphasized as another document had similar problem - also resolved by renaming the _too_ long sheet name Please confirm and update the status to reflect this crucial infomn provided! I suggest this should be a prioritised issue to be fixed asap. Agree? Cheers Sverre
Ok, I understand the problem now... Since this bug was growing to fast, I've reported it in a new bug. Please follow the conversation there... Closing as RESOLVED DUPLICATED *** This bug has been marked as a duplicate of bug 117926 ***