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

Worksheet::fitToPages

Worksheet::fitToPages -- Stoque le nombre de pages vertical et horizontal qui définira la zone d'impression

Synopsis

require_once "Spreadsheet/Excel/Writer.php";

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

Description

Stoque le nombre de pages vertical et horizontal qui définira la zone d'impression. Cela ne semble pas fonctionner avec OpenOffice.

Paramètres

  • integer $width - Nombre maximal de pages vertical pour la zone d'impression

  • integer $height - Nombre maximal de pages horizontal pour la zone d'impression

Note

Cette fonction ne peut pas être appelée de façon statique.

Exemple

Exemple 43-1. Exemple avec fitToPages()


 

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

 

     
  		
 

 

  
   

    

     
Download Documentation
     
     Last updated: Sun, 28 Sep 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