[libreoffice-users] Re: database or spreadsheet

Am 07.02.2012 16:52, Jay Lozier wrote:
> >
> Most people are scared off by having to develop queries, particularly if
> they must use SQL. It is too much like programming to them and that
> tends to scare them; seemingly arcane rules and syntax that does not
> appear very flexible or easy to use.

Some of them are so desparately trying to organize their data in 
spreadsheets that they start learning an extinct programming lingo 
together with formulas like
> =IF(ISERROR(INDEX(INPUT.$A$2:$A$301;MATCH(A3;INPUT.$B$2:$B$301;0)));"";INDEX(INPUT.$A$2:$A$301;MATCH(A3;INPUT.$B$2:$B$301;0)))
> +IF(ISERROR(INDEX(INPUT.$A$3:$A$300;MATCH(A3;INPUT.$D$3:$D$300;0)));"";INDEX(INPUT.$A$3:$A$300;MATCH(A3;INPUT.$D$3:$D$300;0)))



--
For unsubscribe instructions e-mail to: users+help@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