Ask Your Question

A .xlsx file downloaded from my OneDrive corrpupts when saved in LibreOffice

asked 2019-09-03 13:55:05 +0100

anthony_sheppard gravatar image

OS: Windows 7. Libre Office V6.1.6.3 (x64). I downloaded a 167KB .xlsx workbook, edited in Excel OnLine, from my OneDrive and opened it OK in LibreOffice. But if I save it in LibreOffice as an 'xlsx file and then reopen it, all or parts of some sheets are blanked out by a white frame - see attached screen shot C:\fakepath\LOCalcError_ScrnShot.docx. I need to keep this in Excel format for sharing purposes. There are no complex pivot tables etc, just simple budget arithmetic with some cells linked between sheets.

Can anyone advise on how to avoid this problem.

edit retag flag offensive close merge delete


Likely tdf#108691

Mike Kaganski gravatar imageMike Kaganski ( 2019-09-03 14:03:50 +0100 )edit

Thanks, Mike. This very technical bug report is mostly over my head, but I have tried to send the big white boxes obscuring cells to the back and make them transparent, without success.

anthony_sheppard gravatar imageanthony_sheppard ( 2019-09-11 12:34:36 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-09-11 12:43:38 +0100

anthony_sheppard gravatar image

So far, the only way I can see of avoiding this problem is to Save it into LO in .ods format, or to simply download the Excel file (from OneDrive) and avoid saving it in LO.

I tried Saving in .ods format and then resaving in Excel format, but the same problem reappears when I reopen the Excel file.

Can anybody come up with a better solution? I've not had comparable problems with Word or Powerpoint files.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-09-03 13:55:05 +0100

Seen: 66 times

Last updated: Sep 11 '19