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+h...@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