damiengolding
General User
Joined: 17 May 2012
Posts: 5
Location: Osaka, Japan
|
 Posted: Tue May 29, 2012 11:57 pm Post subject: How to add button to column header to sort data by column |
 |
|
Hi, I am looking to add a button to my spreadsheet for each column header, that sorts rows of all the data by the data in the column of the button pressed.
For example:
Name|Website|Comments
a|Google|Search
b|Facebook|SNS
c|Ebay|auction
Clicking Website would sort into the following order: c,b,a
Clicking Comments would sort into the following order: c,a,b
Any help would be very appreciated.
Thank you in advance.
_________________
Translator and English teacher in Japan.
Please check out my blog. |
|
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Wed May 30, 2012 3:05 am Post subject: |
|
|
This what databases can do because database tables are organized as a collection of indivisible rows. Spreadsheets do not know any tables. By mere intention sheets are organized as single cells with coordinates.
3 options:
-- Use a database (expensive to build up, very easy to use)
-- Use the "cheap tool" as is (easy to build up, more difficult to use)
-- Write a macro program for the "cheap tool"
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
