Gitee
\
OSS
Core
Http
Model
Result
Qcloud_cos
qcloudcos
Qiniu
Http
Processing
Storage
Testify
We7
Table
Account
Article
Core
Mc
Modules
Phoneapp
Qrcode
Rule
Site
Stat
Store
System
Uni
Userapi
Users
Wechat
Wxapp

\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.