Re: [libreoffice-users] Fixed range that does not change

On 2010-11-11 06:15, Phil Hibbs wrote:
> Ah. I think I might have found a bug.
>
> 1. Put 'a' in A1 and 'z' in A2
> 2. Put 'a' in C1 and 1 in D1
> 3. Put 'z' in C1048576 and 26 in D1048576
> 4. Put formula in B1 =VLOOKUP(A1,INDIRECT("C1:D1048576"),2,0)
> 5. Copy formula into B2, which should give
> =VLOOKUP(B1,INDIRECT("C1:D1048576"),2,0)
>
> Everything works fine, the first vlookup returns 1 and the second
> returns 26... then...
>
> 6. Delete Row 3
>
> The vlookup in B2 now returns blank! Can anyone else replicate this
> behaviour and explain why?
>
> 7. Put 'z' in C2, then remove it
>
> The vlookup in B2 works again!
>
> Phil Hibbs.
>    

Phil:

I get the same result using OOo 3.2.1 on Vista Sp2.  (Substituting 65536 
as the last row)
Delete a row the result is blank. (MRI Inspection Tool shows a value of 0.0)
Enter 'z' in C2 and it returns 26 again.
And
Insert a row and it returns 26 again.

TomW

--
E-mail to users+help@libreoffice.org for instructions on how to unsubscribe
List archives are available at http://www.libreoffice.org/lists/users/
All messages you send to this list will be publicly archived and cannot be deleted