Issue 9769

Summary:	macro error with sheet navigation in formula
Product:	Calc	Reporter:	mdevenish <mike>
Component:	ui	Assignee:	AOO issues mailing list <issues>
Status:	ACCEPTED ---	QA Contact:
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	644
Target Milestone:	---
Hardware:	PC
OS:	Linux, all
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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

Confirmed.
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 OpenOffice.org roadmap
(http://tools.openoffice.org/releases) 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 "issues@openoffice.apache.org".