vlookup seems to have stopped working in CALC

asked 2019-03-04 03:23:42 +0100

jwhida gravatar image

updated 2019-03-04 03:34:47 +0100

For some reason VLOOKUP is returning #N/A. This file was working perfectly fine last time i used it.

I had upgraded to libre office 6.2, but even when i down grade back to LO6.1 the VLOOKUP still isnt working ?

The same file opened in open-office works correctly.

Very strange as I havent changed anything in the file

EDIT: The problem seems to fix itself if i start editing values by deleting trailing white spaces in the lookup field for example. Once the formula starts working again I can re-add the trailing whitespaces and everything is still fine.

edit retag flag offensive close merge delete

Comments

So it looks like be working after forcing a recalculation? Does Ctrl+Shift+F9 ("Recalculate Hard") also "fix" the problematic document?

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-04 08:51:01 +0100 )edit