Windows 7 / LibreOffice 5.1.4.2
I switch to LibreOffice after OO kept crashing, I have a big ods file with a lot of data and a lot of VLOOKUP functions, some work well others keep giving problems.
This is what happens:
It returns a large number in stead of text, if I then change the lookup formula by adding or removing a $ (just for the sake of change and forcing a recalculation), the correct text is displayed. If I then ‘copy’ the formula by clicking the bottom right corner of the cell it messes it up again (all numbers) but if I pull it down manually a few cells and then copy it to the rest it works, but if I sort it, it is back to all numbers again.
Really frustrating