[ Index ]

PHP Cross Reference of Unnamed Project

title

Body

[close]

/lib/phpexcel/PHPExcel/Worksheet/ -> PageSetup.php (summary)

PHPExcel Copyright (c) 2006 - 2015 PHPExcel

Copyright: Copyright (c) 2006 - 2015 PHPExcel (http://www.codeplex.com/PHPExcel)
License: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
Version: ##VERSION##, ##DATE##
File Size: 839 lines (29 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

PHPExcel_Worksheet_PageSetup:: (36 methods):
  __construct()
  getPaperSize()
  setPaperSize()
  getOrientation()
  setOrientation()
  getScale()
  setScale()
  getFitToPage()
  setFitToPage()
  getFitToHeight()
  setFitToHeight()
  getFitToWidth()
  setFitToWidth()
  isColumnsToRepeatAtLeftSet()
  getColumnsToRepeatAtLeft()
  setColumnsToRepeatAtLeft()
  setColumnsToRepeatAtLeftByStartAndEnd()
  isRowsToRepeatAtTopSet()
  getRowsToRepeatAtTop()
  setRowsToRepeatAtTop()
  setRowsToRepeatAtTopByStartAndEnd()
  getHorizontalCentered()
  setHorizontalCentered()
  getVerticalCentered()
  setVerticalCentered()
  getPrintArea()
  isPrintAreaSet()
  clearPrintArea()
  setPrintArea()
  addPrintArea()
  setPrintAreaByColumnAndRow()
  addPrintAreaByColumnAndRow()
  getFirstPageNumber()
  setFirstPageNumber()
  resetFirstPageNumber()
  __clone()


Class: PHPExcel_Worksheet_PageSetup  - X-Ref

PHPExcel_Worksheet_PageSetup

<code>
Paper size taken from Office Open XML Part 4 - Markup Language Reference, page 1988:

1 = Letter paper (8.5 in. by 11 in.)
2 = Letter small paper (8.5 in. by 11 in.)
3 = Tabloid paper (11 in. by 17 in.)
4 = Ledger paper (17 in. by 11 in.)
5 = Legal paper (8.5 in. by 14 in.)
6 = Statement paper (5.5 in. by 8.5 in.)
7 = Executive paper (7.25 in. by 10.5 in.)
8 = A3 paper (297 mm by 420 mm)
9 = A4 paper (210 mm by 297 mm)
10 = A4 small paper (210 mm by 297 mm)
11 = A5 paper (148 mm by 210 mm)
12 = B4 paper (250 mm by 353 mm)
13 = B5 paper (176 mm by 250 mm)
14 = Folio paper (8.5 in. by 13 in.)
15 = Quarto paper (215 mm by 275 mm)
16 = Standard paper (10 in. by 14 in.)
17 = Standard paper (11 in. by 17 in.)
18 = Note paper (8.5 in. by 11 in.)
19 = #9 envelope (3.875 in. by 8.875 in.)
20 = #10 envelope (4.125 in. by 9.5 in.)
21 = #11 envelope (4.5 in. by 10.375 in.)
22 = #12 envelope (4.75 in. by 11 in.)
23 = #14 envelope (5 in. by 11.5 in.)
24 = C paper (17 in. by 22 in.)
25 = D paper (22 in. by 34 in.)
26 = E paper (34 in. by 44 in.)
27 = DL envelope (110 mm by 220 mm)
28 = C5 envelope (162 mm by 229 mm)
29 = C3 envelope (324 mm by 458 mm)
30 = C4 envelope (229 mm by 324 mm)
31 = C6 envelope (114 mm by 162 mm)
32 = C65 envelope (114 mm by 229 mm)
33 = B4 envelope (250 mm by 353 mm)
34 = B5 envelope (176 mm by 250 mm)
35 = B6 envelope (176 mm by 125 mm)
36 = Italy envelope (110 mm by 230 mm)
37 = Monarch envelope (3.875 in. by 7.5 in.).
38 = 6 3/4 envelope (3.625 in. by 6.5 in.)
39 = US standard fanfold (14.875 in. by 11 in.)
40 = German standard fanfold (8.5 in. by 12 in.)
41 = German legal fanfold (8.5 in. by 13 in.)
42 = ISO B4 (250 mm by 353 mm)
43 = Japanese double postcard (200 mm by 148 mm)
44 = Standard paper (9 in. by 11 in.)
45 = Standard paper (10 in. by 11 in.)
46 = Standard paper (15 in. by 11 in.)
47 = Invite envelope (220 mm by 220 mm)
50 = Letter extra paper (9.275 in. by 12 in.)
51 = Legal extra paper (9.275 in. by 15 in.)
52 = Tabloid extra paper (11.69 in. by 18 in.)
53 = A4 extra paper (236 mm by 322 mm)
54 = Letter transverse paper (8.275 in. by 11 in.)
55 = A4 transverse paper (210 mm by 297 mm)
56 = Letter extra transverse paper (9.275 in. by 12 in.)
57 = SuperA/SuperA/A4 paper (227 mm by 356 mm)
58 = SuperB/SuperB/A3 paper (305 mm by 487 mm)
59 = Letter plus paper (8.5 in. by 12.69 in.)
60 = A4 plus paper (210 mm by 330 mm)
61 = A5 transverse paper (148 mm by 210 mm)
62 = JIS B5 transverse paper (182 mm by 257 mm)
63 = A3 extra paper (322 mm by 445 mm)
64 = A5 extra paper (174 mm by 235 mm)
65 = ISO B5 extra paper (201 mm by 276 mm)
66 = A2 paper (420 mm by 594 mm)
67 = A3 transverse paper (297 mm by 420 mm)
68 = A3 extra transverse paper (322 mm by 445 mm)
</code>

__construct()   X-Ref
Create a new PHPExcel_Worksheet_PageSetup


getPaperSize()   X-Ref
Get Paper Size

return: int

setPaperSize($pValue = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER)   X-Ref
Set Paper Size

param: int $pValue
return: PHPExcel_Worksheet_PageSetup

getOrientation()   X-Ref
Get Orientation

return: string

setOrientation($pValue = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT)   X-Ref
Set Orientation

param: string $pValue
return: PHPExcel_Worksheet_PageSetup

getScale()   X-Ref
Get Scale

return: int?

setScale($pValue = 100, $pUpdate = true)   X-Ref
Set Scale

Print scaling. Valid values range from 10 to 400
This setting is overridden when fitToWidth and/or fitToHeight are in use

param: int?    $pValue
param: boolean    $pUpdate    Update fitToPage so scaling applies rather than fitToHeight / fitToWidth
return: PHPExcel_Worksheet_PageSetup

getFitToPage()   X-Ref
Get Fit To Page

return: boolean

setFitToPage($pValue = true)   X-Ref
Set Fit To Page

param: boolean $pValue
return: PHPExcel_Worksheet_PageSetup

getFitToHeight()   X-Ref
Get Fit To Height

return: int?

setFitToHeight($pValue = 1, $pUpdate = true)   X-Ref
Set Fit To Height

param: int? $pValue
param: boolean $pUpdate Update fitToPage so it applies rather than scaling
return: PHPExcel_Worksheet_PageSetup

getFitToWidth()   X-Ref
Get Fit To Width

return: int?

setFitToWidth($pValue = 1, $pUpdate = true)   X-Ref
Set Fit To Width

param: int? $pValue
param: boolean $pUpdate Update fitToPage so it applies rather than scaling
return: PHPExcel_Worksheet_PageSetup

isColumnsToRepeatAtLeftSet()   X-Ref
Is Columns to repeat at left set?

return: boolean

getColumnsToRepeatAtLeft()   X-Ref
Get Columns to repeat at left

return: array Containing start column and end column, empty array if option unset

setColumnsToRepeatAtLeft($pValue = null)   X-Ref
Set Columns to repeat at left

param: array $pValue Containing start column and end column, empty array if option unset
return: PHPExcel_Worksheet_PageSetup

setColumnsToRepeatAtLeftByStartAndEnd($pStart = 'A', $pEnd = 'A')   X-Ref
Set Columns to repeat at left by start and end

param: string $pStart
param: string $pEnd
return: PHPExcel_Worksheet_PageSetup

isRowsToRepeatAtTopSet()   X-Ref
Is Rows to repeat at top set?

return: boolean

getRowsToRepeatAtTop()   X-Ref
Get Rows to repeat at top

return: array Containing start column and end column, empty array if option unset

setRowsToRepeatAtTop($pValue = null)   X-Ref
Set Rows to repeat at top

param: array    $pValue    Containing start column and end column, empty array if option unset
return: PHPExcel_Worksheet_PageSetup

setRowsToRepeatAtTopByStartAndEnd($pStart = 1, $pEnd = 1)   X-Ref
Set Rows to repeat at top by start and end

param: int $pStart
param: int $pEnd
return: PHPExcel_Worksheet_PageSetup

getHorizontalCentered()   X-Ref
Get center page horizontally

return: bool

setHorizontalCentered($value = false)   X-Ref
Set center page horizontally

param: bool $value
return: PHPExcel_Worksheet_PageSetup

getVerticalCentered()   X-Ref
Get center page vertically

return: bool

setVerticalCentered($value = false)   X-Ref
Set center page vertically

param: bool $value
return: PHPExcel_Worksheet_PageSetup

getPrintArea($index = 0)   X-Ref
Get print area

param: int        $index    Identifier for a specific print area range if several ranges have been set
return: string

isPrintAreaSet($index = 0)   X-Ref
Is print area set?

param: int        $index    Identifier for a specific print area range if several ranges have been set
return: boolean

clearPrintArea($index = 0)   X-Ref
Clear a print area

param: int        $index    Identifier for a specific print area range if several ranges have been set
return: PHPExcel_Worksheet_PageSetup

setPrintArea($value, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE)   X-Ref
Set print area. e.g. 'A1:D10' or 'A1:D10,G5:M20'

param: string    $value
param: int        $index    Identifier for a specific print area range allowing several ranges to be set
param: string    $method    Determines the method used when setting multiple print areas
return: PHPExcel_Worksheet_PageSetup

addPrintArea($value, $index = -1)   X-Ref
Add a new print area (e.g. 'A1:D10' or 'A1:D10,G5:M20') to the list of print areas

param: string    $value
param: int        $index    Identifier for a specific print area range allowing several ranges to be set
return: PHPExcel_Worksheet_PageSetup

setPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = 0, $method = self::SETPRINTRANGE_OVERWRITE)   X-Ref
Set print area

param: int        $column1    Column 1
param: int        $row1        Row 1
param: int        $column2    Column 2
param: int        $row2        Row 2
param: int        $index        Identifier for a specific print area range allowing several ranges to be set
param: string    $method        Determines the method used when setting multiple print areas
return: PHPExcel_Worksheet_PageSetup

addPrintAreaByColumnAndRow($column1, $row1, $column2, $row2, $index = -1)   X-Ref
Add a new print area to the list of print areas

param: int        $column1    Start Column for the print area
param: int        $row1        Start Row for the print area
param: int        $column2    End Column for the print area
param: int        $row2        End Row for the print area
param: int        $index        Identifier for a specific print area range allowing several ranges to be set
return: PHPExcel_Worksheet_PageSetup

getFirstPageNumber()   X-Ref
Get first page number

return: int

setFirstPageNumber($value = null)   X-Ref
Set first page number

param: int $value
return: PHPExcel_Worksheet_HeaderFooter

resetFirstPageNumber()   X-Ref
Reset first page number

return: PHPExcel_Worksheet_HeaderFooter

__clone()   X-Ref
Implement PHP __clone to create a deep clone, not just a shallow copy.




Generated: Thu Aug 11 10:00:09 2016 Cross-referenced by PHPXref 0.7.1