Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | More possibilities to specify permissions on protecting a sheet | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | cno | ||||
Component: | code | Assignee: | AOO issues mailing list <issues> | ||||
Status: | ACCEPTED --- | QA Contact: | |||||
Severity: | Trivial | ||||||
Priority: | P3 | CC: | issues, khirano, kyoshida, mhillat, oooforum, tommym.carver | ||||
Version: | OOo 2.0.4 | ||||||
Target Milestone: | --- | ||||||
Hardware: | All | ||||||
OS: | All | ||||||
Issue Type: | PATCH | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Issue Depends on: | 97515 | ||||||
Issue Blocks: | |||||||
Attachments: |
|
Description
cno
2006-11-12 20:50:51 UTC
Set to new Created attachment 45879 [details]
patch
This patch does part of the internal heavy lift to implement this feature. I had to work on this recently for our Novell customers. What the patch does is 1) Imports and exports relevant sheet protection options from and to an Excel document, 2) Stores the sheet protection options internally so that Calc core can access that information as needed, and 3) Use that information to restrict cell selection behaviors. For this, "select (un)locked cells" options are used to control the behavior. What still needs to be done going forward: 1) Utilize the remaining sheet protection options, such as allow/disallow autofilters etc. and manipulate the relevant Calc behaviors when the sheet is protected, and 2) Create a nice UI for it. -> user experience / specification requirements? For the record, all of the options that Cor listed are loaded, stored, and saved in this patch. for the record: great news, Kohei :-) Hi Niklas, please have a look at this one and proceed as needed. Frank Apart from what you mention, also missing is load & save to ODS, including specification. It's nice to have this as a starting point for a complete implementation, but it's not something that can be handled as a patch. I've created the scsheetprotection01 CWS for this. http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fscsheetprotection01 I'm taking this. starting it. change target from 2.x to 3.x according to http://wiki.services.openoffice.org/wiki/Target_3x From my prospective, I can initially implement: - Select locked cells - Select unlocked cells and take care of the rest of the options at a later time. *** Issue 101940 has been marked as a duplicate of this issue. *** Just to update, the ODF file format change is still under review and not yet finalized. Here is the file format change proposal for the interested: http://wiki.oasis-open.org/office/Spreadsheet_Table_Protection_Options Meanwhile, scsheetprotection02 which includes refactoring of Calc code in preparation for this feature is pending QA (has been for a month now). Do you have some news about your proposal to OASIS? Pending since july 2008... Reset assignee on issues not touched by assignee in more than 1000 days. Set this issue as PATCH I don't know if it can be commited with AOO 4.x *** Issue 127532 has been marked as a duplicate of this issue. *** (In reply to oooforum (fr) from comment #17) > Set this issue as PATCH > I don't know if it can be commited with AOO 4.x Answer's dev: attached patch that belongs to comment 12 is already integrated. There is development work to do. |