Documentation

SheetView

Table of Contents

SHEETVIEW_NORMAL  = 'normal'
SHEETVIEW_PAGE_BREAK_PREVIEW  = 'pageBreakPreview'
SHEETVIEW_PAGE_LAYOUT  = 'pageLayout'
SHEET_VIEW_TYPES  = [self::SHEETVIEW_NORMAL, self::SHEETVIEW_PAGE_LAYOUT, self::SHEETVIEW_PAGE_BREAK_PREVIEW]
$sheetviewType  : string
View.
$showZeros  : bool
ShowZeros.
$zoomScale  : int|null
ZoomScale.
$zoomScaleNormal  : int|null
ZoomScaleNormal.
__construct()  : mixed
Create a new SheetView.
getShowZeros()  : bool
getView()  : string
Get View.
getZoomScale()  : int|null
Get ZoomScale.
getZoomScaleNormal()  : int|null
Get ZoomScaleNormal.
setShowZeros()  : void
Set ShowZeroes setting.
setView()  : $this
Set View.
setZoomScale()  : $this
Set ZoomScale.
setZoomScaleNormal()  : $this
Set ZoomScale.

Constants

SHEETVIEW_NORMAL

public mixed SHEETVIEW_NORMAL = 'normal'

SHEETVIEW_PAGE_BREAK_PREVIEW

public mixed SHEETVIEW_PAGE_BREAK_PREVIEW = 'pageBreakPreview'

SHEETVIEW_PAGE_LAYOUT

public mixed SHEETVIEW_PAGE_LAYOUT = 'pageLayout'

SHEET_VIEW_TYPES

private mixed SHEET_VIEW_TYPES = [self::SHEETVIEW_NORMAL, self::SHEETVIEW_PAGE_LAYOUT, self::SHEETVIEW_PAGE_BREAK_PREVIEW]

Properties

$sheetviewType

View.

private string $sheetviewType = self::SHEETVIEW_NORMAL

Valid values range from 10 to 400.

$showZeros

ShowZeros.

private bool $showZeros = true

If true, "null" values from a calculation will be shown as "0". This is the default Excel behaviour and can be changed with the advanced worksheet option "Show a zero in cells that have zero value"

$zoomScale

ZoomScale.

private int|null $zoomScale = 100

Valid values range from 10 to 400.

$zoomScaleNormal

ZoomScaleNormal.

private int|null $zoomScaleNormal = 100

Valid values range from 10 to 400.

Methods

__construct()

Create a new SheetView.

public __construct() : mixed
Return values
mixed —

getShowZeros()

public getShowZeros() : bool
Return values
bool —

getView()

Get View.

public getView() : string
Return values
string —

getZoomScale()

Get ZoomScale.

public getZoomScale() : int|null
Return values
int|null —

getZoomScaleNormal()

Get ZoomScaleNormal.

public getZoomScaleNormal() : int|null
Return values
int|null —

setShowZeros()

Set ShowZeroes setting.

public setShowZeros(bool $showZeros) : void
Parameters
$showZeros : bool
Return values
void —

setView()

Set View.

public setView(string|null $sheetViewType) : $this

Valid values are 'normal' self::SHEETVIEW_NORMAL 'pageLayout' self::SHEETVIEW_PAGE_LAYOUT 'pageBreakPreview' self::SHEETVIEW_PAGE_BREAK_PREVIEW

Parameters
$sheetViewType : string|null
Return values
$this —

setZoomScale()

Set ZoomScale.

public setZoomScale(int|null $zoomScale) : $this

Valid values range from 10 to 400.

Parameters
$zoomScale : int|null
Return values
$this —

setZoomScaleNormal()

Set ZoomScale.

public setZoomScaleNormal(int|null $zoomScaleNormal) : $this

Valid values range from 10 to 400.

Parameters
$zoomScaleNormal : int|null
Return values
$this —

Search results