https://bugs.freedesktop.org/show_bug.cgi?id=74437
Priority: medium
Bug ID: 74437
Assignee: [email protected]
Summary: BUSCARV (LOOKUPV) Error and Excel 2003
interoperability
Severity: critical
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: All
Status: NEW
Version: 4.2.0.4 release
Component: Libreoffice
Product: LibreOffice
Created attachment 93279
--> https://bugs.freedesktop.org/attachment.cgi?id=93279&action=edit
images tha show bug in action
Hi, i´m Nik from Argentina. First sorry about my english i speak spanish.
I Use every days Libreoffice Calc. Before i use 4.1.4.2 version, and
everythings Ok. When install 4.2.0.4 i found some Bugs. Two that are important.
One in new versión (4.2.0.4) show “N/D” that you can see in image “Libreoffice
4.2.0.4 Bug BUSCARV Function.png”, when find cells in other sheet, the
function is:
=BUSCARV(B15;'C:\Mis
Documentos\COSTOS\[Precios_Actuales.xls]Precios'!$B$4:$AE$400;22;0)
I want find in “Precios_Actuales.xls”, in “Precios” from $B$4:$A$E400 the
equal respect cell B15 from origen (NS0280 Llada.xls in this case), the cost
in row 22 (W).
Excel 2003, Openoffice 4.01 and Libreoffice 4.1.4.2 function works perfectly,
but not in Libreoffice 4.2.0.4. (Files: “NS0280 Llada.xls” and
“Precios_Actuales.xls”)
Other thing that was intresting that functin support relative path. Ejample:
not write 'C:\Mis Documentos\COSTOS\[Precios_Actuales.xls]Precios', just
write '.\[Precios_Actuales.xls]Precios', that must work perfectly with
pendrives and not, and Linux & Windows, etc.
The interoperability respect Excel has change, now the file “PRECIO TERCEROS
27-01-14.xls” that use a simple porcentual function show a lots of zeros. Look
it in the image “Libreoffice 4.2.0.4 Bug EXCEL.png”..
I see a change in Excel functions work, but i think you can reseolve that
quickily with and option in preferentes, where you can select functions “like”
4.1.4.2 or 4.2.0.4 type.
Thanks a lot you make a great job. Nicolás.-
--
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
