Re: [libreoffice-users] Re: Slow Calc Macros

Hi,

On Sat, 2011-08-06 at 13:31 +0000, Onyeibo Oku wrote: 

> 1) True but what I'm doing is more computational than relational though the end result will be a 
> material for building a proper database. A spreadsheet is more suited for this ... Trust me on 
> this.
>
> 2) All the macro does is create and remove sheets as needed (for now). All calculations are done 
> by the spreadsheet formulas ... The 'IF' statement I mentioned is a spreadsheet logical function.
>
> 3) Its Python not BASIC. 
>
> ---------------------------------------------
> from twohot@device.mobile :)
>
> -----Original Message-----
> From: Andreas Säger <villeroy@t-online.de>
> Date: Sat, 06 Aug 2011 12:34:13 
> To: <users@global.libreoffice.org>
> Reply-To: users@global.libreoffice.org
> Subject: [libreoffice-users] Re: Slow Calc Macros
>
> General rule of thumb: 99% of all spreadsheet macros are potentially 
> harmful, counter productive, badly implemented and reveal nothing but 
> the author's ignorance against the underlying spreadsheet application.
> Could it be that a most simple database would solve all your problems 
> without a single line of silly Basic?
>
>
> -- 
> 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

Depending on the complexity of the calculations you might find Base
easier to use. Relational databases support normal arithmetic and simple
statistical functions (sum, count, average) because they are implemented
in SQL. The more complex functions are not supported by SQL such as trig
or log.

-- 
Jay Lozier
jslozier@gmail.com

-- 
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