Worksheet::printRowColHeaders (Previous) (Next) Worksheet::setHPagebreaks
View this page in Last updated: Sun, 24 Aug 2008
English | Dutch | French | German | Hungarian | Japanese | Polish | Russian | Spanish | Plain HTML

Worksheet::fitToPages

Worksheet::fitToPages -- Store the vertical and horizontal number of pages that will define the

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

void Worksheet::fitToPages (integer $width, integer $height)

Beschreibung

Store the vertical and horizontal number of pages that will define the maximum area printed. It doesn't seem to work with OpenOffice.

Parameter

  • integer $width - Maximun width of printed area in pages

  • integer $height - Maximun heigth of printed area in pages

Hinweise

Diese Methode kann nicht statisch aufgerufen werden.

Beispiel

Beispiel 43-1. Using fitToPages()


 

  
   Worksheet::printRowColHeaders (Previous)
  
  
(Next) Worksheet::setHPagebreaks
  
 

 

     
  		
 

 

  
   

    

     
Download Documentation
     
     Last updated: Sun, 24 Aug 2008
    

    

    Do you think that something on this page is wrong?    Please file a bug report     or add a note. 
   


User Notes:





 
Note by: luis.sv@gmail.com

 
2008-02-22 16:05 UTC

 

  It is working for me in OpenOffice.org 2.3.1 and Excel 2007



I'm calculating the number of pages with this code:



//total_rows is the total number of rows that I'm going to have in the spreadsheet

//total_rows_per_page is the number of rows that I want to print in each page



$total_pages=ceil($total_rows/$total_rows_per_page);



$worksheet->fitToPages(1,$total_pages);

//I put "1" in the first parameter because I just want to have a horizontal page





Regards,

Luis Rodríguez