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

Tanstaafl wrote:
> Sorting data in a spreadsheet is basic spreadsheet functionality. Adding
> the ability to do so with a button (after defining the data range)
> *should* be trivial.
> ...
> 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'... 
If B3:Y18 is a table with A1:A18 and Z1:Z18 empty and you don't have merged
cells in row 1 and 2, it is trivial : 
Click on a cell in colum R, then click on the icon (ZA descending order).

If column A or Z contains datas :

If rows 1 & 2 do not contains merged cells : highlight B2:Y18 then Menu Data
> Define range, more → check contains column labels
If rows 1 & 1 contains merged cells : highlight B3:Y18 then Menu Data >
Define range, more → uncheck contains column labels.

After this you can use sort icon : Click on a cell in colum R, then click on
the icon (ZA descending order).

Gérard

--
View this message in context: 
http://nabble.documentfoundation.org/Add-a-Sort-button-to-the-tops-of-columns-tp3050448p3060333.html
Sent from the Users mailing list archive at Nabble.com.

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