Apache OpenOffice (AOO) Bugzilla – Issue 95744
Macro recording problems with arrow-keys in formula
Last modified: 2013-01-29 21:47:50 UTC
1. Record macro 2. Type 1 + Enter 3. Type 2 + Enter (You are now in cell A3) 4. Type =, Type Up (=A2) 5. Type +, Type Up Type Up + Enter (=A2+A1) in A3 6. Stop record macro When you playback macro it doesn't do the same (error).
Can confirm with OOo 3.0 (OOO300m9) and OOo 2.4.1. Problem seems to be, that using the arrow-keys for entering a cell reference is erroneously recorded as using the arrow-keys before starting to enter the formula. davidhoria, please indicate your OOo version.
I tried all OO versions including 3 beta and the problem is the same.
The recorded macro loses the reference to the formula target cell, placing the result in the position of the last cell movement by use of the arrow key. I tried several different macros that started the use of the arrow keys in different positions. It always places the formula in the last position selected by an arrow key. TomW
Followup: It occurred to me, just after my previous post, to try this out in Excel 2003. I recorded the macro verbatum. Saved the file, opened it in OOo 3.0 then saved it as an ods file. The macro runs correctly. Go figure! TomW