Re: [libreoffice-users] Add a 'Sort' button to the tops of columns?

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 <tanstaafl@libertytrek.org>
> To: users@global.libreoffice.org
> 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 users+help@global.libreoffice.org
> In  case of problems unsubscribing, write to postmaster@documentfoundation.org
> 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 users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
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