Ask Your Question
0

Excel files corrupts opened in Calc [closed]

asked 2012-04-24 06:53:55 +0200

Alpha gravatar image

I have a spreadsheet originating from Excel 2007 as an XLS then finally saved as an XLSX. There are no macros and nothing too terribly complicated I feel. Lots of formulas with basic math like a typical spreadsheet. It is my annual household budget with a tab for each month. One month's left over money gets carried to the following month (that is the most "complicated" formula IMO).

My next computer will be a Mac so I want to get use to using Libre full-time but keep things in Microsoft format for compatible with other people and systems. Opening this file in Calc and saving as a XLSX makes the file unreadable/unrecoverable. If I open in Calc and save as ODS it works just fine.

Any hints on what to look at to resolve this? I've contemplated doing a new file in Clac from scratch and saving it to see what happens.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-23 21:39:06.098251

2 Answers

Sort by » oldest newest most voted
2

answered 2012-04-24 08:36:40 +0200

Pedro gravatar image

LibreOffice works best with ODS format so for your internal use that format is always preferred.

If you want to "keep things in Microsoft format for compatible with other people and systems" then xls is better than xlsx. It has been around for longer and the compatibility with other spreadsheets (LibreOffice Calc included) is more proven.

That said, saving as a MS format (or any format) should NEVER corrupt data. If it does then you could contribute to improve this office suite by preparing an example file, and do a step-by-step report at
https://www.libreoffice.org/get-help/bug/

edit flag offensive delete link more
0

answered 2012-04-24 16:15:23 +0200

Alpha gravatar image

Thank you. After posting last night I attempted a file from scratch in Calc saved as a XLSX and am still having the same issue. Not sure corrupt is the correct description. The file when opened is all messed up visually making the file unusable in Libra and unable to open in Excel. Beginning to think it may have something to do with Windows | Freeze. Will do a bit more testing this week including the XLS suggestion above and report back.

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-04-24 06:53:55 +0200

Seen: 3,284 times

Last updated: May 26 '14