Apache OpenOffice (AOO) Bugzilla – Issue 9769
macro error with sheet navigation in formula
Last modified: 2017-05-20 11:13:39 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
@Skotti: Could you have a look please.
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.
Cursor movement during formula input should not be recorded.
This should have target "later".
*** Issue 17396 has been marked as a duplicate of this issue. ***
According to the OpenOffice.org roadmap (http://tools.openoffice.org/releases) this issue was retargeted to OOo Later.
*** Issue 34722 has been marked as a duplicate of this issue. ***
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
Reset assigne to the default "issues@openoffice.apache.org".