Bug 158719 - Vlookup error swapping from libreoffice to excel
Summary: Vlookup error swapping from libreoffice to excel
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.4.1 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-15 09:18 UTC by Phibs
Modified: 2023-12-17 12:21 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Phibs 2023-12-15 09:18:51 UTC 
Description:
Creating a file in libreoffice Calc with vlookup formula, when i open it with excel formulas are corrupted. The same happens from excel to libreoffice calc.
Example: =IF(AB2="";"";VLOOKUP(_xlfn.single(AB2);$Sol.$A$2:$C$13;2))
should be
=IF(AB2="";"";VLOOKUP(AB2;$Sol.$A$2:$C$13;2))

Actual Results:
=IF(AB2="";"";VLOOKUP(_xlfn.single(AB2);$Sol.$A$2:$C$13;2))

Expected Results:
=IF(AB2="";"";VLOOKUP(AB2;$Sol.$A$2:$C$13;2))


Reproducible: Always


User Profile Reset: No

Additional Info:
[Information automatically included from LibreOffice]
Locale: en-GB
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 m_a_riosv 2023-12-15 21:26:01 UTC 
Please attach a sample file, and paste the information in Menu/Help/About LibreOffice, there is an icon to copy.
Comment 2 Phibs 2023-12-17 12:21:16 UTC 
Sorry, I'm not being able to replicate the error. I created a file in Libreoffice calc, then used it in office android. Strangely, when i opened it in Libreoffice calc again, it had those values that I sent you.
Now tried to replicate the error and nothing happened. All correct.
Thanks for your fast support, and sorry for triggering a false alarm.