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é
[email protected]
http://www.parEntreprise.com
parEntreprise.com Supports OpenDocument Formats (ODF)
parEntreprise.com Supports http://www.LibreOffice.org
--
To unsubscribe e-mail to: [email protected]
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
