To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=107713 Issue #|107713 Summary|Cell protection bypassed by AutoInput Component|Spreadsheet Version|OOo 2.0.4 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|formatting Assigned to|spreadsheet Reported by|professor_frink
------- Additional comments from professor_fr...@openoffice.org Wed Dec 16 09:41:56 +0000 2009 ------- With AutoInput activated (From the Tool menu, select cell contents, then ensure that there is a tick to the left of "AutoInput"), I protected a cell: -Right click on the cell, select 'Format Cells...' -Select "Cell protection" tab, click on "Hide all" & "Hide when printing" check boxes. Click OK -From the Tools menu, select "Protect Documents," then select "Sheet" -Enter and confirm password. By typing the first letter of the protected cell in a different cell in the same column (or by trial and error, typing each letter in turn), the text in the protected cell will be displayed. On this occasion, it allowed me as the author to bypass the cell protection, as I had forgotten the password (although I suspect it was corrupted, since every possible password didn't work) but in other circumstances, this would appear to be a possible security risk. Other less significant but annoying problems with the cell protection feature is that it affects the whole sheet: it seems to be impossible to insert cells anywhere on the sheet and any new cells formed by deleting cells are automatically protected. It seems as thought it would be better if individual cells could be protected without the rest of the sheet being affected. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org