Gitee
\
addons
formmore
controller
model
validate
loginerror
controller
model
pagemore
controller
model
validate
speed
controller
app
index
behavior
controller
model
validate
org
think
cache
driver
config
driver
console
command
make
optimize
input
output
descriptor
driver
formatter
question
controller
db
builder
connector
exception
debug
exception
log
driver
model
relation
paginator
driver
process
exception
pipes
response
session
driver
template
driver
taglib
view
driver
traits
controller
model
think

\PHPExcel_Worksheet_Protection

PHPExcel_Worksheet_Protection

Summary

Methods
Properties
Constants
__construct()
isProtectionEnabled()
getSheet()
setSheet()
getObjects()
setObjects()
getScenarios()
setScenarios()
getFormatCells()
setFormatCells()
getFormatColumns()
setFormatColumns()
getFormatRows()
setFormatRows()
getInsertColumns()
setInsertColumns()
getInsertRows()
setInsertRows()
getInsertHyperlinks()
setInsertHyperlinks()
getDeleteColumns()
setDeleteColumns()
getDeleteRows()
setDeleteRows()
getSelectLockedCells()
setSelectLockedCells()
getSort()
setSort()
getAutoFilter()
setAutoFilter()
getPivotTables()
setPivotTables()
getSelectUnlockedCells()
setSelectUnlockedCells()
getPassword()
setPassword()
__clone()
No public properties found
No constants found
No protected methods found
No protected properties found
N/A
No private methods found
$sheet
$objects
$scenarios
$formatCells
$formatColumns
$formatRows
$insertColumns
$insertRows
$insertHyperlinks
$deleteColumns
$deleteRows
$selectLockedCells
$sort
$autoFilter
$pivotTables
$selectUnlockedCells
$password
N/A

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.