setShowGridlines(true) doenst work (Excel5)

Mar 4, 2011 at 8:42 PM
Edited Mar 4, 2011 at 8:47 PM

Hi,

 

im trying to set setShowGridlines to true for an excel2003 document.. but it doenst work :// when i open the xls file it doenst print me the gridlines ( and the setting in page setup is also not checked)

i didnt try that with excel2007 cause still many customers cant open xlsx files.. (and i didnt activated zip) so i cant say its if working with that.. but.. with excel5 it doenst work at all

 

someone got the same problem? or it is a bug?

just as simple as it shoudl be:

$objPHPExcel->setActiveSheetIndex(0);
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&R&D');
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&RSeite &P / &N');
$objPHPExcel->getActiveSheet()->setShowGridlines(true);

 

thanks for help!