| Summary: | new typos in kspread_advanced.po | ||
|---|---|---|---|
| Product: | [Websites] docs.kde.org | Reporter: | Natalie <nat> |
| Component: | general | Assignee: | Documentation Editorial Team <kde-doc-english> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | ||
| Priority: | NOR | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Platform: | Ubuntu | ||
| OS: | Linux | ||
| Latest Commit: | Version Fixed In: | ||
| Sentry Crash Report: | |||
|
Description
Natalie
2005-12-18 13:59:12 UTC
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 |