setCollapsed in reverse order

Topics: Developer Forum, User Forum
Jan 14, 2013 at 11:17 AM

in the sample pic above, how can i set the collapsed at line7 instead line9. so when i expand line7, line 8,9 will show instead expand line9, line7 and 8 showing.

Feb 12, 2013 at 11:04 AM
According to docs (PHPExcel developer documentation.doc) , 4.6.33. Group/outline a row section

You can instruct PHPExcel to add a summary below the collapsible rows (default), or above. The following code adds the summary above:
$objPHPExcel->getActiveSheet()->setShowSummaryBelow(false);

So you have to add this line of code:
$objPHPExcel->getActiveSheet()->setShowSummaryBelow(false);