TerryJ wrote:
> Mathias Bauer wrote:
>> TerryJ wrote:
>>
>>> An example of its use would be to have the script navigate to various
>>> locations in the spreadsheet and pause for input by the user at each
>>> location.
>>
>> Waiting is bad - it creates a loop that can cause reentrance problems.
>> It's better to end macro execution and install a listener for an event
>> to be triggered by user input. Perhaps if you described what kind of
>> user input you are talking about we could find out which listener is
>> possible.
>
> Thank you for the reply. I was hoping for a solution suitable for more
> general use.
>
> Typically, some data is typed and the ENTER (return) key is used to
> place it in the cell.
>
> The ENTER key will be used each time data is entered but the desired
> result is that the cell pointer would then move to the next location in
> the series, not to the same location each time.
>
> I suppose you would need to install and remove the listener on each
> occasion. {?} was so much simpler and seemed to have no undesirable
> results - no loops and no difficulty proceeding. It was in use for many
> years in Lotus 123 and, evidently, in QuattroPro, so there was nothing
> shonky about it.
It should be enough to install a single, permanent listener. I'm not a
Calc expert, perhaps a "SelectionChangedListener" (how ever it is named)
or something else is available to achieve this. Perhaps a Calc expert
drops by here to give more detailed advice.
Ciao,
Mathias
--
Mathias Bauer (mba) - Project Lead OpenOffice.org Writer
OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS
Please don't reply to "[EMAIL PROTECTED]".
I use it for the OOo lists and only rarely read other mails sent to it.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
