--- "der.hans" <PLUGd@LuftHans.com> wrote:
> Am 12. Jan, 2004 schw�tzte June Tate so:
> 
> > On Mon, 2004-01-12 at 00:29, der.hans wrote:
> > > Also, how do you mark rows/columns as sub-rows/columns of other
> rows, e.g.
> > >
> > > expand	date	water	elect	phone
> > > 	Jan2003	$50.00	$50.00	$50.00
> > > 	Feb2003	$50.00	$50.00	$50.00
> > > 	Mar2003	$50.00	$50.00	$50.00
> > > 	Apr2003	$50.00	$50.00	$50.00
> > >
> > > I want to be able to collapse the year down to just the first
> line when
> > > I'm not looking at it.
> >
> > I'm not sure what you're asking here. Are you asking for something
> like
> > this:
> >
> > 	date    water    elect    phone
> > 	Jan2003 $50.00   $50.00   $50.00
> >
> > To be collapsed into something like this:
> >
> > 	        water    elect    phone
> > 	        $50.00   $50.00   $50.00
> 
> I want Feb, Mar, Apr, etc. to be sub rows of Jan, such that
> collapsing the
> thread leaves only Jan showing.
> 
> The xls file has a plus/minus box on the left that
> collapses/uncollapses the
> 'thread'.
> 
> ciao,
> 
> der.hans, the spreadsheet newbie

In OO.o 1.1, try this:
1/ highlight the rows you want to collapse (in your case, Feb, Mar,
Apr, etc.)
2/ Under Data, choose Outline, then select Group.

Now to the left of the row numbers, you should have the -/+ expander
control, along with outline level selector buttons (1, 2) at the top.

Is this what you referred to?

-A

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus