Properties

$_sheet

$_sheet : boolean

Sheet

Type

boolean

$_objects

$_objects : boolean

Objects

Type

boolean

$_scenarios

$_scenarios : boolean

Scenarios

Type

boolean

$_formatCells

$_formatCells : boolean

Format cells

Type

boolean

$_formatColumns

$_formatColumns : boolean

Format columns

Type

boolean

$_formatRows

$_formatRows : boolean

Format rows

Type

boolean

$_insertColumns

$_insertColumns : boolean

Insert columns

Type

boolean

$_insertRows

$_insertRows : boolean

Insert rows

Type

boolean

$_insertHyperlinks

$_insertHyperlinks : boolean

Insert hyperlinks

Type

boolean

$_deleteColumns

$_deleteColumns : boolean

Delete columns

Type

boolean

$_deleteRows

$_deleteRows : boolean

Delete rows

Type

boolean

$_selectLockedCells

$_selectLockedCells : boolean

Select locked cells

Type

boolean

$_sort

$_sort : boolean

Sort

Type

boolean

$_autoFilter

$_autoFilter : boolean

AutoFilter

Type

boolean

$_pivotTables

$_pivotTables : boolean

Pivot tables

Type

boolean

$_selectUnlockedCells

$_selectUnlockedCells : boolean

Select unlocked cells

Type

boolean

$_password

$_password : string

Password

Type

string

Methods

__construct()

__construct() 

Create a new PHPExcel_Worksheet_Protection

isProtectionEnabled()

isProtectionEnabled() : boolean

Is some sort of protection enabled?

Returns

boolean

getSheet()

getSheet() : boolean

Get Sheet

Returns

boolean

setSheet()

setSheet(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Sheet

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getObjects()

getObjects() : boolean

Get Objects

Returns

boolean

setObjects()

setObjects(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Objects

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getScenarios()

getScenarios() : boolean

Get Scenarios

Returns

boolean

setScenarios()

setScenarios(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Scenarios

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getFormatCells()

getFormatCells() : boolean

Get FormatCells

Returns

boolean

setFormatCells()

setFormatCells(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set FormatCells

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getFormatColumns()

getFormatColumns() : boolean

Get FormatColumns

Returns

boolean

setFormatColumns()

setFormatColumns(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set FormatColumns

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getFormatRows()

getFormatRows() : boolean

Get FormatRows

Returns

boolean

setFormatRows()

setFormatRows(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set FormatRows

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getInsertColumns()

getInsertColumns() : boolean

Get InsertColumns

Returns

boolean

setInsertColumns()

setInsertColumns(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set InsertColumns

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getInsertRows()

getInsertRows() : boolean

Get InsertRows

Returns

boolean

setInsertRows()

setInsertRows(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set InsertRows

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getInsertHyperlinks()

getInsertHyperlinks() : boolean

Get InsertHyperlinks

Returns

boolean

setInsertHyperlinks()

setInsertHyperlinks(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set InsertHyperlinks

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getDeleteColumns()

getDeleteColumns() : boolean

Get DeleteColumns

Returns

boolean

setDeleteColumns()

setDeleteColumns(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set DeleteColumns

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getDeleteRows()

getDeleteRows() : boolean

Get DeleteRows

Returns

boolean

setDeleteRows()

setDeleteRows(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set DeleteRows

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getSelectLockedCells()

getSelectLockedCells() : boolean

Get SelectLockedCells

Returns

boolean

setSelectLockedCells()

setSelectLockedCells(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set SelectLockedCells

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getSort()

getSort() : boolean

Get Sort

Returns

boolean

setSort()

setSort(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Sort

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getAutoFilter()

getAutoFilter() : boolean

Get AutoFilter

Returns

boolean

setAutoFilter()

setAutoFilter(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set AutoFilter

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getPivotTables()

getPivotTables() : boolean

Get PivotTables

Returns

boolean

setPivotTables()

setPivotTables(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set PivotTables

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getSelectUnlockedCells()

getSelectUnlockedCells() : boolean

Get SelectUnlockedCells

Returns

boolean

setSelectUnlockedCells()

setSelectUnlockedCells(boolean  $pValue = false) : \PHPExcel_Worksheet_Protection

Set SelectUnlockedCells

Parameters

boolean $pValue

Returns

\PHPExcel_Worksheet_Protection

getPassword()

getPassword() : string

Get Password (hashed)

Returns

string

setPassword()

setPassword(string  $pValue = '', boolean  $pAlreadyHashed = false) : \PHPExcel_Worksheet_Protection

Set Password

Parameters

string $pValue
boolean $pAlreadyHashed

If the password has already been hashed, set this to true

Returns

\PHPExcel_Worksheet_Protection

__clone()

__clone() 

Implement PHP __clone to create a deep clone, not just a shallow copy.