Re: [sc-dev] Missing parameter in LINEST

2010-08-05 Thread Eike Rathke
Hi Regina, On Thursday, 2010-08-05 15:26:07 +0200, Regina Henschel wrote: > >The interpreter allows these cases because in Excel the missing > >parameter is allowed at most places and that's needed for imported > >documents. > > I think, that the interpreter should not allow invalid (in respect

Re: [sc-dev] Missing parameter in LINEST

2010-08-05 Thread Regina Henschel
Hello Eike, Eike Rathke schrieb: Hi Regina, Sorry for not having answered your previous mail about whether someone was already working on LINEST. No one is. Thanks for taking that. On Tuesday, 2010-08-03 20:27:56 +0200, Regina Henschel wrote: the draft ODF1.2 spec defines the syntax LINEST(

Re: [sc-dev] Missing parameter in LINEST

2010-08-04 Thread Eike Rathke
Hi Regina, Sorry for not having answered your previous mail about whether someone was already working on LINEST. No one is. Thanks for taking that. On Tuesday, 2010-08-03 20:27:56 +0200, Regina Henschel wrote: > the draft ODF1.2 spec defines the syntax > LINEST( Array knownY [ ; [ Array knownX ]

[sc-dev] Missing parameter in LINEST

2010-08-03 Thread Regina Henschel
Hi all, the draft ODF1.2 spec defines the syntax LINEST( Array knownY [ ; [ Array knownX ] [ ; Logical Const = TRUE() [ ; Logical Stats = FALSE() ] ] ] ) With this syntax the formula =LINEST(B2:B6;A2:A6;;TRUE()) is not allowed, but currently it gives no error (That is issue106118). And the fo