To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=105743 Issue #|105743 Summary|F9 recalculates changed formulas in ALL sheets Component|Spreadsheet Version|OOO310m11 Platform|PC URL| OS/Version|Windows Vista Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|ui Assigned to|spreadsheet Reported by|cassioneri
------- Additional comments from cassion...@openoffice.org Thu Oct 8 19:16:08 +0000 2009 ------- 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 --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org
