https://bugs.freedesktop.org/show_bug.cgi?id=83746
--- Comment #8 from Matthew Francis <[email protected]> --- Created attachment 106373 --> https://bugs.freedesktop.org/attachment.cgi?id=106373&action=edit Expanded example (as ODS) This expanded ODS example contains the formulae =VLOOKUP(B1,$C$1:$D$1048576,2) =VLOOKUP(B1,$C$1:$D$983040,2) =VLOOKUP(B1,$C$1:$D$983039,2) =VLOOKUP(B1,$C$1:$D$65537,2) =VLOOKUP(B1,$C$1:$D$65536,2) =VLOOKUP(B1,$C$1:$D$65535,2) =VLOOKUP(B1,$C$1:$D$100,2) After saving as .xls, closing and reloading, the result in OSX/4.3.1.2 is =VLOOKUP(B1,$C$1:$D$983040,2) =VLOOKUP(B1,$#REF!$#REF!:$#REF!$#REF!,2) =VLOOKUP(B1,$#REF!$#REF!:$#REF!$#REF!,2) =VLOOKUP(B1,$#REF!$#REF!:$#REF!$#REF!,2) =VLOOKUP(B1,$C$1:$D$983040,2) =VLOOKUP(B1,$C$1:$D$65535,2) =VLOOKUP(B1,$C$1:$D$100,2) Based on this, it looks to me as if the handling of any row range >= 65536 is broken, sometimes resulting in an incorrect range and sometimes a #REF! The original reporter did also mention something about seeing #REF!, but I couldn't reproduce that initially - however, having now done so, it looks like it's still part of the same bug. -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
