Issue 105743 - F9 recalculates changed formulas in ALL sheets
Summary: F9 recalculates changed formulas in ALL sheets
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOO310m11
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-10-08 20:16 UTC by cassioneri
Modified: 2014-01-07 18:26 UTC (History)
2 users (show)

See Also:
Issue Type: PATCH
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Patch for issue 105743 (1.00 KB, text/plain)
2009-11-15 16:48 UTC, cassioneri
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description cassioneri 2009-10-08 20:16:08 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
Comment 1 cassioneri 2009-11-15 16:48:55 UTC
Created attachment 66134 [details]
Patch for issue 105743
Comment 2 cassioneri 2009-11-15 17:07:27 UTC
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).
Comment 3 cassioneri 2009-12-12 09:05:18 UTC
Change issue type to PATCH.
Comment 4 Rob Weir 2013-03-11 14:59:07 UTC
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:


Comment 5 Edwin Sharp 2014-01-07 18:26:05 UTC
As given in description.

AOO410m1(Build:9750)  -  Rev. 1555399
2014-01-06_04:13:46 - Rev. 1555657