On August 10 I edited an xlsx file in latest libreoffice release. The file was based on an earlier file. In Libreoffice calc it works fine but when trying to open it in MS office excel 2010 - it issues a warning (file corrupt)
Steps to Reproduce:
1. Download file
2. Open the file in MS office (I used office 2010)
3. Warning is issued...
See step 3 above (this problem) - anomaly - se https://www.dropbox.com/s/n6imml6joravte3/Open%20file%20in%20Office%20problem.png?dl=0
No warning! Compatibility - please!
User Profile Reset: No
Attachments need to be added, no Dropbox links.
Please write precisely, not "in latest libreoffice release" but "in LO 220.127.116.11" if that's the case.
Well, I use the latest off. release, 6.1...
Created attachment 144185 [details]
Did it happen to you with previous versions of LibreOffice?
OTOH, Could you please attach the original document before saving it in LibreOffice?
Well, the excel file contains the fixtures in the premier league for the 2018-19 season and is based on this file
which opens as expected in excel 2010. Here there is a new sheet containing the matches from round 1 to 38 for a certain team. This was created around August 10 - using the latest official Libreoffice calc at that time and uploaded/shared using dropbox.
So I am not able to find/pin point what causes excel 2010 (and other Microsoft releases) to issue the opening file warning (damaged file).
So I updated the new file/document only using release 6.1.03 and only have one release available at any time, i.e. always the latest one released
On a second thought, I think the cause again is a too long sheet name. I renamed it to see if that works from
Målscorere og terminliste, 2018-19
Created attachment 144215 [details]
Sample ODS with 32-character sheet name
Indeed, here's an extremely simple sample with nothing, but a 32-character sheet name. Save it as XLSX in Calc, and try opening it in Excel.
No problem with a 31-character name.
Created attachment 144216 [details]
Sample XLSX saved from the ODS
This is the same file saved as XLSX in LO 18.104.22.168 that fails to open in Excel.
Not really same file - as the last file link shows, the first sheet name is renamed to a shorter than max 30-32 chars length - which works fine with Excel 2010. What is the status of this sticky flaw? Should be easy to trap and prevent the incompatibility
Dupe of bug 79998
*** This bug has been marked as a duplicate of bug 79998 ***