Apache OpenOffice (AOO) Bugzilla – Issue 65455
missing an important feature in spreadsheet
Last modified: 2013-08-07 15:12:27 UTC
comparing to the other very expensive products of this type i found a feature that i need and OOv2.0.2 doesn't support it or at least i didn't found it.... it's about protecting parts of the spreadsheet e.g. a region of the spreadsheet cells c1:d8 if are protected and the entire preadsheet is protected to be able to unprotect that region of cells with a different password than the password set for the entire spreadsheet. To be more specific i give you the following example: I am the designer of a document with more sheets... but in one of the sheets i want to give access to a user to complete the data of one column without giving him the possibility of changing anything else in the document but still to be able to save the modifications made by him in the region of cells that he has a unlock password for it. I'm very sure Excel 2003 has this feature.... im looking forward to use 100% OO Calc in the company i work for but i realy need this feature.
in order to be more specific wanna say that actualy there are 1 builder and 2 users of the sheet...any user with its own range of cells password protected so user1 can edit only range c1:c8 that it's password fits and user2 can edit range d1:d8 that it's password fits without being able none of them to edit other parts of the protected sheet.
one for requirements