Protecting Cells from Changes

In LibreOffice Calc you can protect sheets and the document as a whole. You can choose whether the cells are protected against accidental changes, whether the formulas can be viewed from within Calc, whether the cells are visible or whether the cells can be printed.

Protection can be provided by means of a password, but it does not have to be. If you have assigned a password, protection can only be removed once the correct password has been entered.

Note that the cell protection for cells with the Protected attribute is only effective when you protect the whole sheet. In the default condition, every cell has the Protected attribute. Therefore you must remove the attribute selectively for those cells where the user may make changes. You then protect the whole sheet and save the document.

Hoiatav ikoon

Need kaitse võimalused on lihtsalt kaitseks juhusliku tegevuse eest ega ole mõeldud turvalise kaitse pakkumiseks. Näiteks salvestamisel teise vormingusse saab kasutaja taolisest kaitsest mööda hiilida. Turvaliseks kaitsmiseks on ainult üks võimalus: OpenDocument-faili salvestamine parooliga. Parooliga salvestatud faili saab avada ainult sama parooli kasutades.

  1. Vali lahtrid, millele soovid kaitsmise sätteid määrata.

  2. Choose Format - Cells and click the Cell Protection tab.

  3. Select the protection options that you want. All options will be applied only after you protect the sheet from the Tools menu - see below.

    Uncheck Protected to allow the user to change the currently selected cells.

    Select Protected to prevent changes to the contents and the format of a cell.

    Select Hide formula to hide and to protect formulas from changes.

    Select Hide when printing to hide protected cells in the printed document. The cells are not hidden onscreen.

  4. Click OK.

  5. Apply the protection options.

    To protect the cells from being changed / viewed / printed according to your settings in the Format - Cells dialog, choose Tools - Protect Sheet.

    To protect the structure of the document, for example the count, names, and order of the sheets, from being changed, choose Tools - Protect Spreadsheet.

  6. (Optional) Enter a password.

    Hoiatav ikoon

    Parooli unustamise korral ei saa kaitset maha võtta. Kui soovid lehte kaitsta ainult juhuslike muudatuste eest, määra leht kaitstuks, kuid ära sisesta parooli.

  7. Click OK.