[sc-dev] About i46681 and IF()

2008-06-26 Thread Lvyue
Hi, Eike Really long time no see. :) Our network ultimately works today :-/, and I was sorry that we can not talk on IRC. I have fixed the problem we mentioned on last IRC, and the work on i66930 is getting progress too. but, seeing the code, I found 2 problems: 1. in

Re: [sc-dev] Issue 88967: PROB, FORECAST functions: scalar evaluation of array parameter

2008-06-26 Thread Eike Rathke
Hi David, On Wednesday, 2008-06-25 20:55:12 +0100, David King wrote: Say we have A1:C1 = {7|6|5} In cell A2 we enter, as an array formula: =PROB({5;6;7};{0.2;0.3;0.5};A1:C1) and, correctly, A2:C2 = {0.5|0.3|0.2}. Now in cell D4 we enter, as a normal (non-array) formula:

Re: [sc-dev] wrong display for special function result near 1

2008-06-26 Thread Eike Rathke
Hi Regina, On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote: I'm working on BETADIST. For certain inputs my version of that function returns a value, which is near to 1. The formula in the cell is =BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result

Re: [sc-dev] wrong display for special function result near 1

2008-06-26 Thread Niklas Nebel
Eike Rathke wrote: On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote: I'm working on BETADIST. For certain inputs my version of that function returns a value, which is near to 1. The formula in the cell is =BETADIST(B$3;$B$1;$A8) with B3=0,999 and B1=1e-9 and A8=1,5. The result

Re: [sc-dev] About i46681 and IF()

2008-06-26 Thread Eike Rathke
Hi Yue, On Thursday, 2008-06-26 16:56:14 +0800, Lvyue wrote: Really long time no see. :) Our network ultimately works today :-/, and I was sorry that we can not talk on IRC. No problem. We'll meet again next week. If you feel the need to discuss things in between, we could arrange some day

Re: [sc-dev] wrong display for special function result near 1

2008-06-26 Thread Eike Rathke
Hi Niklas, On Thursday, 2008-06-26 14:30:11 +0200, Niklas Nebel wrote: Eike Rathke wrote: On Wednesday, 2008-06-25 23:42:16 +0200, Regina Henschel wrote: I'm working on BETADIST. For certain inputs my version of that function returns a value, which is near to 1. The formula in the cell

[sc-dev] about issue86945

2008-06-26 Thread yunjingtao
hi, Daniel the code below is based on DEV300_M20. I made some changes like this : ScScenarioWindow::ScScenarioWindow( Window* pParent,const String aQH_List, const String aQH_Comment) :Window( pParent , WB_DIALOGCONTROL | WB_TABSTOP ),

Re: Re: [sc-dev] About i46681 and IF()

2008-06-26 Thread Lvyue
Hi Eike, Thanks for replying so fast. ;-) I have no other questions about things you mentioned, but SC_MATVAL_EMPTYPATH and SC_MATVAL_EMPTY. Let's see some definations. const ScMatValType SC_MATVAL_STRING = 0x02; const ScMatValType SC_MATVAL_EMPTY= SC_MATVAL_STRING | 0x04; //