can you expand collapse tables/rows/cells?

actiononly · Newbie Joined: 18 Mar 2010 Posts: 1

I am not sure if this is the right application for this, but I saw it in excel and thought maybe it could be done in openoffice calc.

I want to be able to create categories in the left column that have subcategories that can expand and collapse like this:
http://farm3.static.flickr.com/2515/3729798821_bc1628a265.jpg?v=0
http://farm3.static.flickr.com/2583/3729798873_baa70869cc.jpg?v=0
http://www.filebuzz.com/software_screenshot/full/43886-TList___OCX.jpg

Is this possible in openoffice calc?

keme · Posted: Thu Mar 18, 2010 5:53 am Post subject:

Yes you can. See Data - Group and Outline

You won't have the structure visible within the grid, but functionally it's equivalent. Grouping is shown by brackets outside the row numbering, in the left frame of the grid (or above the top of the grid if you do horizontal grouping), with a +/- button to expand/collapse. You can also use "main buttons" in the top left corner to expand/collapse all branches to the same level.