https://bugs.freedesktop.org/show_bug.cgi?id=54567
--- Comment #5 from Eduardo Soares <[email protected]> --- Tested on Win LO 3.6.2.2, still the same error. But if I open the attached file on MS Excel 2010 and save it as XLSB format, and then open it on LO 3.6.2.2, there's no problem with the references to "tablename[column]". Then: Opening XLSX format I get error: Excel 2010: =VLOOKUP($A$1&CHAR(127)&$A4;TabRegistro;6;FALSE) LO 3.6.2.2: =VLOOKUP($A$1&CHAR(127)&$A4;TabRegistro;6;0) Opening XLSB format then it works: Excel 2010: =VLOOKUP($A$1&CHAR(127)&$A4;TabRegistro;6;FALSE) LO 3.6.2.2: =VLOOKUP($A$1&CHAR(127)&$A4;OFFSET(TabRegistro;1;0;ROWS(TabRegistro)-1;COLUMNS(TabRegistro));6;FALSE()) -- 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
