I have tried the Vlookup from different workbook, but failed. Anyone can help?
It work when I vlookup from same workbook but different sheets.
I was using official OO before this, it' work for me in above 2 cases above.
Can you provide the exact example? Or the testcase ods files?
I just found something about it. If the lookup file have yet save, it wont able to process vlookup.
Mean, if i work on FileX to lookup on SheetY(which is new workbook and have yet been save)
If the SheetY save then got no issue on vlookup.