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