Hi :) If macros are the answer then this link might help http://docs.google.com/viewer?a=v&q=cache:ZIjfkAMSUrQJ:wiki.services.openoffice.org/w/images/b/ba/0312CG-CalcMacros.pdf+Sort+button+macro+Calc&hl=en&pid=bl&srcid=ADGEESgBjm5T8fI10vLhGVuY4ZCo7ypUagt_0phAX3JZM0lBgiaI3S7MkPRj9q2QVt2B9fpTN3fnyIZo97VZ16HaAC9j9zmhW8CAvdO3rlRygEM2hmEaQlq_gEBhDMKV4fqjkzeoGotF&sig=AHIEtbTvK5PQsv50y7aj_uJEJBn3TZnPQg
It involves a type of programming or coding and the result is not compatible with MS Office (luckily). It also doesn't increase flexibility for future developments of the spreadsheet/database. This forum thread might be useful for creating the macro http://user.services.openoffice.org/en/forum/viewtopic.php?f=21&t=1254 Regards from Tom :) ----- Original Message ---- > From: Tanstaafl <[email protected]> > To: [email protected] > Sent: Fri, 10 June, 2011 23:45:13 > Subject: Re: [libreoffice-users] Add a 'Sort' button to the tops of columns? > > On 2011-06-10 6:40 PM, Tom Davies wrote: > > What you are looking for is a fairly standard database function. > > People find a nicely done "form" in a database is much easier than > > fumbling with a spreadsheet. Spreadsheets are for fairly advanced > > users with fairly good maths skills and/or logic. A database keeps > > the data safe from most common blunders that people often make with > > spreadsheets and allows various reports to be pulled-off reasonably > > easily. It also allows people with artistic skills to create a nicer > > looking form without necessarily seeing the data. > > <sigh> I really hate it when I ask someone for an apple, and they > persist in trying to convince me that what I really want is a lemon. > > -- > Unsubscribe instructions: E-mail to [email protected] > In case of problems unsubscribing, write to [email protected] > 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 > -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] 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
