Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


On 06/10/2011 03:34 PM, Tanstaafl wrote:
On 2011-06-10 6:04 PM, NoOp wrote:
On 06/10/2011 12:48 PM, Tanstaafl wrote:
There has got to be a reasonably easy way to do this (by 'reasonable', I
mean a way that doesn't require me to become a programmer)...

How do I add a 'Sort' button to the tops of columns, so that I can
easily sort the data in a spreadsheet on different columns simply by
clicking the button in the column header?

I've seen these in spreadsheets I get from Excel users all the time, but
for the life of me can't figure out how to do this in Calc.

Can you post a sample somewhere? I know that when you turn on 'Auto
Filter' in Excel and LO it will add a dropdown filter button to the
header. But I've not seen an 'Sort' button on a column header.

Crap... yeah, that's what I was seeing...

But I just can't imagine this is so hard...

I just want to be able to click a column header, and have that execute a
'Sort Rows B3 thru Y18 by column R in descending order'...

Then, if I click the column header again, have it sort it in the
opposite order.

I've only see that (from google) done as a macro.


And yes, I know a database would be better for this, but it isn't a
database, the boss wants it done in a spreadsheet... and I'm not a VB
(or whatever the equivalent is in calc) programmer)...


As for Autofilter. Autofilter is easy: Select the column(s) data area(s)
in the columns & Data|Filter|Autofilter
That will ask you if you want to use the first line to be used as the
column filter if you do not have column headers defined already.

Note: when opening an .xls with autofilters, LO will not include/show
the autofilters in the .xls. Unfortunately you'll need to review the
.xls in Excel/Excel Viewer & then add your own in LO. This probably
should be (if not already) filed as a bug as LO should open the .xls
with the autofilters enabled.




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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.