Bug #2797

Groups

Details

Request #2797	Groups
Submitted	2004-11-19 17:52 UTC
From	amir at foresthc dot com
Assigned	xnoguer
Status	Closed
Package	Spreadsheet_Excel_Writer
PHP Version	Irrelevant
Roadmaps	(Not assigned)

Comments

[2004-11-19 17:52 UTC] amir at foresthc dot com

Description:
------------
Excel has the ability to group several rows together so the user can collapse and expand them. This also enables sorting, moving and so on the collapsed versions.

[2005-07-19 22:37 UTC] Thierry dot Besancon at math dot jussieu dot fr

The ability you ask for is available in Spreadsheet-Excel for a long time.

Just use the Worksheet::setRow() method. The fourth parameter decides whether the row is collapsed or not and the fifth parameter deals with the outline level.

There is as well the method worksheet::setOutline() that can setup the outline mode.

[2005-11-09 01:51 UTC] xnoguer at php dot net

this has been answered already.