This is a know limitation/feature of OpenOffice and now of LibreOffice. In my opinion it should be modified to make it consistent with other spreadsheets.
There is no easy way other than to type a high number (currently it can be as high as 1048576) or to make it faster just type 1 followed by 6 zeros) This is faster than selecting with the mouse (given the limitation that you can't simply select a column or row) -- View this message in context: http://nabble.documentfoundation.org/vlookup-is-hard-to-use-tp2069838p2072723.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to users+h...@libreoffice.org List archive: http://www.libreoffice.org/lists/users/ *** All posts to this list are publicly archived for eternity ***
