Main Area and Open Discussion > General Software Discussion

OpenOffice.org's Calc cancels MS Excel sheet protection

(1/2) > >>

erikts:
I prepared worksheet for a client using Excel 2007. I locked certain cells and protected the sheet using Review|Protect Sheet menu.

For compatibilty, I opened it in OpenOffice.org Calc (version 3.2.0) and found out that it canceled the Excel's sheet protection; all locked cell can be altered.

Is it a bug in Excel or in Calc?

Deozaan:
That's strange. I have the opposite problem. There's a spreadsheet made in Excel that when opened in Calc cannot edit some cells that are editable in Excel.

erikts:
That's strange too. Can anyone open the file here (mediafire) or here (Let's Crate) in your version of Excel / Calc and confirm the behaviour?

Bamse:
Protection can be removed in Libreoffice 3.3 RC1. Reason is probably this http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=34865

40hz:
There's a distinct possibility the reason Oo doesn't recognize a protected or locked Excel element is because Microsoft has a patent on the method by which the cell is protected. So rather than infringe by recognizing a protected cell, Oo just ignores the read-only status.

BTW - didn't somebody (CA?) actually get issued a patent for a method to write-protect a spreadsheet cell back in 2001 or thereabouts? I seem to remember reading about that and the flap it caused.

Navigation

[0] Message Index

[#] Next page