[libreoffice-users] Re: Simple address data and 3 sheets

Le 2014-11-03 15:24, Andreas Säger a écrit :
> Hi,
> First of all, no professional IT person would do in a spreadsheet what you
> perfectly describe as a relational database.
> VLOOKUP is the key to mis-use a spreadsheet as a relational database. First
> you have to ensure that Tools>Options>Calc>Calculate: "Enable Regular
> Expressions" is OFF and "Match whole cell" is turned ON. These are per
> document settings.

Thanks! I'll have a look.

Luckily, I am not a professional IT person :-) and am not looking for 
recognition as such. Just a quick simple fix to a bookkeeping process.

Thanks for help, much appreciated.

Marc


--
Marc Paré
Marc@MarcPare.com
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted