From ac14e9f39638b04aacc288c7b83e1df7388c35e4 Mon Sep 17 00:00:00 2001 From: Kurt Zenker Date: Fri, 7 Mar 2008 11:13:07 +0000 Subject: INTEGRATION: CWS hcshared17_DEV300 (1.7.92); FILE MERGED 2008/03/04 15:23:58 ufi 1.7.92.1: vor build --- .../source/text/scalc/guide/cell_protect.xhp | 110 ++++++++++----------- 1 file changed, 55 insertions(+), 55 deletions(-) (limited to 'helpcontent2') diff --git a/helpcontent2/source/text/scalc/guide/cell_protect.xhp b/helpcontent2/source/text/scalc/guide/cell_protect.xhp index 719c5e5775..1000642173 100755 --- a/helpcontent2/source/text/scalc/guide/cell_protect.xhp +++ b/helpcontent2/source/text/scalc/guide/cell_protect.xhp @@ -1,14 +1,15 @@ + - - + + + -Protecting Cells from Changes +Protecting Cells from Changes /text/scalc/guide/cell_protect.xhp - -Sun Microsystems, Inc. -FPE: Changed table to numbered list, cleanup deleted screenshot; dedr: reviewed - + + + protecting;cells and sheets cells; protecting cell protection; enabling @@ -57,50 +58,49 @@ changing; sheet protection hiding;formulas formulas;hiding -MW transferred "modifying;..." and "changing;..." into one index entry -Protecting Cells from Changes + + MW transferred "modifying;..." and "changing;..." into one index entry + Protecting Cells from Changes -%PRODUCTNAME provides several options to protect the data in a spreadsheet. - - -You can protect the cell contents and formats from changes. - - -You can protect the spreadsheet structure from changes, for example the count, names, and order of the sheets. - - - - -Select the cells that you want to specify the cell protection options for. - - -Choose Format - Cells and click the Cell Protection tab. - - -Select the protection options that you want. -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. - - -Click OK. - - -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 Document - Sheet. -To protect the structure of the document, for example the count, names, and order of the sheets, from being changed, choose Tools - Protect Document - Document. - - -(Optional) Enter a password. -If you forget your password, you cannot deactivate the protection. If you only want to protect cells from accidental changes, set the sheet protection, but do not enter a password. - - -Click OK. - - -
- - -
- + In %PRODUCTNAME 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 table. 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 table and save the document. + These protection features are just switches to prevent accidental action. The features are not intended to provide any secure protection. For example, by exporting a sheet to another file format, a user may be able to surpass the protection features. There is only one secure protection: the password that you can apply when saving an OpenDocument file. A file that has been saved with a password can be opened only with the same password. + + + Select the cells that you want to specify the cell protection options for. + + + Choose Format - Cells and click the Cell Protection tab. + + + Select the protection options that you want. + 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. + + + Click OK. + + + 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 Document - Sheet. + To protect the structure of the document, for example the count, names, and order of the sheets, from being changed, choose Tools - Protect Document - Document. + + + (Optional) Enter a password of at least 5 characters. + If you forget your password, you cannot deactivate the protection. If you only want to protect cells from accidental changes, set the sheet protection, but do not enter a password. + + + Click OK. + + +
+ + + + + +
+ -- cgit