Libre office calc sheet does not allow to select the entire range of data using ctrl+shift+alt when the formula function short is used. IF you manually write the vlookup formula it works. I am not sure if its a limitation. Can you please advice.
Hi SriJanani, thanks for reporting.
I thinks this happen with all functions in the wizard, and even in Aoo works so.
Maybe better change the status importance from normal to enhancement, adapting the title not only for vlookup.
Thank you for getting back to us with the update. I have changed the title and importance to enhancement.
*** This bug has been marked as a duplicate of bug 41902 ***