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.
>
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
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
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