Hi Eike,
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
xSpreadsheet.getCellByPosition(positionStored).setFormun("TakeMyData(id)");
so I have two different issues: get the position of the caller cell
and force the update of the cell, in other words force the computation
of the TakeMyData function.
Can you help me?
Thanks a lot,
Gianpiero
On Sat, Jan 31, 2009 at 1:02 PM, Eike Rathke <[email protected]> wrote:
> Hi,
>
> On Wednesday, 2009-01-28 10:08:21 +0100, Daniel Rentz wrote:
>
>>> I want to know the name or the position of the cell that has called this
>>> function. Is it possibile? How I can do that?
>>
>> It is not possible, because there may not be a caller cell. Caller of a
>> function could be:
>>
>> - a cell formula
>> - a matrix formula (based on a cell range)
>> - a defined name (a.k.a. named range)
>> - a condition of a conditional formatting
>> - and in the near/far future also the condition of a data validation.
>
> All these formula expressions, at the time of being interpreted, do have
> some cell position associated though. However, the Add-In interface
> doesn't pass a position, and I'm not sure it should.
>
> Gianpiero, what would you need the cell position for?
>
> Eike
>
> --
> PGP/OpenPGP/GnuPG encrypted mail preferred in all private communication.
> Key ID: 0x293C05FD - 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
