Ask Your Question
0

Can Excel open & edit LibreOffice Calc sheets?

asked 2017-10-26 21:02:36 +0100

Librecurious gravatar image

updated 2017-12-10 16:59:48 +0100

erAck gravatar image

In other words, are they almost interchangeable? If I create a sheet in LibreOfice Calc and then share it with someone who has Excel, will she be able to read, use & even edit it? Please don't ask about "versions" as I don't know. Just answer the general question best you can. Thanks!

edit retag flag offensive close merge delete

Comments

How much does it cost to buy a house? Please don't ask about country, city, area, house size, currency used, etc; I don't know. Just answer the general question the best you can...

:) some questions just cannot be answered without details.

Mike Kaganski gravatar imageMike Kaganski ( 2017-10-27 11:09:28 +0100 )edit

$900,000 :)

Librecurious gravatar imageLibrecurious ( 2017-10-30 17:51:24 +0100 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-10-27 11:03:42 +0100

peterwt gravatar image

There is no simple yes/no answer and it does depend on versions. If you save the Calc spreadsheet in the default for Calc, the Open Document Format .ods, then MS Excel 2010 or later is required to open this format. A simple check by the user of Excel is if they can save a spreadsheet in .ods then they can open it. Otherwise you will need to save the Calc spreadsheet in Excel format, which is an option in the Calc save dialogue. There is however no guarantee of complete compatibility.

edit flag offensive delete link more

Comments

Excel 2010 drops all formulas and other things and keeps only the numbers and strings, only Excel 2013 started to actually be usable with ODF .ods files.

erAck gravatar imageerAck ( 2017-10-27 20:59:21 +0100 )edit

Thank you both. I should have added that the document has no formulas; it's just text, no formulas (text with different sizes & bolds, etc.). And they're both fairly recent versions (I guess). Thanks though!

Librecurious gravatar imageLibrecurious ( 2017-10-30 17:40:38 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-10-26 21:02:36 +0100

Seen: 1,106 times

Last updated: Oct 27 '17