Question about record macro in calc

View: New views
2 Messages — Rating Filter:   Alert me  

Question about record macro in calc

by SlumberMan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi, all
In calc, after starting Record Macro, I press CTRL+Click to select more
than one sheet to edit simultaneously. But in the recorded macro, this
operation is omitted and the *operational objectives* becomes "Nr",
which means the current cursor.
Is this on purpose? TIA

    rem
----------------------------------------------------------------------
    dim args1(0) as new com.sun.star.beans.PropertyValue
    args1(0).Name = "Nr"
    args1(0).Value = 1

    dispatcher.executeDispatch(document, ".uno:JumpToTable", "", 0, args1())
    rem
----------------------------------------------------------------------


--
===========================================
Yuelin Zhuang   --   Testing 3, RedFlag2000
MSN :                 doze_worm@...
E-mail:          zhuangyuelin@...
===========================================


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...


Re: Question about record macro in calc

by SlumberMan :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

SlumberMan wrote:

> Hi, all
> In calc, after starting Record Macro, I press CTRL+Click to select
> more than one sheet to edit simultaneously. But in the recorded macro,
> this operation is omitted and the *operational objectives* becomes
> "Nr", which means the current cursor.
> Is this on purpose? TIA
>
>    rem
> ----------------------------------------------------------------------
>    dim args1(0) as new com.sun.star.beans.PropertyValue
>    args1(0).Name = "Nr"
>    args1(0).Value = 1
>
>    dispatcher.executeDispatch(document, ".uno:JumpToTable", "", 0,
> args1())
>    rem
> ----------------------------------------------------------------------
Maybe I'm not clear myself of the question. I mean that Record Macro
cannot record the operation of selecting several sheets, and meanwhile a
recorded macro cannot run on several sheets without select the sheets by
Ctrl+Click manually at the running time. Is that intended?

--
===========================================
Yuelin Zhuang   --   Testing 3, RedFlag2000
MSN :                 doze_worm@...
E-mail:          zhuangyuelin@...
===========================================


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@...
For additional commands, e-mail: dev-help@...