Apache OpenOffice (AOO) Bugzilla – Issue 105743
F9 recalculates changed formulas in ALL sheets
Last modified: 2014-01-07 18:26:05 UTC
Related to issue #63693 According to help for "shortcut keys;spreadsheets" and "cell contents;recalculating" (and probably in other places): "Use Tools - Cell Contents - Recalculate or press F9 to recalculate all changed formulas in the CURRENT sheet." However F9 recalculates changed formulas in ALL sheets. To reproduce: 1. Open a blank spreadsheet. Disable auto calculation (Use Tools - Cells contents - AutoCalculate) 2. In Sheet1: Enter 1 in A1 and =A1 in B1 3. Repeat step 2 in Sheet2 4. In Sheet1: Change A1 to 2 5. Repeat step 4 in Sheet2 6. In Sheet2: Press F9 Then B1 in both sheets will change to 2. The same happens for OOo 3.0.0 (OOO300m9) running Linux. Obviously, changing the documentation fixes the problem. However, it would be useful beeing able to 1. Recalculate all changed formulas in the current sheet (I propose Shift+F9, as in Excel) 2. Recalculate all formulas in the current sheet
Created attachment 66134 [details] Patch for issue 105743
I've just sent a patch for this issue. It should be applied against changeset bec9b2b2628f (child of tag DEV_m64). This patch makes F9 recalculate all changed formulas in current sheet (and all formulas that they depend on). Notice that this is in accordance with OOo documentation and contrarily to my previous suggestion (to use Shift+F9). When working on this issue, I've noticed that the current visible tab is not kept up to date by ScDocument when we change the current sheet (either by clicking on another sheet or pressing Ctrl+PgUp/PgDn). I had to address this issue as well. Sorry, I didn't run regression tests (don't know how to do it).
Change issue type to PATCH.
I'm adding this comment to all open issues with Issue Type == PATCH. We have 220 such issues, many of them quite old. I apologize for that. We need your help in prioritizing which patches should be integrated into our next release, Apache OpenOffice 4.0. If you have submitted a patch and think it is applicable for AOO 4.0, please respond with a comment to let us know. On the other hand, if the patch is no longer relevant, please let us know that as well. If you have any general questions or want to discuss this further, please send a note to our dev mailing list: dev@openoffice.apache.org Thanks! -Rob
As given in description. AOO410m1(Build:9750) - Rev. 1555399 2014-01-06_04:13:46 - Rev. 1555657 Debian