Ask Your Question
0

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

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

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

Comments

Likely tdf#108691

Mike Kaganski gravatar imageMike Kaganski ( 2019-09-03 14:03:50 +0200 )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 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

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

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

Stats

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

Seen: 32 times

Last updated: Sep 11