Documentation

SheetView
in package

Table of Contents

Constants

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]

Properties

$sheetviewType  : string
View.
$showZeros  : bool
ShowZeros.
$zoomScale  : int|null
ZoomScale.
$zoomScaleNormal  : int|null
ZoomScaleNormal.
$zoomScalePageLayoutView  : int
ZoomScalePageLayoutView.
$zoomScaleSheetLayoutView  : int
ZoomScaleSheetLayoutView.

Methods

__construct()  : mixed
Create a new SheetView.
getShowZeros()  : bool
getView()  : string
Get View.
getZoomScale()  : int|null
Get ZoomScale.
getZoomScaleNormal()  : int|null
Get ZoomScaleNormal.
getZoomScalePageLayoutView()  : int
getZoomScaleSheetLayoutView()  : int
setShowZeros()  : void
Set ShowZeroes setting.
setView()  : $this
Set View.
setZoomScale()  : $this
Set ZoomScale.
setZoomScaleNormal()  : $this
Set ZoomScale.
setZoomScalePageLayoutView()  : static
setZoomScaleSheetLayoutView()  : static

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.

$zoomScalePageLayoutView

ZoomScalePageLayoutView.

private int $zoomScalePageLayoutView = 100

Valid values range from 10 to 400.

$zoomScaleSheetLayoutView

ZoomScaleSheetLayoutView.

private int $zoomScaleSheetLayoutView = 100

Valid values range from 10 to 400.

Methods

__construct()

Create a new SheetView.

public __construct() : 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

getZoomScalePageLayoutView()

public getZoomScalePageLayoutView() : int
Return values
int

getZoomScaleSheetLayoutView()

public getZoomScaleSheetLayoutView() : int
Return values
int

setShowZeros()

Set ShowZeroes setting.

public setShowZeros(bool $showZeros) : void
Parameters
$showZeros : bool

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

setZoomScalePageLayoutView()

public setZoomScalePageLayoutView(int $zoomScalePageLayoutView) : static
Parameters
$zoomScalePageLayoutView : int
Return values
static

setZoomScaleSheetLayoutView()

public setZoomScaleSheetLayoutView(int $zoomScaleSheetLayoutView) : static
Parameters
$zoomScaleSheetLayoutView : int
Return values
static 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results