[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-commits
Subject:    koffice/doc/kspread
From:       Anne-Marie Mahfouf <annma () kde ! org>
Date:       2005-11-29 17:52:58
Message-ID: 1133286778.342171.14622.nullmailer () svn ! kde ! org
[Download RAW message or body]

SVN commit 484183 by annma:

add a section about Protection


 M  +129 -0    advanced.docbook  
 AM            cellprotection1.png  
 AM            cellprotection2.png  


--- trunk/koffice/doc/kspread/advanced.docbook #484182:484183
@@ -448,6 +448,134 @@
 Handbook.</para>
 </sect1>
 
+<sect1 id="protection">
+<title>Protection</title>
+
+<sect2 id="doc-protection">
+<title>Document protection</title>
+<para>Protecting the document means that without the password a user cannot add or \
delete sheets. Document protection does not protect cells.</para> +<para>Select \
<menuchoice><guimenu>Tools</guimenu><guimenuitem>Protect \
Document</guimenuitem><guimenuitem>Protect Doc...</guimenuitem></menuchoice>. A \
dialog appears asking you for a password. The Password strength meter indicates if \
your password is secure enough. The longer the indicator is, the more secure your \
password.</para> +<para>
+<mediaobject>
+<imageobject>
+<imagedata fileref="cellprotection1.png" format="PNG"/>
+</imageobject>
+<textobject>
+<phrase>The Protect Document dialog</phrase>
+</textobject>
+</mediaobject>
+</para>
+<para>That password will then be required to unprotect the document.</para>
+<para>
+<mediaobject>
+<imageobject>
+<imagedata fileref="cellprotection2.png" format="PNG"/>
+</imageobject>
+<textobject>
+<phrase>The Unprotect Document dialog</phrase>
+</textobject>
+</mediaobject>
+</para>
+<para>When a document is protected, the user may not:</para>
+<itemizedlist>
+<listitem><para>
+Rename a sheet
+</para></listitem>
+<listitem><para>
+Insert a sheet
+</para></listitem>
+<listitem><para>
+Remove a sheet
+</para></listitem>
+<listitem><para>
+Hide a sheet
+</para></listitem>
+<listitem><para>
+Show a sheet
+</para></listitem>
+<listitem><para>
+See the sheet properties
+</para></listitem>
+</itemizedlist>
+</sect2>
+
+<sect2 id="sheet-protection">
+<title>Sheet protection</title>
+<para>Protecting a sheet means protecting the contents of all cells and objects on a \
worksheet. Protecting a sheet is protecting all cells in the sheet. Individual cells \
or a selection of cells can be unprotected without unprotecting the whole sheet, see \
<link linkend="cell-protection">next section</link>.</para> +<para>Select \
<menuchoice><guimenu>Tools</guimenu><guimenuitem>Protect \
Document</guimenuitem><guimenuitem>Protect Sheet...</guimenuitem></menuchoice>. A \
dialog appears asking you for a password. The Password strength meter indicates if \
your password is secure enough. The longer the indicator is, the more secure your \
password.</para> +<para>That password will then be required to unprotect the \
sheet.</para> +<para>When a sheet is protected, the user may not:</para>
+<itemizedlist>
+<listitem><para>
+Insert any object or chart
+</para></listitem>
+<listitem><para>
+Format any cell
+</para></listitem>
+<listitem><para>
+Insert a row or a column
+</para></listitem>
+<listitem><para>
+Edit and change cell content
+</para></listitem>
+<listitem><para>
+Change any content in the sheet
+</para></listitem>
+</itemizedlist>
+
+<note><para>Protecting a sheet is especially useful for preventing accidental \
erasure of formulae.</para></note> +</sect2>
+
+<sect2 id="cell-protection">
+<title>Cell or selected cells protection</title>
+<warning><para>Cell protection is active for all cells by default.</para></warning>
+<para>If you want only certain cells to be protected, this default protection must \
be turned off for all other cells. So you need 3 steps in order to protect only some \
cells: unprotect all the cells, select the cell to protect and protect them and then \
protect the whole sheet.</para> +<itemizedlist>
+<listitem><para>
+Select the entire spreadsheet with the mouse.
+</para></listitem>
+<listitem><para>
+In the menubar, select <menuchoice><guimenu>Format</guimenu><guimenuitem>Cell \
Format...</guimenuitem></menuchoice>.  +</para></listitem>
+<listitem><para>
+In the dialog that appears, go to the Cell Protection tab.
+</para></listitem>
+<listitem><para>
+Check <guilabel>Hide all</guilabel> and uncheck <guilabel>Protected</guilabel> to \
remove the protection on all cells. The cells are now all unprotected. \
+</para></listitem> +</itemizedlist>
+<para>To protect a range of selected cells, or to protect non-adjacent cells:</para>
+<itemizedlist>
+<listitem><para>
+Hold down the Ctrl key while clicking on the non-adjacent cells to highlight the \
ones that are to be protected. +</para></listitem>
+<listitem><para>
+When all of the desired cells are selected, go to the \
<menuchoice><guimenu>Format</guimenu><guimenuitem>Cell \
Format...</guimenuitem></menuchoice> menu. +</para></listitem>
+<listitem><para>
+In the dialog that appears, go to the Cell Protection tab.
+</para></listitem>
+<listitem><para>
+Click on the box next to <guilabel>Protected</guilabel> then click on \
<guibutton>OK</guibutton>. +</para></listitem>
+</itemizedlist>
+<para>Once the cells are marked for protection, the protection option must be \
enabled at the sheet level, that mans you must protect the entire sheet for the cell \
to ba effectively protected:</para> +<itemizedlist>
+<listitem><para>
+Select <menuchoice><guimenu>Tools</guimenu><guimenuitem>Protect \
Document</guimenuitem><guimenuitem>Protect Sheet...</guimenuitem></menuchoice>. \
+</para></listitem> +<listitem><para>
+In the dialog that appears, provide a safe password, then confirm it by typing it \
again. Click on <guibutton>OK</guibutton>. +</para></listitem>
+<listitem><para>
+The protected cells will now be uneditable and cannot be changed without \
unprotecting the whole sheet. +</para></listitem>
+</itemizedlist>
+</sect2>
+
+</sect1>
+
+
 <sect1 id="other">
 <title>Other Features</title>
 
@@ -528,6 +656,7 @@
 </sect2>
 
 </sect1>
+
 </chapter>
 
 <!--
** trunk/koffice/doc/kspread/cellprotection1.png #property svn:mime-type
   + application/octet-stream
** trunk/koffice/doc/kspread/cellprotection2.png #property svn:mime-type
   + application/octet-stream


[prev in list] [next in list] [prev in thread] [next in thread]