Date: prev next · Thread: first prev next last
2010 Archives by date, by thread · List index


thanks for your answer.:)
I tried your method ,but still face two problems
1. I found the second parameter array can't be in other separably xls
file.It works just in single file with different sheet.
2. I settle the formulation on the cell,when I drag the cell to extend the
formulation to other cells.I found the number of the cell in the
function of vlookup is changing.This effect will affect the search scope of
the sormulation and it's different from the same rule in the excel.
Trying to use mouse to drag formulation become a hard way to handle the
formuation,is there any other way to handle this kind of operate
that use a single formulation in whole row or column?


2010/12/12 plino <pedlino@gmail.com>


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+help@libreoffice.org<users%2Bhelp@libreoffice.org>
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***




-- 
best,
henry cui

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.