Re: Pause execution of script for user input into spreadsheet

Hi,
If you write in StarBasic you may have a look at function 
InputBox(msg,title,default,x,y). It returns an empty string
on cancel, 
which may be handled with a msgbox (skip,cancel,repeat?).

You may use the returned value for setting property
FormulaLocal of the 
cell in question. Setting a cell's FormulaLocal is more or
less like 
typing the string into the cell, including
date/time-conversion, 
TRUE/FALSE, localized function-names and so on.

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org