Issue 9769 - macro error with sheet navigation in formula
Summary: macro error with sheet navigation in formula
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 644
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
: 17396 34722 (view as issue list)
Depends on:
Reported: 2002-12-02 21:46 UTC by mdevenish
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description mdevenish 2002-12-02 21:46:34 UTC
When recording a macro, the macro doesn't navigate sheets correctly when a 
sheet other than the active sheet is selected within a formula. For example:

From blank spreadsheet with 3 sheets
Start recording macro
type 1 in cell A1 of sheet 1, press enter (cell a2 of sheet 1 is selected)
select sheet 2
in cell A1 (of sheet 2) type = then select sheet1 cell A1, press enter
stop macro recorder
the formula "=sheet1.a1" is in cell A1 of sheet 2
clear all values from both sheet 1 and sheet 2
when the macro is run, the value 1 is in cell A1 of sheet 1 but the formula
"=sheet1.a1" is in cell A2 of sheet 1 instead of cell A1 of sheet 2
Comment 1 peter.junge 2003-04-10 19:05:06 UTC
@Skotti: Could you have a look please.
Comment 2 joerg.skottke 2003-04-15 10:39:30 UTC
Quick reproduction: record switch to Sheet2, insert =Sheet1.A1 in cell
A1. Stop recording, replay.

uno.jumptotable is recorded but is not replayed correctly.
Comment 3 niklas.nebel 2003-04-23 09:16:17 UTC
Cursor movement during formula input should not be recorded.
Comment 4 niklas.nebel 2003-09-11 15:29:49 UTC
This should have target "later".
Comment 5 niklas.nebel 2003-09-16 11:16:44 UTC
*** Issue 17396 has been marked as a duplicate of this issue. ***
Comment 6 oc 2003-10-02 11:31:49 UTC
According to the roadmap
( this issue was retargeted to
OOo Later.
Comment 7 niklas.nebel 2004-09-28 13:30:26 UTC
*** Issue 34722 has been marked as a duplicate of this issue. ***
Comment 8 ped 2005-10-25 06:52:28 UTC
I have even simpler problem.

When I record macro with entering some data into cell ending with "Enter", I get
cursor moved one cell down. When I stop macro recording right now, and replay
it, the movement to cell down is missing.

When I record same macro with Tab, it moves cursor right, then I go left, down
and stop macro.
Replay will Enter value, and move only left, down (the "right" from tab is
missing too).

Version OOo 1.9.125
Comment 9 Marcus 2017-05-20 11:13:39 UTC
Reset assigne to the default "".