OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

can you expand collapse tables/rows/cells?

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
actiononly
Newbie
Newbie


Joined: 18 Mar 2010
Posts: 1

PostPosted: Thu Mar 18, 2010 5:16 am    Post subject: can you expand collapse tables/rows/cells? Reply with quote

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?
Back to top
View user's profile Send private message
keme
Moderator
Moderator


Joined: 30 Aug 2004
Posts: 2910
Location: Egersund, Norway

PostPosted: Thu Mar 18, 2010 5:53 am    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group