Reported (in excellent detail) by a user trialling CODE (bug also present in Collabora Online): XLSX files opened and saved (with or without an edit) and then opened in Excel gives "We found a problem with some content in filename. Do you want us to recover as much as we can?" Using the repair function the detail reported is "Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded. Removed Feature: View from /xl/worksheets/sheet2.xml part" The Collabora Online demo reproduces the same error with these files. The user continued testing after initial report and noticed the connection with "freeze panes" function. The same files that resulted in the error after being use in CODE did not generate any error if "freeze panes" was turned off before being opened and saved in CODE.
The corruption issue should be fixed by the following commit, it will be part of the next version of CODE as well. Ultimately implementing frozen rows/columns in online would be the best solution, but that'll require more work. The feature is tracked in bug 116858. https://cgit.freedesktop.org/libreoffice/core/commit/?id=0ef7bc8a1d2f00715d6849f1bbceb26e32382d41 author Henry Castro <hcastro@collabora.com> 2019-03-29 09:01:05 -0400 committer Henry Castro <hcastro@collabora.com> 2019-04-01 17:57:45 +0200 sc lok: avoid save incorrect data, whether the pane has ...