Gitee
\
admin
login
classes
systemlog
classes
Composer
Autoload
core
dzz
Guzzle
Tests
Service
Description
GuzzleHttp
Command
Exception
Guzzle
Handler
QuerySerializer
RequestLocation
ResponseLocation
Cookie
Exception
Handler
Promise
Psr7
Tests
Command
Guzzle
Asset
Exception
Handler
QuerySerializer
RequestLocation
ResponseLocation
misc
classes
Psr
Http
Message
Qcloud
Cos
Exception
Request
Tests
user
classes
login
classes
profile
classes
register
classes
sso
classes

\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 : bool

Sheet

Type

bool —

$_objects

$_objects : bool

Objects

Type

bool —

$_scenarios

$_scenarios : bool

Scenarios

Type

bool —

$_formatCells

$_formatCells : bool

Format cells

Type

bool —

$_formatColumns

$_formatColumns : bool

Format columns

Type

bool —

$_formatRows

$_formatRows : bool

Format rows

Type

bool —

$_insertColumns

$_insertColumns : bool

Insert columns

Type

bool —

$_insertRows

$_insertRows : bool

Insert rows

Type

bool —

$_insertHyperlinks

$_insertHyperlinks : bool

Insert hyperlinks

Type

bool —

$_deleteColumns

$_deleteColumns : bool

Delete columns

Type

bool —

$_deleteRows

$_deleteRows : bool

Delete rows

Type

bool —

$_selectLockedCells

$_selectLockedCells : bool

Select locked cells

Type

bool —

$_sort

$_sort : bool

Sort

Type

bool —

$_autoFilter

$_autoFilter : bool

AutoFilter

Type

bool —

$_pivotTables

$_pivotTables : bool

Pivot tables

Type

bool —

$_selectUnlockedCells

$_selectUnlockedCells : bool

Select unlocked cells

Type

bool —

$_password

$_password : string

Password

Type

string —

Methods

__construct()

__construct() : mixed

Create a new PHPExcel_Worksheet_Protection

Returns

mixed —

isProtectionEnabled()

isProtectionEnabled() : bool

Is some sort of protection enabled?

Returns

bool —

getSheet()

getSheet() : bool

Get Sheet

Returns

bool —

setSheet()

setSheet(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Sheet

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getObjects()

getObjects() : bool

Get Objects

Returns

bool —

setObjects()

setObjects(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Objects

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getScenarios()

getScenarios() : bool

Get Scenarios

Returns

bool —

setScenarios()

setScenarios(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Scenarios

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getFormatCells()

getFormatCells() : bool

Get FormatCells

Returns

bool —

setFormatCells()

setFormatCells(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set FormatCells

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getFormatColumns()

getFormatColumns() : bool

Get FormatColumns

Returns

bool —

setFormatColumns()

setFormatColumns(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set FormatColumns

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getFormatRows()

getFormatRows() : bool

Get FormatRows

Returns

bool —

setFormatRows()

setFormatRows(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set FormatRows

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getInsertColumns()

getInsertColumns() : bool

Get InsertColumns

Returns

bool —

setInsertColumns()

setInsertColumns(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set InsertColumns

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getInsertRows()

getInsertRows() : bool

Get InsertRows

Returns

bool —

setInsertRows()

setInsertRows(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set InsertRows

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getInsertHyperlinks()

getInsertHyperlinks() : bool

Get InsertHyperlinks

Returns

bool —

setInsertHyperlinks()

setInsertHyperlinks(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set InsertHyperlinks

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getDeleteColumns()

getDeleteColumns() : bool

Get DeleteColumns

Returns

bool —

setDeleteColumns()

setDeleteColumns(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set DeleteColumns

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getDeleteRows()

getDeleteRows() : bool

Get DeleteRows

Returns

bool —

setDeleteRows()

setDeleteRows(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set DeleteRows

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getSelectLockedCells()

getSelectLockedCells() : bool

Get SelectLockedCells

Returns

bool —

setSelectLockedCells()

setSelectLockedCells(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set SelectLockedCells

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getSort()

getSort() : bool

Get Sort

Returns

bool —

setSort()

setSort(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set Sort

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getAutoFilter()

getAutoFilter() : bool

Get AutoFilter

Returns

bool —

setAutoFilter()

setAutoFilter(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set AutoFilter

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getPivotTables()

getPivotTables() : bool

Get PivotTables

Returns

bool —

setPivotTables()

setPivotTables(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set PivotTables

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getSelectUnlockedCells()

getSelectUnlockedCells() : bool

Get SelectUnlockedCells

Returns

bool —

setSelectUnlockedCells()

setSelectUnlockedCells(bool  $pValue = false) : \PHPExcel_Worksheet_Protection

Set SelectUnlockedCells

Parameters

bool $pValue

Returns

\PHPExcel_Worksheet_Protection —

getPassword()

getPassword() : string

Get Password (hashed)

Returns

string —

setPassword()

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

Set Password

Parameters

string $pValue
bool $pAlreadyHashed

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

Returns

\PHPExcel_Worksheet_Protection —

__clone()

__clone() : mixed

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

Returns

mixed —