Issue 65455 - missing an important feature in spreadsheet
Summary: missing an important feature in spreadsheet
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.2
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2006-05-16 14:56 UTC by srdjan2oo2
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description srdjan2oo2 2006-05-16 14:56:58 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.
Comment 1 srdjan2oo2 2006-05-16 15:02:51 UTC
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.
Comment 2 frank 2006-05-17 10:51:51 UTC
one for requirements