Hi Gianpiero, On Saturday, 2009-01-31 14:24:48 -0800, Gianpiero Napoli wrote:
> I need the position to update the cell. > > Let say that I have a thread that get some data from somewhere > (socket/file/etc...) and I have a function TakeMyData(int Id). > I want to updtate this cell (the caller) every time i have a new data sample. > > So I need: > - to store the position of the cell somewhere. > - every time I get a new data with Identifier == id i want to update > this cell maybe calline Changing spreadsheet content during execution of an Add-In function is a no-no anyway.. However, there's a solution for this: let your function return a XVolatileResult, see http://api.openoffice.org/docs/common/ref/com/sun/star/sheet/AddIn.html http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Spreadsheet_Add-Ins http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Spreadsheets/Variable_Results The cell formula containing the asynchronous Add-In function will be recalculated when a change is broadcasted and the formula result needs to be accessed. Eike -- PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication. Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
pgpvIIzu00Mwk.pgp
Description: PGP signature
