Ask Your Question

Calc deleting entire sheets of XLSX files

asked 2017-01-18 06:55:19 +0200

MarkBC gravatar image

I have an Excel XLSX file, which if opened in Excel 2007 contains many lines of data in one of its tabs. But if the same file is opened in CALC (LibreOffice version that tab displays as entirely empty.

(A previous instance of this bug a few days ago showed that if I save the file opened in Calc with data missing, then that data is permanently gone. Another instance of this problem had a large number of rows being cleared/deleted off the bottom of a large sheet (i.e. higher numbered rows went missing). )

Today I showed that if I close CALC without saving, then reopen the file with Excel, the data is still there. I cycled through the process, opening/closing in CALC then opening/closing in Excel a few times to verify the bug.

Then I made an edit to that tab via Excel. Now opening in CALC succeeds and shows the tab with all its data.

I have attached screenshots showing the tab empty on a MAC running LibreOffice and showing the tab full of data on a PC running Excel 2007.

But after the above edit, my file is not CURRENTLY reproducing the issue, so I have not attached the file. Since this has happened repeatedly in the last few days, CALC is no longer trustworthy. And CALC is deleting tabs that I don't even see, so if I opened spreadsheet to edit tab A but silently tab B was cleared, then I save the file, I might not find out for days or weeks that tab B got cleared.

This is a critical bug. Has this been seen by anyone else? Is there an older version of LibreOffice I should revert to?

Thanks for any help!

PC Excel screen shot of tab with data C:\fakepath\LibreCalcPCScreenShot-170118.JPG

Mac LibreOffice Calc screen shot of emptied tab C:\fakepath\LibreCalcMacScreenShot2017-01-18at12.03.51AM.png

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-18 13:14:50 +0200

m.a.riosv gravatar image
edit flag offensive delete link more


Yes, that seems to match the "entire tabs empty" issue. But sometimes only many rows near the bottom are missing. Would that fit too?

MarkBC gravatar imageMarkBC ( 2017-01-19 22:48:20 +0200 )edit

Please test with a master build.

m.a.riosv gravatar imagem.a.riosv ( 2017-01-20 10:32:54 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-18 06:55:19 +0200

Seen: 398 times

Last updated: Jan 18 '17