This is the same in OpenOffice.org, LibreOffice, Excel, Gnumeric and
other spreadsheet programs.
menu:Tools>Protection>Sheet=OFF opens the locks of all the cells on that
sheet having a lock attached. Now you can edit any cell.
Format>Cells>Tab:Protection allows you to add or remove a lock to
selected cells. Cells without a lock remain editable when sheet
protection closes all cell locks.
By default all cells have a lock, so the sheet protection locks all
cell. You have to remove the locks from those cells you want to keep
editable.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
