When opening an Excel file that has formulae with vlookup the range parameter is dropped.
Original Formula: =vlookup(A2,l_u_range,2,0)
(lookup value in cell A2 in the range called l_u_range and return the value
from column 2, no softseek).
Converted Formula in LO 3.41: =vlookup(A2,2,0)
Attached file demonstrates (created with Excel 2000)
Created attachment 49043 [details]
Test Excel file
Reproduced on LibreOffice 3.4 340m1(Build:103) for OpenSuse Linux.
should be fixed in 3.4.2 or 3.4.3
I have for example =VLOOKUP(A2,test,2,0) with a fresh build from the 3-4 branch
can you confirm that this is expected and then test with 3.4.2RC2? It will be available at the end of the week
If all works fine please mark as resolved - fixed
seems to be another duplicate of bug 38204
*** This bug has been marked as a duplicate of bug 38204 ***
I have downloaded the 3.4.2 version (1 Aug 2011) and have seen that it was fixed.
Thank You very much.