Freeze rows and columns

Topics: User Forum
Aug 20, 2012 at 4:45 PM

How can I freeze both rows and columns?  When I put one after another, it seems to cancel the first one.

Example:

$objPHPExcel->getActiveSheet()->freezePane('A4');
$objPHPExcel->getActiveSheet()->freezePane('C1');

 

Thanks

Mike

Coordinator
Aug 20, 2012 at 5:10 PM

$objPHPExcel->getActiveSheet()->freezePane('C4');

Aug 20, 2012 at 10:08 PM

Perfect!  I should have figured that out.

Thank you