Class PHPExcel_Style_NumberFormat
PHPExcel_Style_NumberFormat
- PHPExcel_Style_Supervisor
- PHPExcel_Style_NumberFormat implements PHPExcel_IComparable
Package: PHPExcel\Style
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Style/NumberFormat.php
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Style/NumberFormat.php
public
|
#
__construct( boolean $isSupervisor = FALSE, boolean $isConditional = FALSE )
Create a new PHPExcel_Style_NumberFormat |
public
|
#
getSharedComponent( )
Get the shared style component for the currently active cell in currently active sheet. Only used for style supervisor |
public
array
|
|
public
|
|
public
string
|
|
public
|
|
public
integer
|
|
public
|
|
private static
|
|
public static
string
|
|
public static
integer|boolean
|
|
public
string
|
|
private static
|
|
private static
|
|
private static
|
|
private static
|
|
public static
string
|
#
toFormattedString( mixed $value = '0', string $format =
Convert a value in a pre-defined format to a PHP string |
__clone(),
bindParent(),
getActiveCell(),
getActiveSheet(),
getIsSupervisor(),
getSelectedCells()
|
protected static
array
|
$_builtInFormats
Excel built-in number formats |
|
protected static
array
|
$_flippedBuiltInFormats
Excel built-in number formats (flipped, for faster lookups) |
|
protected
string
|
$_formatCode
Format Code |
|
protected
string
|
$_builtInFormatCode
Built-in format Code |
#
0
|
private static
array
|
$_dateFormatReplacements
Search/replace values to convert Excel date/time format masks to PHP format masks |
#
array(
// first remove escapes related to non-format characters
'\\' => '',
// 12-hour suffix
'am/pm' => 'A',
// 4-digit year
'e' => 'Y',
'yyyy' => 'Y',
// 2-digit year
'yy' => 'y',
// first letter of month - no php equivalent
'mmmmm' => 'M',
// full month name
'mmmm' => 'F',
// short month name
'mmm' => 'M',
// mm is minutes if time, but can also be month w/leading zero
// so we try to identify times be the inclusion of a : separator in the mask
// It isn't perfect, but the best way I know how
':mm' => ':i',
'mm:' => 'i:',
// month leading zero
'mm' => 'm',
// month no leading zero
'm' => 'n',
// full day of week name
'dddd' => 'l',
// short day of week name
'ddd' => 'D',
// days leading zero
'dd' => 'd',
// days no leading zero
'd' => 'j',
// seconds
'ss' => 's',
// fractional seconds - no php equivalent
'.s' => ''
)
|
private static
array
|
$_dateFormatReplacements24
Search/replace values to convert Excel date/time format masks hours to PHP format masks (24 hr clock) |
#
array(
'hh' => 'H',
'h' => 'G'
)
|
private static
array
|
$_dateFormatReplacements12
Search/replace values to convert Excel date/time format masks hours to PHP format masks (12 hr clock) |
#
array(
'hh' => 'h',
'h' => 'g'
)
|
$_isSupervisor,
$_parent
|