I have a spreadsheet that I created in Libre on a laptop with an Ubuntu OS. It contains auto-calculated scores. I occasionally save a copy on USB, transfer to a server, and open (usually to view only) on a Windows PC in Excel. A few months ago, I modified my document on Excel on the Windows PC (added conditional formatting on one of the sheets), and then saved a copy over to the Ubuntu laptop. I’ve since been updating my document on the Ubuntu OS laptop in Libre, where it still looks just fine. However, ever since those conditional formatting modifications, every time I save a copy over to view in Excel on my Windows computer, this happens:
- Excel appears to open twice when I try to access the document, then gives me an error message - found a problem with the content, do you want us to recover? I click yes.
- after recovery, the formatting is messed up - column widths are wrong, some of the column heading text on merged cells is missing.
- I click “Enable editing” and Excel says openings and repairing again.
- At some point, it gives me a “Name conflict” error box (Name cannot be the same as a built-in name. Old name: Print_Area_0).
I have tried saving the file on the Ubuntu laptop within Libre in many different types of formats, and I have stripped conditional formatting off the file in Libre, and every time I then try to open it on my Windows PC in Excel, it still requires repair and doesn’t display properly. What happened? How do I fix this? Thanks.