Documentation

Style

in package

• Application

Table of Contents

Constants

CELL_STYLE_PREFIX  = 'ce'

COLUMN_STYLE_PREFIX  = 'co'

INDENT_TO_INCHES  = 0.1043

ROW_STYLE_PREFIX  = 'ro'

TABLE_STYLE_PREFIX  = 'ta'

MAP_BORDER_STYLE  = [\PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOTTED => 'dotted', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHED => 'dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHED => 'dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOT => 'dash-dot', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOT => 'dash-dot', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOTDOT => 'dash-dot-dot', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOTDOT => 'dash-dot-dot', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_SLANTDASHDOT => 'dashed', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOUBLE => 'double', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_NONE => 'none']

MAP_BORDER_WIDTH  = [ \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THIN => '0.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHED => '0.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOT => '0.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DASHDOTDOT => '0.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOTTED => '0.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_HAIR => '0.75pt', // end of thin styles \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUM => '1.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHED => '1.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOT => '1.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_MEDIUMDASHDOTDOT => '1.75pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_SLANTDASHDOT => '1.75pt', // end of medium styles \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_DOUBLE => '2.5pt', \PhpOffice\PhpSpreadsheet\Style\Border::BORDER_THICK => '2.5pt', ]

NUMBER_FORMAT_METHODS  = [ \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER => [self::class, 'formatNumber'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_0 => [self::class, 'formatNumber0'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_00 => [self::class, 'formatNumber00'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1 => [self::class, 'formatNumberCommaSeparated1'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED2 => [self::class, 'formatNumberCommaSeparated2'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE => [self::class, 'formatPercentage'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_0 => [self::class, 'formatPercentage0'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_PERCENTAGE_00 => [self::class, 'formatPercentage00'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_YYYYMMDD => [self::class, 'formatDateYyyymmdd'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DDMMYYYY => [self::class, 'formatDateDdmmyyyy'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DMYSLASH => [self::class, 'formatDateDmyslash'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DMYMINUS => [self::class, 'formatDateDmyminus'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DMMINUS => [self::class, 'formatDateDmminus'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_MYMINUS => [self::class, 'formatDateMyminus'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX14 => [self::class, 'formatDateXlsx14'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX14_ACTUAL => [self::class, 'formatDateXlsx14Actual'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX15 => [self::class, 'formatDateXlsx15'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX15_YYYY => [self::class, 'formatDateXlsx15Yyyy'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX16 => [self::class, 'formatDateXlsx16'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX17 => [self::class, 'formatDateXlsx17'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX22 => [self::class, 'formatDateXlsx22'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_XLSX22_ACTUAL => [self::class, 'formatDateXlsx22Actual'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME => [self::class, 'formatDateDatetime'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_DATETIME_BETTER => [self::class, 'formatDateDatetimeBetter'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME1 => [self::class, 'formatDateTime1'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME2 => [self::class, 'formatDateTime2'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME3 => [self::class, 'formatDateTime3'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME4 => [self::class, 'formatDateTime4'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME5 => [self::class, 'formatDateTime5'], //NumberFormat::FORMAT_DATE_TIME6 => [self::class, 'formatDateTime6'], // FORMAT_DATE_TIME6 is identical to TIME4 \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME7 => [self::class, 'formatDateTime7'], // constant is probably mis-coded \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME8 => [self::class, 'formatDateTime8'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_TIME_INTERVAL_HMS => [self::class, 'formatDateTimeIntervalHms'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_YYYYMMDDSLASH => [self::class, 'formatDateYyyymmddslash'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_DATE_LONG_DATE => [self::class, 'formatDateLongDate'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_USD_INTEGER => [self::class, 'formatCurrencyUsdInteger'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_USD => [self::class, 'formatCurrencyUsd'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_ACCOUNTING_USD => [self::class, 'formatCurrencyUsd'], // ACCOUNTING and CURRENCY are same in Ods \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_EUR_INTEGER => [self::class, 'formatCurrencyEurInteger'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_EUR => [self::class, 'formatCurrencyEur'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_ACCOUNTING_EUR => [self::class, 'formatCurrencyEur'], // ACCOUNTING and CURRENCY are same in Ods \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_GBP_INTEGER => [self::class, 'formatCurrencyGbpInteger'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_GBP => [self::class, 'formatCurrencyGbp'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_YEN_YUAN_INTEGER => [self::class, 'formatCurrencyYenYuanInteger'], \PhpOffice\PhpSpreadsheet\Style\NumberFormat::FORMAT_CURRENCY_YEN_YUAN => [self::class, 'formatCurrencyYenYuan'], ]

PROTECTION_MAP  = [\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED => [\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED => 'protected formula-hidden', \PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_UNPROTECTED => 'protected'], \PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_UNPROTECTED => [\PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_PROTECTED => 'formula-hidden', \PhpOffice\PhpSpreadsheet\Style\Protection::PROTECTION_UNPROTECTED => 'none']]

Properties

$additionalNumberFormats  : array<string, callable>

$numFmtIndex  : int

$numFmtIndexes  : array<string, string>

$writer  : XMLWriter

Methods

__construct()  : mixed

getWriter()  : XMLWriter

write()  : void

writeColumnStyles()  : void

writeDefaultRowStyle()  : void

writeRowStyles()  : void

writeTableStyle()  : void

formatCurrencyEur()  : void

formatCurrencyEurInteger()  : void

formatCurrencyGbp()  : void

formatCurrencyGbpInteger()  : void

formatCurrencyUsd()  : void

formatCurrencyUsdInteger()  : void

formatCurrencyYenYuan()  : void

formatCurrencyYenYuanInteger()  : void

formatDateDatetime()  : void

formatDateDatetimeBetter()  : void

formatDateDdmmyyyy()  : void

formatDateDmminus()  : void

formatDateDmyminus()  : void

formatDateDmyslash()  : void

formatDateLongDate()  : void

formatDateMyminus()  : void

formatDateTime1()  : void

formatDateTime2()  : void

formatDateTime3()  : void

formatDateTime4()  : void

formatDateTime5()  : void

formatDateTime7()  : void

formatDateTime8()  : void

formatDateTimeIntervalHms()  : void

formatDateXlsx14()  : void

formatDateXlsx14Actual()  : void

formatDateXlsx15()  : void

formatDateXlsx15Yyyy()  : void

formatDateXlsx16()  : void

formatDateXlsx17()  : void

formatDateXlsx22()  : void

formatDateXlsx22Actual()  : void

formatDateYyyymmdd()  : void

formatDateYyyymmddslash()  : void

formatIntLeading0()  : void

formatNumber()  : void

formatNumber0()  : void

formatNumber00()  : void

formatNumberCommaSeparated1()  : void

formatNumberCommaSeparated2()  : void

formatPercentage()  : void

formatPercentage0()  : void

formatPercentage00()  : void

mapUnderlineStyle()  : string

writeColumnProperties()  : void

writeRowProperties()  : void

mapBorderStyle()  : string

mapBorderWidth()  : string

mapHorizontalAlignment()  : string

mapVerticalAlignment()  : string

writeBordersStyle()  : void

writeBorderStyle()  : void

writeFillStyle()  : void

writeNumFmt()  : void