Version: (using KDE KDE 3.5.0) Installed from: Ubuntu Packages OS: Linux kspread_advanced.po advanced.docbook:491,530 - When a document is protected, the user may not: - When a sheet is protected, the user may not: - Could "the user" be changed to "you"? Personal note: I don't like reading manuals that explain what "the user" can or cannot do. I prefer manuals that talk directly to me. advanced.docbook:523 - </menuchoice>.A dialog appears - Missing space. advanced.docbook:523 - (such as titles).So you - Missing space. advanced.docbook:567 - Select the entire spreadsheet with the mouse. - Whaaaa! Did you _try_ that? Even when you select entire rows or columns, it takes a looong time... There should be an easier way, like a menu item: Edit - Select All In OOo calc you can also click in the upper left corner to select all cells at once. I haven't been able to find such a feature in KSpread... advanced.docbook:582 - To protect a range of selected cells, or to protect non-adjacent cells: and advanced.docbook:567 - Hold down the Ctrl key while clicking on the non-adjacent cells to highlight the ones that are to be protected. - To select a range of cells, you don't need to hold the Ctrl key. To select non-adjacent cells... this does not work. Is this a new 1.5 feature? advanced.docbook:601 - that mans you must protect the entire sheet for the cell to ba effectively protected: - mans > means; ba > be advanced.docbook:614 - Protected cells in a protected sheet cannot be edited without unprotecting the whole sheet, and other sheet changes are disabled. - Somehow the "and other ..." seems illogical to me. Maybe: sheet. All other sheet changes are disbled as well. ? advanced.docbook:638 - To hide the current cell formula or the selected cells formulae, select the appropriate cell or range - It seems useless to select the selected cells... "or the desired cells" ? advanced.docbook:638 - (<guilabel>Protected</guilabel> is uncheck) - uncheck > unchecked
advanced.docbook:567 - Select the entire spreadsheet with the mouse. - Whaaaa! Did you _try_ that? Even when you select entire rows or columns, it takes a looong time... There should be an easier way, like a menu item: Edit - Select All In OOo calc you can also click in the upper left corner to select all cells at once. I haven't been able to find such a feature in KSpread... ;-) yes i tried! There is no other way, a Select All button should be implemented but there are painting issues that makes it impossible. I press hard to get this fixed and have this feature in!
- To select a range of cells, you don't need to hold the Ctrl key. To select non-adjacent cells... this does not work. yes, you are right it does not (it works on oocalc and I did not check thoroughly in KSpread). I'll change the wording.
SVN commit 490458 by annma: fix bug 118566 update to keep synch with Protection tab new layout BUG=118566 M +15 -17 advanced.docbook M cellformat6.png M +23 -6 format.docbook --- trunk/koffice/doc/kspread/advanced.docbook #490457:490458 @@ -488,7 +488,7 @@ </textobject> </mediaobject> </para> -<para>When a document is protected, the user may not:</para> +<para>When a document is protected, you may not:</para> <itemizedlist> <listitem><para> Rename a sheet @@ -522,12 +522,12 @@ linkend="cell-protection">next section</link>.</para> <para>To protect a sheet, 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 -will be your password.</para> +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 will be 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> +<para>When a sheet is protected, you may not:</para> <itemizedlist> <listitem><para> Insert any object or chart @@ -559,7 +559,7 @@ must be turned off for all other cells. For example you might want most cells to accept user input so you will uncheck <guilabel>Protected</guilabel> for those and choose to keep protected cells that should stay unchanged (such as -titles).So you need 3 steps in order to protect only some cells: unprotect all +titles). So you need 3 steps in order to protect only some cells: unprotect all the cells, select the cells to protect and protect them and then protect the whole sheet.</para> <para>To unprotect all the cells:</para> @@ -579,11 +579,10 @@ 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> +<para>To protect a range of selected 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. +Highlight the range of cells that are to be protected. </para></listitem> <listitem><para> When all of the desired cells are selected, go to @@ -599,8 +598,8 @@ </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> +enabled at the sheet level, that means you must protect the entire sheet for the +cell to be effectively protected:</para> <itemizedlist> <listitem><para> Select @@ -613,7 +612,7 @@ </para></listitem> <listitem><para> Protected cells in a protected sheet cannot be edited without unprotecting the -whole sheet, and other sheet changes are disabled. For example, no one can +whole sheet, and any sheet changes are disabled. For example, no one can insert rows or columns, change column width, or create embedded charts. </para></listitem> </itemizedlist> @@ -635,9 +634,8 @@ </textobject> </mediaobject> </para> -<para>To hide the current cell formula or the selected cells formulae, select -the appropriate cell or range and then choose the -<menuchoice><guimenu>Format</guimenu><guimenuitem>Cell +<para>To hide cell formulae, select the appropriate cell or range of cells and +then choose the <menuchoice><guimenu>Format</guimenu><guimenuitem>Cell Format...</guimenuitem></menuchoice> menu. In the Cell format dialog, click the Protection tab and select <guilabel>Hide formula</guilabel>. After you protect the sheet, the results of the formulae will be visible, but @@ -686,7 +684,7 @@ choosing <guilabel>Hide all</guilabel> in the Cell Protection tab in the <menuchoice><guimenu>Format</guimenu><guimenuitem>Cell Format...</guimenuitem></menuchoice> menu. In the screenshot below, the -cell itself is not protected (<guilabel>Protected</guilabel> is uncheck) thus +cell itself is not protected (<guilabel>Protected</guilabel> is unchecked) thus the cell content can be changed.</para> <para> <mediaobject> --- trunk/koffice/doc/kspread/format.docbook #490457:490458 @@ -443,6 +443,28 @@ section</link>.</para> <variablelist> <varlistentry> +<term><guilabel>Hide all</guilabel></term> +<listitem><para>This hides the cell content and works only when the sheet is +protected which means that changing the <guilabel>Hide all</guilabel> +attribute of a cell has no effect unless the sheet is protected. Whether the +cell itself is protected or not does not matter.</para> +<para> +<mediaobject> +<imageobject> +<imagedata fileref="cellformat7.png" format="PNG"/> +</imageobject> +<textobject> +<phrase>Hide all.</phrase> +</textobject> +</mediaobject> +</para> +<para>When <guilabel>Hide +all</guilabel> is selected, Protected and Hide formula are disabled as when the +sheet is protected <guilabel>Hide all</guilabel> hides the cell content and the +formula and thus masks and protects the cell content.</para> +</listitem> +</varlistentry> +<varlistentry> <term><guilabel>Protected</guilabel></term> <listitem><para>If checked, the cell content will be protected. This is the default behaviour. You need to protect the whole sheet using the @@ -460,13 +482,8 @@ sheet must be protected for this to work.</para> </listitem> </varlistentry> + <varlistentry> -<term><guilabel>Hide all</guilabel></term> -<listitem><para>This hides the cell content and works only when the sheet is -protected. Whether the cell itself is protected or not does not matter.</para> -</listitem> -</varlistentry> -<varlistentry> <term><guilabel>Do not print text</guilabel></term> <listitem><para>If you check <guilabel>Do not print text</guilabel> then the text in the cell will not be printed. This is unchecked per default which means