ILIAS
Release_4_0_x_branch Revision 61816
|
Public Member Functions | |
__construct () | |
Create a new PHPExcel_Worksheet_PageSetup. | |
getPaperSize () | |
Get Paper Size. | |
setPaperSize ($pValue=PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER) | |
Set Paper Size. | |
getOrientation () | |
Get Orientation. | |
setOrientation ($pValue=PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT) | |
Set Orientation. | |
getScale () | |
Get Scale. | |
setScale ($pValue=100) | |
Set Scale. | |
getFitToHeight () | |
Get Fit To Height. | |
setFitToHeight ($pValue=1) | |
Set Fit To Height. | |
getFitToWidth () | |
Get Fit To Width. | |
setFitToWidth ($pValue=1) | |
Set Fit To Width. | |
isColumnsToRepeatAtLeftSet () | |
Is Columns to repeat at left set? | |
getColumnsToRepeatAtLeft () | |
Get Columns to repeat at left. | |
setColumnsToRepeatAtLeft ($pValue=null) | |
Set Columns to repeat at left. | |
setColumnsToRepeatAtLeftByStartAndEnd ($pStart= 'A', $pEnd= 'A') | |
Set Columns to repeat at left by start and end. | |
isRowsToRepeatAtTopSet () | |
Is Rows to repeat at top set? | |
getRowsToRepeatAtTop () | |
Get Rows to repeat at top. | |
setRowsToRepeatAtTop ($pValue=null) | |
Set Rows to repeat at top. | |
setRowsToRepeatAtTopByStartAndEnd ($pStart=1, $pEnd=1) | |
Set Rows to repeat at top by start and end. | |
getHorizontalCentered () | |
Get center page horizontally. | |
setHorizontalCentered ($value=false) | |
Set center page horizontally. | |
getVerticalCentered () | |
Get center page vertically. | |
setVerticalCentered ($value=false) | |
Set center page vertically. | |
getPrintArea () | |
Get print area. | |
isPrintAreaSet () | |
Is print area set? | |
setPrintArea ($value) | |
Set print area. | |
setPrintAreaByColumnAndRow ($column1, $row1, $column2, $row2) | |
Set print area. | |
__clone () | |
Implement PHP __clone to create a deep clone, not just a shallow copy. |
Private Attributes | |
$_paperSize | |
$_orientation | |
$_scale | |
$_fitToHeight | |
$_fitToWidth | |
$_columnsToRepeatAtLeft = array('', '') | |
$_rowsToRepeatAtTop = array(0, 0) | |
$_horizontalCentered = false | |
$_verticalCentered = false | |
$_printArea = null |
Definition at line 107 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::__construct | ( | ) |
Create a new PHPExcel_Worksheet_PageSetup.
Definition at line 260 of file PageSetup.php.
References ORIENTATION_DEFAULT, and PAPERSIZE_LETTER.
PHPExcel_Worksheet_PageSetup::__clone | ( | ) |
PHPExcel_Worksheet_PageSetup::getColumnsToRepeatAtLeft | ( | ) |
Get Columns to repeat at left.
Definition at line 409 of file PageSetup.php.
References $_columnsToRepeatAtLeft.
PHPExcel_Worksheet_PageSetup::getFitToHeight | ( | ) |
Get Fit To Height.
Definition at line 350 of file PageSetup.php.
References $_fitToHeight.
PHPExcel_Worksheet_PageSetup::getFitToWidth | ( | ) |
Get Fit To Width.
Definition at line 372 of file PageSetup.php.
References $_fitToWidth.
PHPExcel_Worksheet_PageSetup::getHorizontalCentered | ( | ) |
Get center page horizontally.
Definition at line 492 of file PageSetup.php.
References $_horizontalCentered.
PHPExcel_Worksheet_PageSetup::getOrientation | ( | ) |
Get Orientation.
Definition at line 300 of file PageSetup.php.
References $_orientation.
PHPExcel_Worksheet_PageSetup::getPaperSize | ( | ) |
PHPExcel_Worksheet_PageSetup::getPrintArea | ( | ) |
PHPExcel_Worksheet_PageSetup::getRowsToRepeatAtTop | ( | ) |
Get Rows to repeat at top.
Definition at line 458 of file PageSetup.php.
References $_rowsToRepeatAtTop.
PHPExcel_Worksheet_PageSetup::getScale | ( | ) |
PHPExcel_Worksheet_PageSetup::getVerticalCentered | ( | ) |
Get center page vertically.
Definition at line 512 of file PageSetup.php.
References $_verticalCentered.
PHPExcel_Worksheet_PageSetup::isColumnsToRepeatAtLeftSet | ( | ) |
Is Columns to repeat at left set?
Definition at line 394 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::isPrintAreaSet | ( | ) |
Is print area set?
Definition at line 541 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::isRowsToRepeatAtTopSet | ( | ) |
Is Rows to repeat at top set?
Definition at line 443 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setColumnsToRepeatAtLeft | ( | $pValue = null | ) |
Set Columns to repeat at left.
array | $pValue | Containing start column and end column, empty array if option unset |
Definition at line 419 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setColumnsToRepeatAtLeftByStartAndEnd | ( | $pStart = 'A' , |
|
$pEnd = 'A' |
|||
) |
Set Columns to repeat at left by start and end.
string | $pStart | |
string | $pEnd |
Definition at line 433 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setFitToHeight | ( | $pValue = 1 | ) |
Set Fit To Height.
int? | $pValue |
Definition at line 360 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setFitToWidth | ( | $pValue = 1 | ) |
Set Fit To Width.
int? | $pValue |
Definition at line 382 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setHorizontalCentered | ( | $value = false | ) |
Set center page horizontally.
bool | $value |
Definition at line 502 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setOrientation | ( | $pValue = PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT | ) |
Set Orientation.
string | $pValue |
Definition at line 310 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setPaperSize | ( | $pValue = PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER | ) |
Set Paper Size.
int | $pValue |
Definition at line 290 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setPrintArea | ( | $value | ) |
Set print area.
string | $value |
Exception |
Definition at line 552 of file PageSetup.php.
References elseif().
Referenced by setPrintAreaByColumnAndRow().
PHPExcel_Worksheet_PageSetup::setPrintAreaByColumnAndRow | ( | $column1, | |
$row1, | |||
$column2, | |||
$row2 | |||
) |
Set print area.
int | $column1 | Column 1 |
int | $row1 | Row 1 |
int | $column2 | Column 2 |
int | $row2 | Row 2 |
Definition at line 572 of file PageSetup.php.
References setPrintArea(), and PHPExcel_Cell\stringFromColumnIndex().
PHPExcel_Worksheet_PageSetup::setRowsToRepeatAtTop | ( | $pValue = null | ) |
Set Rows to repeat at top.
array | $pValue | Containing start column and end column, empty array if option unset |
Definition at line 468 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setRowsToRepeatAtTopByStartAndEnd | ( | $pStart = 1 , |
|
$pEnd = 1 |
|||
) |
Set Rows to repeat at top by start and end.
int | $pStart | |
int | $pEnd |
Definition at line 482 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setScale | ( | $pValue = 100 | ) |
Set Scale.
Print scaling. Valid values range from 10 to 400 This setting is overridden when fitToWidth and/or fitToHeight are in use
int? | $pValue |
Exception |
Definition at line 334 of file PageSetup.php.
PHPExcel_Worksheet_PageSetup::setVerticalCentered | ( | $value = false | ) |
Set center page vertically.
bool | $value |
Definition at line 522 of file PageSetup.php.
|
private |
Definition at line 227 of file PageSetup.php.
Referenced by getColumnsToRepeatAtLeft().
|
private |
Definition at line 212 of file PageSetup.php.
Referenced by getFitToHeight().
|
private |
Definition at line 220 of file PageSetup.php.
Referenced by getFitToWidth().
|
private |
Definition at line 241 of file PageSetup.php.
Referenced by getHorizontalCentered().
|
private |
Definition at line 194 of file PageSetup.php.
Referenced by getOrientation().
|
private |
Definition at line 187 of file PageSetup.php.
Referenced by getPaperSize().
|
private |
Definition at line 255 of file PageSetup.php.
Referenced by getPrintArea().
|
private |
Definition at line 234 of file PageSetup.php.
Referenced by getRowsToRepeatAtTop().
|
private |
Definition at line 204 of file PageSetup.php.
Referenced by getScale().
|
private |
Definition at line 248 of file PageSetup.php.
Referenced by getVerticalCentered().
const PHPExcel_Worksheet_PageSetup::ORIENTATION_DEFAULT = 'default' |
Definition at line 178 of file PageSetup.php.
Referenced by __construct().
const PHPExcel_Worksheet_PageSetup::ORIENTATION_LANDSCAPE = 'landscape' |
Definition at line 179 of file PageSetup.php.
Referenced by PHPExcel_Reader_Excel5\_readPageSetup(), and PHPExcel_Writer_Excel5_Worksheet\_storeSetup().
const PHPExcel_Worksheet_PageSetup::ORIENTATION_PORTRAIT = 'portrait' |
Definition at line 180 of file PageSetup.php.
Referenced by PHPExcel_Reader_Excel5\_readPageSetup().
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_6_3_4_ENVELOPE = 38 |
Definition at line 147 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A2_PAPER = 64 |
Definition at line 173 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3 = 8 |
Definition at line 117 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_EXTRA_PAPER = 61 |
Definition at line 170 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_EXTRA_TRANSVERSE_PAPER = 66 |
Definition at line 175 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A3_TRANSVERSE_PAPER = 65 |
Definition at line 174 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4 = 9 |
Definition at line 118 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_EXTRA_PAPER = 51 |
Definition at line 160 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_PLUS_PAPER = 58 |
Definition at line 167 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_SMALL = 10 |
Definition at line 119 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A4_TRANSVERSE_PAPER = 53 |
Definition at line 162 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5 = 11 |
Definition at line 120 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5_EXTRA_PAPER = 62 |
Definition at line 171 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_A5_TRANSVERSE_PAPER = 59 |
Definition at line 168 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_B4 = 12 |
Definition at line 121 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_B4_ENVELOPE = 33 |
Definition at line 142 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_B5 = 13 |
Definition at line 122 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_B5_ENVELOPE = 34 |
Definition at line 143 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_B6_ENVELOPE = 35 |
Definition at line 144 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_C = 24 |
Definition at line 133 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_C3_ENVELOPE = 29 |
Definition at line 138 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_C4_ENVELOPE = 30 |
Definition at line 139 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_C5_ENVELOPE = 28 |
Definition at line 137 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_C65_ENVELOPE = 32 |
Definition at line 141 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_C6_ENVELOPE = 31 |
Definition at line 140 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_D = 25 |
Definition at line 134 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_DL_ENVELOPE = 27 |
Definition at line 136 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_E = 26 |
Definition at line 135 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_EXECUTIVE = 7 |
Definition at line 116 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_FOLIO = 14 |
Definition at line 123 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_GERMAN_LEGAL_FANFOLD = 41 |
Definition at line 150 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_GERMAN_STANDARD_FANFOLD = 40 |
Definition at line 149 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_INVITE_ENVELOPE = 47 |
Definition at line 156 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_ISO_B4 = 42 |
Definition at line 151 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_ISO_B5_EXTRA_PAPER = 63 |
Definition at line 172 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_ITALY_ENVELOPE = 36 |
Definition at line 145 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_JAPANESE_DOUBLE_POSTCARD = 43 |
Definition at line 152 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_JIS_B5_TRANSVERSE_PAPER = 60 |
Definition at line 169 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEDGER = 4 |
Definition at line 113 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEGAL = 5 |
Definition at line 114 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LEGAL_EXTRA_PAPER = 49 |
Definition at line 158 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER = 1 |
Definition at line 110 of file PageSetup.php.
Referenced by __construct().
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_EXTRA_PAPER = 48 |
Definition at line 157 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_EXTRA_TRANSVERSE_PAPER = 54 |
Definition at line 163 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_PLUS_PAPER = 57 |
Definition at line 166 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_SMALL = 2 |
Definition at line 111 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_LETTER_TRANSVERSE_PAPER = 52 |
Definition at line 161 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_MONARCH_ENVELOPE = 37 |
Definition at line 146 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO10_ENVELOPE = 20 |
Definition at line 129 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO11_ENVELOPE = 21 |
Definition at line 130 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO12_ENVELOPE = 22 |
Definition at line 131 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO14_ENVELOPE = 23 |
Definition at line 132 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_NO9_ENVELOPE = 19 |
Definition at line 128 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_NOTE = 18 |
Definition at line 127 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_QUARTO = 15 |
Definition at line 124 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_1 = 16 |
Definition at line 125 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_2 = 17 |
Definition at line 126 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_1 = 44 |
Definition at line 153 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_2 = 45 |
Definition at line 154 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_STANDARD_PAPER_3 = 46 |
Definition at line 155 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_STATEMENT = 6 |
Definition at line 115 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_SUPERA_SUPERA_A4_PAPER = 55 |
Definition at line 164 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_SUPERB_SUPERB_A3_PAPER = 56 |
Definition at line 165 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_TABLOID = 3 |
Definition at line 112 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_TABLOID_EXTRA_PAPER = 50 |
Definition at line 159 of file PageSetup.php.
const PHPExcel_Worksheet_PageSetup::PAPERSIZE_US_STANDARD_FANFOLD = 39 |
Definition at line 148 of file PageSetup.php.