Version: (using KDE Devel) Installed from: Compiled sources Chapter 2 KSpread Basics, Recalculation says: "If the Automatic recalculation box in the Preferences page of the Settings->Configure KSpread... dialog box is checked, KSpread will recalculate the values of cells whenever anything that affects them is changed." But there is no Automatic recalculation box and no Preferences page in KSpread's Configure dialog, so this sentence is wrong! In Format->Sheet->Sheet Properties menu there is a box "Automatic recalculation", to enable/disable this for each sheet. But is there a way to do this for all sheets (the whole document) at once? This needs some clarification in Chapter 2 KSpread Basics, Recalculation
Created attachment 14463 [details] proposed patch however unchecking the option in Sheet Properties still makes it automatically recalulate...
the description of the gui is ok, but I can confirm that checking or unchecking this option has no effect, tested with the latest kspread from trunk
OK, i made a bug report to get the Automatic recalculation option fixed see http://bugs.kde.org/show_bug.cgi?id=121104 In the meanwhile I'll commit the patch to the doc
SVN commit 504319 by annma: commit patch to 121066 but leave this bug open in case some precisions need to be addedlater when Automatic recalculation is fixed CCBUG=121066 M +5 -4 basics.docbook --- trunk/koffice/doc/kspread/basics.docbook #504318:504319 @@ -387,11 +387,12 @@ <sect2 id="recalc"> <title>Recalculation</title> -<para>If the <guilabel>Automatic recalculation</guilabel> box in the <guilabel> -Preferences</guilabel> page of the <menuchoice><guimenu>Settings</guimenu> -<guisubmenu>Configure KSpread...</guisubmenu></menuchoice> dialog box is +<para>If the <guilabel>Automatic recalculation</guilabel> box in the +<menuchoice><guimenu>Format</guimenu> +<guisubmenu>Sheet</guisubmenu><guisubmenu>Sheet Properties</guisubmenu> +</menuchoice> dialog box is checked, &kspread; will recalculate the values of cells whenever anything that -affects them is changed.</para> +affects them is changed in the sheet.</para> <para>You can instruct &kspread; to perform a recalculation at any time by using the <guimenuitem>Recalculate Sheet</guimenuitem> or <guimenuitem> Recalculate Document</guimenuitem> options in the <guimenu>Tools</guimenu>
SVN commit 504360 by annma: add precision bug is fixed for Automatic recalculation! :-) BUG=121066 M +2 -2 basics.docbook --- trunk/koffice/doc/kspread/basics.docbook #504359:504360 @@ -393,9 +393,9 @@ </menuchoice> dialog box is checked, &kspread; will recalculate the values of cells whenever anything that affects them is changed in the sheet.</para> -<para>You can instruct &kspread; to perform a recalculation at any time by +<para>When <guilabel>Automatic recalculation</guilabel> is not checked for the current sheet, you can instruct &kspread; to perform a recalculation at any time by using the <guimenuitem>Recalculate Sheet</guimenuitem> or <guimenuitem> -Recalculate Document</guimenuitem> options in the <guimenu>Tools</guimenu> +Recalculate Document</guimenuitem> option in the <guimenu>Tools</guimenu> menu or their shortcuts <keycombo action="simul">&Shift;<keysym>F9</keysym> </keycombo> or <keysym>F9</keysym>.</para> </sect2>