PHPExcel_Worksheet_Protection

category PHPExcel
package PHPExcel_Worksheet
copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

 Methods

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

__clone() 

Create a new PHPExcel_Worksheet_Protection

__construct() 

Get AutoFilter

getAutoFilter() : boolean

Returns

boolean

Get DeleteColumns

getDeleteColumns() : boolean

Returns

boolean

Get DeleteRows

getDeleteRows() : boolean

Returns

boolean

Get FormatCells

getFormatCells() : boolean

Returns

boolean

Get FormatColumns

getFormatColumns() : boolean

Returns

boolean

Get FormatRows

getFormatRows() : boolean

Returns

boolean

Get InsertColumns

getInsertColumns() : boolean

Returns

boolean

Get InsertRows

getInsertRows() : boolean

Returns

boolean

Get Objects

getObjects() : boolean

Returns

boolean

Get Password (hashed)

getPassword() : string

Returns

string

Get PivotTables

getPivotTables() : boolean

Returns

boolean

Get Scenarios

getScenarios() : boolean

Returns

boolean

Get SelectLockedCells

getSelectLockedCells() : boolean

Returns

boolean

Get SelectUnlockedCells

getSelectUnlockedCells() : boolean

Returns

boolean

Get Sheet

getSheet() : boolean

Returns

boolean

Get Sort

getSort() : boolean

Returns

boolean

Is some sort of protection enabled?

isProtectionEnabled() : boolean

Returns

boolean

Set AutoFilter

setAutoFilter(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set DeleteColumns

setDeleteColumns(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set DeleteRows

setDeleteRows(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set FormatCells

setFormatCells(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set FormatColumns

setFormatColumns(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set FormatRows

setFormatRows(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set InsertColumns

setInsertColumns(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set InsertRows

setInsertRows(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set Objects

setObjects(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set Password

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

Parameters

$pValue

string

$pAlreadyHashed

boolean

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

Returns

Set PivotTables

setPivotTables(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set Scenarios

setScenarios(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set SelectLockedCells

setSelectLockedCells(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set SelectUnlockedCells

setSelectUnlockedCells(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set Sheet

setSheet(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

Set Sort

setSort(boolean $pValue) : \PHPExcel_Worksheet_Protection

Parameters

$pValue

boolean

Returns

 Properties

 

$_autoFilter : boolean
 

$_deleteColumns : boolean
 

$_deleteRows : boolean
 

$_formatCells : boolean
 

$_formatColumns : boolean
 

$_formatRows : boolean
 

$_insertColumns : boolean
   

$_insertRows : boolean
 

$_objects : boolean
 

$_password : string
 

$_pivotTables : boolean
 

$_scenarios : boolean
 

$_selectLockedCells : boolean
 

$_selectUnlockedCells : boolean
 

$_sheet : boolean
 

$_sort : boolean