Re: [sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-19 Thread Eike Rathke
Hi Yue, On Wednesday, 2008-03-19 12:38:05 +0800, Lvyue wrote: > For i86643, I restrict the precondition to errNoName, > because I found if there is an illegal param in the list and not the last one, > and also empty cell or range in the list. > the result will be 1 more than the right number. >

Re: Re: [sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-18 Thread Lvyue
tell you when I found problems. Let's see on IRC. :) Lvyue 2008-03-19 发件人: Eike Rathke 发送时间: 2008-03-19 08:17:09 收件人: dev@sc.openoffice.org 抄送: 主题: Re: [sc-dev] About i78781(Excel INDEX() compatibility) Hi Yue, On Tuesday, 2008-03-18 15:07:56 +0800, Lvyue wrote: > I began to work

Re: [sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-18 Thread Eike Rathke
Hi Yue, On Tuesday, 2008-03-18 15:07:56 +0800, Lvyue wrote: > I began to work on issue78781 yesterday. Fine, thanks. > Compared with Excel, I found there are two things I should modify. > > 1. while input: =INDEX($D$27:$P$27;2) > the result should be value of E27. Correct. For a row vector th

[sc-dev] About i78781(Excel INDEX() compatibility)

2008-03-18 Thread Lvyue
Hi Eike, I began to work on issue78781 yesterday. Compared with Excel, I found there are two things I should modify. 1. while input: =INDEX($D$27:$P$27;2) the result should be value of E27. 2. while input: =INDEX(($D$27:$P$27;$D$29:$P$29);2) the result also should be value of E27. so I made so