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 [email protected] :) > > -----Original Message----- > From: Andreas Säger <[email protected]> > Date: Sat, 06 Aug 2011 12:34:13 > To: <[email protected]> > Reply-To: [email protected] > 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: [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 > > 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 [email protected] -- For unsubscribe instructions 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
