Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-07-06 Thread Niklas Nebel
On 07/06/10 13:47, rashi dhing wrote: So does this mean that if I create a matrix formula range and call PushMatrix, I will have the result displayed on the sheet ? Yes, you get the same behavior as with the MUNIT function. See ScInterpreter::ScEMat for the implementation of MUNIT. Niklas -

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-07-06 Thread rashi dhing
Hi Eike, So does this mean that if I create a matrix formula range and call PushMatrix, I will have the result displayed on the sheet ? Thanks, Rashi On Tue, Jul 6, 2010 at 2:22 PM, Eike Rathke wrote: > Hi rashi, > > On Tuesday, 2010-07-06 12:40:35 +0300, rashi dhing wrote: > > > So I did por

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-07-06 Thread Eike Rathke
Hi rashi, On Tuesday, 2010-07-06 12:40:35 +0300, rashi dhing wrote: > So I did pore over the various functions of the ScInterpreter like GetNewMat > and PushMatrix etc. > Apart from being extremely complicated, I still really didn't understand > where the result matrix > was being set/put into th

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-07-06 Thread rashi dhing
So I did pore over the various functions of the ScInterpreter like GetNewMat and PushMatrix etc. Apart from being extremely complicated, I still really didn't understand where the result matrix was being set/put into the spreadsheet. I did create a matrix but now I don't know how to print the value

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-16 Thread Eike Rathke
Hi rashi, On Friday, 2010-06-04 14:10:31 +0300, rashi dhing wrote: > Hi Eike, Could you tell me why modifying the spreadsheet while interpreting > a function is not the right approach That could modify cells that are still to be interpreted, even for the same formula the modifying function is p

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-08 Thread Niklas Nebel
On 06/08/10 09:43, rashi dhing wrote: Thanks Niklas, will take a look at how array formulas work ! Can you tell me which modules to look at tho ? It depends on what you're really doing. Assuming that you're adding a function to ScInterpreter, take a look at GetNewMat/PushMatrix, and how they

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-08 Thread rashi dhing
Thanks Niklas, will take a look at how array formulas work ! Can you tell me which modules to look at tho ? Rashi On Mon, Jun 7, 2010 at 10:50 AM, Niklas Nebel wrote: > On 06/07/10 09:12, rashi dhing wrote: > >> I do need to display the result of my function in a range of cells. How >> can >> I

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-07 Thread Niklas Nebel
On 06/07/10 09:12, rashi dhing wrote: I do need to display the result of my function in a range of cells. How can I facilitate that in this scenario ? You can return an array and display it in an array formula (the kind of formula you get with Shift-Ctrl-Enter). Niklas -

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-07 Thread rashi dhing
Hi Eike, On Thu, Jun 3, 2010 at 6:47 PM, Eike Rathke wrote: > > > Modifying sheet content while interpreting functions is a big no-no. > Please don't do that. > I do need to display the result of my function in a range of cells. How can I facilitate that in this scenario ? Thanks, Rashi

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-04 Thread rashi dhing
Hi Eike, Could you tell me why modifying the spreadsheet while interpreting a function is not the right approach and what is the workaround or the right approach ? Many thanks, Rashi On Thu, Jun 3, 2010 at 6:47 PM, Eike Rathke wrote: > Hi rashi, > > On Thursday, 2010-06-03 17:52:10 +0300, ra

Re: [sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-03 Thread Eike Rathke
Hi rashi, On Thursday, 2010-06-03 17:52:10 +0300, rashi dhing wrote: > I have defined a function in which I take as input, cell values from a > range and after doing some calculation > output them on the spreadsheet using the ScDocument::SetString and > ScDocument::SetValue functions. Modifying

[sc-dev] Absurd behaviour while displaying values in a range of cells

2010-06-03 Thread rashi dhing
I have defined a function in which I take as input, cell values from a range and after doing some calculation output them on the spreadsheet using the ScDocument::SetString and ScDocument::SetValue functions. But the values get printed partially ( Eg: 8 => 3 [half an 8] ) in each of the cells .Th