Bug 158719

Summary:	Vlookup error swapping from libreoffice to excel
Product:	LibreOffice	Reporter:	Phibs <phibsbm>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED INVALID
Severity:	normal	CC:	miguelangelrv
Priority:	medium
Version:	7.6.4.1 release
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

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.