Gitee
\
app
admin
controller
model
validate
base
controller
chengji
controller
model
validate
event
facade
index
controller
kaohao
controller
model
validate
Kaoshi
controller
model
kaoshi
controller
model
validate
keti
controller
model
validate
Keti
model
listener
login
controller
validate
luru
controller
middleware
rongyu
controller
model
validate
student
controller
model
validate
studentSearchChengji
controller
system
controller
model
validate
teach
controller
model
validate
teacher
controller
model
validate
teacherSearchChengji
controller
tools
controller
model
zhengli
controller
Complex
Composer
Autoload
League
Flysystem
Adapter
Polyfill
Cached
Storage
Plugin
Util
liliuwei
think
Matrix
Operators
Opis
Closure
Overtrue
Pinyin
Phinx
Db
Adapter
Table
Migration
Seed
Util
PhpOffice
PhpSpreadsheet
Calculation
Engine
Token
Cell
Chart
Renderer
Collection
Document
Helper
Reader
Ods
Security
Xls
Color
Style
Xlsx
RichText
Shared
Escher
DgContainer
SpgrContainer
DggContainer
BstoreContainer
BSE
JAMA
OLE
PPS
Trend
Style
Worksheet
AutoFilter
Column
Drawing
Writer
Ods
Cell
Pdf
Xls
Xlsx
Psr
Cache
Container
Log
Test
SimpleCache
Samples
Sample09
Sample10
Sample12
Sample14
spec
League
Flysystem
Cached
Symfony
Component
VarDumper
Caster
Cloner
Command
Descriptor
Dumper
Exception
Server
Test
Polyfill
Mbstring
Php72
think
app
command
cache
driver
captcha
facade
console
command
make
optimize
input
output
descriptor
driver
formatter
question
contract
db
concern
connector
exception
event
exception
facade
file
filesystem
driver
helper
initializer
log
driver
middleware
migration
command
factory
migrate
seed
db
model
concern
relation
paginator
driver
response
route
dispatch
service
session
driver
template
driver
exception
taglib
tests
trace
validate
view
driver
WhiteHat101
Crypt

\PhpOffice\PhpSpreadsheet\WorksheetProtection

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

isProtectionEnabled()

isProtectionEnabled() : boolean

Is some sort of protection enabled?

Returns

boolean

getSheet()

getSheet() : boolean

Get Sheet.

Returns

boolean

setSheet()

setSheet(boolean  $pValue) : $this

Set Sheet.

Parameters

boolean $pValue

Returns

$this

getObjects()

getObjects() : boolean

Get Objects.

Returns

boolean

setObjects()

setObjects(boolean  $pValue) : $this

Set Objects.

Parameters

boolean $pValue

Returns

$this

getScenarios()

getScenarios() : boolean

Get Scenarios.

Returns

boolean

setScenarios()

setScenarios(boolean  $pValue) : $this

Set Scenarios.

Parameters

boolean $pValue

Returns

$this

getFormatCells()

getFormatCells() : boolean

Get FormatCells.

Returns

boolean

setFormatCells()

setFormatCells(boolean  $pValue) : $this

Set FormatCells.

Parameters

boolean $pValue

Returns

$this

getFormatColumns()

getFormatColumns() : boolean

Get FormatColumns.

Returns

boolean

setFormatColumns()

setFormatColumns(boolean  $pValue) : $this

Set FormatColumns.

Parameters

boolean $pValue

Returns

$this

getFormatRows()

getFormatRows() : boolean

Get FormatRows.

Returns

boolean

setFormatRows()

setFormatRows(boolean  $pValue) : $this

Set FormatRows.

Parameters

boolean $pValue

Returns

$this

getInsertColumns()

getInsertColumns() : boolean

Get InsertColumns.

Returns

boolean

setInsertColumns()

setInsertColumns(boolean  $pValue) : $this

Set InsertColumns.

Parameters

boolean $pValue

Returns

$this

getInsertRows()

getInsertRows() : boolean

Get InsertRows.

Returns

boolean

setInsertRows()

setInsertRows(boolean  $pValue) : $this

Set InsertRows.

Parameters

boolean $pValue

Returns

$this

getInsertHyperlinks()

getInsertHyperlinks() : boolean

Get InsertHyperlinks.

Returns

boolean

setInsertHyperlinks()

setInsertHyperlinks(boolean  $pValue) : $this

Set InsertHyperlinks.

Parameters

boolean $pValue

Returns

$this

getDeleteColumns()

getDeleteColumns() : boolean

Get DeleteColumns.

Returns

boolean

setDeleteColumns()

setDeleteColumns(boolean  $pValue) : $this

Set DeleteColumns.

Parameters

boolean $pValue

Returns

$this

getDeleteRows()

getDeleteRows() : boolean

Get DeleteRows.

Returns

boolean

setDeleteRows()

setDeleteRows(boolean  $pValue) : $this

Set DeleteRows.

Parameters

boolean $pValue

Returns

$this

getSelectLockedCells()

getSelectLockedCells() : boolean

Get SelectLockedCells.

Returns

boolean

setSelectLockedCells()

setSelectLockedCells(boolean  $pValue) : $this

Set SelectLockedCells.

Parameters

boolean $pValue

Returns

$this

getSort()

getSort() : boolean

Get Sort.

Returns

boolean

setSort()

setSort(boolean  $pValue) : $this

Set Sort.

Parameters

boolean $pValue

Returns

$this

getAutoFilter()

getAutoFilter() : boolean

Get AutoFilter.

Returns

boolean

setAutoFilter()

setAutoFilter(boolean  $pValue) : $this

Set AutoFilter.

Parameters

boolean $pValue

Returns

$this

getPivotTables()

getPivotTables() : boolean

Get PivotTables.

Returns

boolean

setPivotTables()

setPivotTables(boolean  $pValue) : $this

Set PivotTables.

Parameters

boolean $pValue

Returns

$this

getSelectUnlockedCells()

getSelectUnlockedCells() : boolean

Get SelectUnlockedCells.

Returns

boolean

setSelectUnlockedCells()

setSelectUnlockedCells(boolean  $pValue) : $this

Set SelectUnlockedCells.

Parameters

boolean $pValue

Returns

$this

getPassword()

getPassword() : string

Get Password (hashed).

Returns

string

setPassword()

setPassword(string  $pValue, boolean  $pAlreadyHashed = false) : $this

Set Password.

Parameters

string $pValue
boolean $pAlreadyHashed

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

Returns

$this

__clone()

__clone()

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