Gitee
\
app
admin
controller
model
validate
chengji
controller
model
validate
common
controller
model
validate
home
controller
http
middleware
index
controller
kaoshi
controller
model
validate
Keti
model
keti
controller
model
validate
login
controller
validate
member
controller
renshi
controller
model
validate
rongyu
controller
model
validate
system
controller
model
validate
teach
controller
model
validate
BaconQrCode
Common
Encoder
Exception
Renderer
Color
Image
Decorator
Text
Common
Tests
Adapter
Zip
Complex
Composer
Autoload
Endroid
Installer
Tests
QrCode
Exception
Factory
Response
Tests
Writer
Khanamiryan
QrCodeTests
MyCLabs
Enum
Phinx
Db
Adapter
Table
Migration
Seed
Util
php4world
PhpOffice
Common
Adapter
Zip
Microsoft
Tests
Microsoft
PhpPowerpoint
Tests
PhpSpreadsheet
Calculation
Engine
Token
Cell
Chart
Renderer
Collection
Document
Helper
Reader
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
PhpWord
Collection
ComplexType
Element
Escaper
Exception
Metadata
Reader
ODText
RTF
Word2007
Shared
SimpleType
Style
Writer
HTML
Element
Part
Style
ODText
Element
Part
Style
PDF
RTF
Element
Part
Style
Word2007
Element
Part
Style
Psr
SimpleCache
Samples
Sample09
Sample10
Sample12
Sample14
Symfony
Component
Inflector
Tests
OptionsResolver
Debug
Exception
Tests
Debug
PropertyAccess
Exception
Tests
Fixtures
Polyfill
Ctype
think
cache
driver
captcha
composer
config
driver
console
command
make
optimize
input
output
descriptor
driver
formatter
question
db
builder
connector
exception
debug
exception
facade
helper
hash
log
driver
migration
command
migrate
seed
db
model
concern
relation
paginator
driver
process
exception
pipes
response
route
dispatch
session
driver
template
driver
taglib
validate
view
driver
traits
controller
WhiteHat101
Crypt
Zend
Escaper
Exception
Zxing
Common
CharacterSetEci
AbstractEnum
Detector
Reedsolomon
Qrcode
Decoder
Detector

\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

getObjects()

getObjects() : boolean

Get Objects.

Returns

boolean

getScenarios()

getScenarios() : boolean

Get Scenarios.

Returns

boolean

getFormatCells()

getFormatCells() : boolean

Get FormatCells.

Returns

boolean

getFormatColumns()

getFormatColumns() : boolean

Get FormatColumns.

Returns

boolean

getFormatRows()

getFormatRows() : boolean

Get FormatRows.

Returns

boolean

getInsertColumns()

getInsertColumns() : boolean

Get InsertColumns.

Returns

boolean

getInsertRows()

getInsertRows() : boolean

Get InsertRows.

Returns

boolean

getInsertHyperlinks()

getInsertHyperlinks() : boolean

Get InsertHyperlinks.

Returns

boolean

getDeleteColumns()

getDeleteColumns() : boolean

Get DeleteColumns.

Returns

boolean

getDeleteRows()

getDeleteRows() : boolean

Get DeleteRows.

Returns

boolean

getSelectLockedCells()

getSelectLockedCells() : boolean

Get SelectLockedCells.

Returns

boolean

getSort()

getSort() : boolean

Get Sort.

Returns

boolean

getAutoFilter()

getAutoFilter() : boolean

Get AutoFilter.

Returns

boolean

getPivotTables()

getPivotTables() : boolean

Get PivotTables.

Returns

boolean

getSelectUnlockedCells()

getSelectUnlockedCells() : boolean

Get SelectUnlockedCells.

Returns

boolean

getPassword()

getPassword() : string

Get Password (hashed).

Returns

string

setPassword()

setPassword(string  $pValue, boolean  $pAlreadyHashed = false) : \PhpOffice\PhpSpreadsheet\Worksheet\Protection

Set Password.

Parameters

string $pValue
boolean $pAlreadyHashed

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

Returns

\PhpOffice\PhpSpreadsheet\Worksheet\Protection

__clone()

__clone()

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