thanks a lot,It works for me,I never know it before:)
2010/12/13 Andy Brown a...@the-martin-byrd.net
On Sun Dec 12 2010 18:49:01 GMT-0800 (PST) henry cui wrote:
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?
Use the $ to lock to a direct cell number. A1 will change with either row
or column as it is dragged. $A$1 will keep the same no matter where it is
dragged. A1 is an indirect reference and $A$1 is a direct reference.
HTH
--
Unsubscribe instructions: E-mail to
users+h...@libreoffice.orgusers%2bh...@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+h...@libreoffice.org
List archive: http://www.libreoffice.org/lists/users/
*** All posts to this list are publicly archived for eternity ***
