Page Break not working as expected.

Topics: Developer Forum
Nov 29, 2010 at 2:50 PM

I have followed the instructions and example given in http://phpexcel.codeplex.com/Thread/View.aspx?ThreadId=40723

but the default page breaks still exist after I output the excel workbook. I am using Excel 2007 format.

I tried using setFitToPage, but it only works for worksheets with less than 100 rows. If the worksheet has more than 100 rows, then each cell becomes a separate page.

Ideally what is needed, is that columns A-H should be the width of each page. and at each 100 Rows a page break should occur.

 

Thank you for any assistance.

 

Environment:

PHPExcel  1.7.4

PHP Version: 5.2.10

Centos 5.5