Thanks for the information Brian. I have tried the procedure you outlined using the document provided by Ahamed. Prior to being able to change any options such as cell protection, the entire sheet must be Unprotected. This requires no password at first. I'm still not sure if it should, as the document Ahamed provided is .xls and may or may not have a password.
After removing the sheet protection, individual cells or ranges of cells may be protected or not. In the document provided by Ahamed it appears that all cells are marked protected. After following the procedure (two attempts were required to succeed) and reapplying the sheet protection, the desired operation is achieved; The first three columns are protected as if they were static data, and the remaining columns can be modified as if they were a working document. So the only question which remains for me, is if the program should ask for a password prior to unprotecting the sheet. As has been suggested by others addressing concerns such as this, it may be an issue with MSO2k3 not protecting the document properly in the first place. Is there any fix for this? It seems like a heavy concern for users of the software. Can someone who has access to MSO2k3 and other versions please test whether the password is stripped after the proprietary document format is opened and modified by OOo? This discussion should be moved to a pertinent issue. On Thu, Oct 29, 2009 at 1:27 PM, Brian Barker <b.m.bar...@btinternet.com> wrote: > At 13:10 29/10/2009 -0700, Gallomimia Noname wrote: >> >> I cannot find any way to protect only a given range of cells with OOoCalc. > > o Select relevant cell ranges and go to Format | Cells... | Cell Protection > | Protection (or right-click | Format Cells... | Cell Protection | > Protection) and tick Protected - or not - as required. > o Now go to Tools | Protect Document > | Sheet... to protect the entire > sheet. Now some cell ranges are protected and others not. > >> I do believe there is an issue in the issue tracker open on this subject. >> Some have said that the issue does not exist, but I can see that it does. > > If I understand you correctly, I fear they are right. > > I trust this helps. > > Brian Barker > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
