I have found a suggestion that an entire column can be defined as a
named range, but that is not correct. By default it misses out the
last row of data, and if you do extend it yourself to cover the last
row and then delete a row, then it appears to lose an additional row
(that is, I had a value in C1048576 that was being found in the
vlookup, and when I deleted a row, it then failed to find the value in
C1048575).
Phil Hibbs.
--
Don't you just hate self-referential sigs?
--
E-mail to users+help@libreoffice.org for instructions on how to unsubscribe
List archives are available at http://www.libreoffice.org/lists/users/
All messages you send to this list will be publicly archived and cannot be deleted
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.