Summary: |
BUSCARV (LOOKUPV) Error and Excel 2003 interoperability |
Product: |
LibreOffice
|
Reporter: |
Nicolás <nicolasebsastre> |
Component: |
Spreadsheet | Assignee: |
Not Assigned <libreoffice-bugs> |
Status: |
NEW
---
|
QA Contact: |
|
Severity: |
critical
|
|
|
Priority: |
medium
|
|
|
Version: |
4.2.0.4 release | |
|
Hardware: |
All | |
|
OS: |
Windows (All) | |
|
Whiteboard: |
|
i915 platform:
|
|
i915 features:
|
|
Attachments: |
images tha show bug in action
|
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 93279 [details] 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.-