Jean-Michel Courat wrote:
In a spreadsheet,
A1 = 1
A2 = 2
Starting in A3, when doing with keystrokes
+
arrow up (going to A2)
+
arrow up (going to A1)
Enter
I obtain 3 in A3
When recording the macro the same way, I also obtain 3 in A3; great !!
But when executing the macro, I obtain a message error 523 in A1.
What am I doing wrong ?
Recording macros doesn't work very well, because it doesn't record what
you probably really want recorded, which is something that adapts to new
situations.
I did what you described. Here is part of the resulting macro
rem ----------------------------------------------------------------------
dim args6(0) as new com.sun.star.beans.PropertyValue
args6(0).Name = "StringName"
args6(0).Value = "=A1+A2"
dispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args6())
rem ----------------------------------------------------------------------
As you see it simply enters the original formula.
To create a more useful macro, you need to actually write one.
It sure would be nice if we had a robust macro-recorder in OOo that
would do a lot of the "writing" for us.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
