Re: [Re: [dev] Changing cell values from custom sheet function]

2005-08-01 Thread G. Jasper
Eike Rathke wrote: Hi G., On Fri, Jul 29, 2005 at 23:33:50 +0200, G. Jasper wrote: A cell supports methods to install different listeners. I used addChartDataChangeEventListener( ). Niklas refers to an addModifyListener. I didn't try that. Don't get confused by the ChartDataChange part. I

Re: [Re: [dev] Changing cell values from custom sheet function]

2005-08-01 Thread Eike Rathke
Hi G., On Fri, Jul 29, 2005 at 23:33:50 +0200, G. Jasper wrote: > A cell supports methods to install different listeners. > I used addChartDataChangeEventListener( ). > Niklas refers to an addModifyListener. I didn't try that. > Don't get confused by the ChartDataChange part. It doesn't need a c

[Re: [dev] Changing cell values from custom sheet function]

2005-07-29 Thread G. Jasper
I am afraid I sent this to the wrong list first. I am sorry. Niklas Nebel wrote: Matthias Benkmann wrote: It seems that when I use a custom Basic function in a cell formula, during the executing of this function, I can't write to any cells. Statements such as ThisComponent.Sheets.getByIndex

Re: [dev] Changing cell values from custom sheet function

2005-07-29 Thread Eike Rathke
Hi Andrew, On Wed, Jul 27, 2005 at 20:56:10 -0400, Andrew Douglas Pitonyak wrote: > I thought that this was only true for the sheet that contained the cell > that called the function.. Which is an implementation detail that may change at any time without further notice. Note that you're able to

Re: [dev] Changing cell values from custom sheet function

2005-07-27 Thread Andrew Douglas Pitonyak
Matthias Benkmann wrote: It seems that when I use a custom Basic function in a cell formula, during the executing of this function, I can't write to any cells. Statements such as ThisComponent.Sheets.getByIndex(0).getCellByPosition(4,1).setValue(33) are silently ignored. Why does this happen?

Re: [dev] Changing cell values from custom sheet function

2005-07-26 Thread Niklas Nebel
Matthias Benkmann wrote: It seems that when I use a custom Basic function in a cell formula, during the executing of this function, I can't write to any cells. Statements such as ThisComponent.Sheets.getByIndex(0).getCellByPosition(4,1).setValue(33) are silently ignored. Why does this happen? I

[dev] Changing cell values from custom sheet function

2005-07-26 Thread Matthias Benkmann
It seems that when I use a custom Basic function in a cell formula, during the executing of this function, I can't write to any cells. Statements such as ThisComponent.Sheets.getByIndex(0).getCellByPosition(4,1).setValue(33) are silently ignored. Why does this happen? Is there a way around it? I'