--- "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
(text/plain)