Ask Your Question
0

Excel vs OpenOffice vs Calc

asked 2015-02-05 17:04:19 +0200

beckinista gravatar image

We have been using MSOffice365, but are researching alternatives. One of our divisions started using OpenOffice and we have run into an issue - an XLSX spreadsheet that has certain cells protected so that downstream users can enter certain data but cells with calculations are protected. When saving to the OpenOffice format, I am advised that there are no protection options available. Does CALC have that same issue, or can I change back and forth between the two formats and maintain my protection settings?

Thanks!

edit retag flag offensive close merge delete

Comments

'Calc' is the common name of the spreadsheet component of LibreOfice and of Apache OpenOffice as well. In both cases you also have options to protect cells. 'Default' cell format has set the 'Cell Protection' to 'Protect' checked, 'Hide formula' not checked.

Another thing is using cell protection with alien formats, and in specific with documents edited under different office suites, and converted now and then between the different "preferred formats".

Lupp gravatar imageLupp ( 2015-02-05 18:59:23 +0200 )edit

The so called "office document formats" are'n simply different formats for exactly the same content. Even the different MS formats are not really reliably converted one into another without changing some aspects of the document's properties.

You cannot rely on details of the formatting, and in specific not on the cell protection, if you shift a document around. Use the ODF system (ods for spreadsheet documents) exclusively and protection will work.

Lupp gravatar imageLupp ( 2015-02-05 19:07:08 +0200 )edit

@ Lupp - why don't you make your 2 comments and answer. It is a good one.

ROSt52 gravatar imageROSt52 ( 2015-02-06 07:28:53 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-02-17 20:12:10 +0200

JohnHa gravatar image

updated 2017-02-17 20:13:53 +0200

There will never be 100% compatibility between .xlsx and .ods files, or between LO Calc and MS Excel, not least because it is clearly not in Microsoft's business interests - read profit - to make it easy for other programs to interface easily with MS products. MS wants to sell you MS Office.

You have to live with the inevitable differences or capitulate to Microsoft's "standards" and buy MS Office.

See [Tutorial] Differences between Writer and MS Word files.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-02-05 17:04:19 +0200

Seen: 5,672 times

Last updated: Feb 17 '17