PHPExcel_Style

# Class: PHPExcel_Style_NumberFormat Source Location: /PHPExcel/Style/NumberFormat.php
### Class Overview
PHPExcel_Style_NumberFormat #### Author(s): #### Copyright: Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel) Implements interfaces: PHPExcel_IComparable | ### Constants FORMAT_CURRENCY_EUR_SIMPLE FORMAT_CURRENCY_USD FORMAT_CURRENCY_USD_SIMPLE FORMAT_DATE_DATETIME FORMAT_DATE_DDMMYYYY FORMAT_DATE_DMMINUS FORMAT_DATE_DMYMINUS FORMAT_DATE_DMYSLASH FORMAT_DATE_MYMINUS FORMAT_DATE_TIME1 FORMAT_DATE_TIME2 FORMAT_DATE_TIME3 FORMAT_DATE_TIME4 FORMAT_DATE_TIME5 FORMAT_DATE_TIME6 FORMAT_DATE_TIME7 FORMAT_DATE_TIME8 FORMAT_DATE_XLSX14 FORMAT_DATE_XLSX15 FORMAT_DATE_XLSX16 FORMAT_DATE_XLSX17 FORMAT_DATE_XLSX22 FORMAT_DATE_YYYYMMDD FORMAT_DATE_YYYYMMDD2 FORMAT_DATE_YYYYMMDDSLASH FORMAT_GENERAL FORMAT_NUMBER FORMAT_NUMBER_00 FORMAT_NUMBER_COMMA_SEPARATED1 FORMAT_NUMBER_COMMA_SEPARATED2 FORMAT_PERCENTAGE FORMAT_PERCENTAGE_00 FORMAT_TEXT | ### Methods applyFromArray bindParent builtInFormatCode builtInFormatCodeIndex __construct getActiveCell getActiveSheet getBuiltInFormatCode getFormatCode getHashCode getIsSupervisor getSelectedCells getSharedComponent getStyleArray setBuiltInFormatCode setFormatCode toFormattedString __clone
### Class Details [line 36] PHPExcel_Style_NumberFormat #### Tags:
copyright: | Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
[ Top ] ### Class Methods ### static method builtInFormatCode [line 383]
`static string builtInFormatCode( int $pIndex)`
Get built-in format code #### Tags:
access: | public
#### Parameters:
int | $pIndex |
[ Top ] ### static method builtInFormatCodeIndex [line 405]
`static int|boolean builtInFormatCodeIndex( string $formatCode)`
Get built-in format code index #### Tags:
access: | public
#### Parameters:
string | $formatCode |
[ Top ] ### static method toFormattedString [line 501]
`static string toFormattedString( [mixed $value = ''], [string $format = ''], [array $callBack = null])`
Convert a value in a pre-defined format to a PHP string #### Tags:
return: | Formatted string
access: | public
#### Parameters:
mixed | $value | Value to format
string | $format | Format code
array | $callBack | Callback function for additional formatting of string
[ Top ] ### method applyFromArray [line 226]
`PHPExcel_Style_NumberFormat applyFromArray( [array $pStyles = null])`
Apply styles from array $objPHPExcel->getActiveSheet()->getStyle('B2')->getNumberFormat()->applyFromArray( array( 'code' => PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE ) ); #### Tags:
throws: | Exception
access: | public
#### Parameters:
array | $pStyles | Array containing style information
[ Top ] ### method bindParent [line 142]
`PHPExcel_Style_NumberFormat bindParent( PHPExcel_Style $parent)`
Bind parent. Only used for supervisor #### Tags:
access: | public
#### Parameters:
PHPExcel_Style | $parent |
[ Top ] ### constructor __construct [line 130]
`PHPExcel_Style_NumberFormat __construct( [ $isSupervisor = false])`
Create a new PHPExcel_Style_NumberFormat #### Tags:
access: | public
#### Parameters:
| $isSupervisor |
[ Top ] ### method getActiveCell [line 195]
`string getActiveCell( )`
Get the currently active cell coordinate in currently active sheet. Only used for supervisor #### Tags:
return: | E.g. 'A1'
access: | public
[ Top ] ### method getActiveSheet [line 173]
`PHPExcel_Worksheet getActiveSheet( )`
Get the currently active sheet. Only used for supervisor #### Tags:
access: | public
[ Top ] ### method getBuiltInFormatCode [line 285]
`int getBuiltInFormatCode( )`
Get Built-In Format Code #### Tags:
access: | public
[ Top ] ### method getFormatCode [line 247]
`string getFormatCode( )`
Get Format Code #### Tags:
access: | public
[ Top ] ### method getHashCode [line 423]
`string getHashCode( )`
Get hash code #### Tags:
return: | Hash code
access: | public
[ Top ] ### method getIsSupervisor [line 152]
`boolean getIsSupervisor( )`
Is this a supervisor or a real style component? #### Tags:
access: | public
[ Top ] ### method getSelectedCells [line 184]
`string getSelectedCells( )`
Get the currently active cell coordinate in currently active sheet. Only used for supervisor #### Tags:
return: | E.g. 'A1'
access: | public
[ Top ] ### method getSharedComponent [line 163]
`PHPExcel_Style_NumberFormat getSharedComponent( )`
Get the shared style component for the currently active cell in currently active sheet. Only used for style supervisor #### Tags:
access: | public
[ Top ] ### method getStyleArray [line 206]
`array getStyleArray( array $array)`
Build style array from subcomponents #### Tags:
access: | public
#### Parameters:
array | $array |
[ Top ] ### method setBuiltInFormatCode [line 299]
`PHPExcel_Style_NumberFormat setBuiltInFormatCode( [int $pValue = 0])`
Set Built-In Format Code #### Tags:
access: | public
#### Parameters:
int | $pValue |
[ Top ] ### method setFormatCode [line 265]
`PHPExcel_Style_NumberFormat setFormatCode( [string $pValue = PHPExcel_Style_NumberFormat::FORMAT_GENERAL])`
Set Format Code #### Tags:
access: | public
#### Parameters:
string | $pValue |
[ Top ] ### method __clone [line 438]
`void __clone( )`
Implement PHP __clone to create a deep clone, not just a shallow copy. #### Tags:
access: | public
[ Top ] ### Class Constants #### FORMAT_CURRENCY_EUR_SIMPLE = '[$EUR ]#,##0.00_-' [line 76] [ Top ] #### FORMAT_CURRENCY_USD = '$#,##0_-' [line 75] [ Top ] #### FORMAT_CURRENCY_USD_SIMPLE = '"$"#,##0.00_-' [line 74] [ Top ] #### FORMAT_DATE_DATETIME = 'd/m/y h:mm' [line 63] [ Top ] #### FORMAT_DATE_DDMMYYYY = 'dd/mm/yy' [line 53] [ Top ] #### FORMAT_DATE_DMMINUS = 'd-m' [line 56] [ Top ] #### FORMAT_DATE_DMYMINUS = 'd-m-y' [line 55] [ Top ] #### FORMAT_DATE_DMYSLASH = 'd/m/y' [line 54] [ Top ] #### FORMAT_DATE_MYMINUS = 'm-y' [line 57] [ Top ] #### FORMAT_DATE_TIME1 = 'h:mm AM/PM' [line 64] [ Top ] #### FORMAT_DATE_TIME2 = 'h:mm:ss AM/PM' [line 65] [ Top ] #### FORMAT_DATE_TIME3 = 'h:mm' [line 66] [ Top ] #### FORMAT_DATE_TIME4 = 'h:mm:ss' [line 67] [ Top ] #### FORMAT_DATE_TIME5 = 'mm:ss' [line 68] [ Top ] #### FORMAT_DATE_TIME6 = 'h:mm:ss' [line 69] [ Top ] #### FORMAT_DATE_TIME7 = 'i:s.S' [line 70] [ Top ] #### FORMAT_DATE_TIME8 = 'h:mm:ss;@' [line 71] [ Top ] #### FORMAT_DATE_XLSX14 = 'mm-dd-yy' [line 58] [ Top ] #### FORMAT_DATE_XLSX15 = 'd-mmm-yy' [line 59] [ Top ] #### FORMAT_DATE_XLSX16 = 'd-mmm' [line 60] [ Top ] #### FORMAT_DATE_XLSX17 = 'mmm-yy' [line 61] [ Top ] #### FORMAT_DATE_XLSX22 = 'm/d/yy h:mm' [line 62] [ Top ] #### FORMAT_DATE_YYYYMMDD = 'yy-mm-dd' [line 52] [ Top ] #### FORMAT_DATE_YYYYMMDD2 = 'yyyy-mm-dd' [line 51] [ Top ] #### FORMAT_DATE_YYYYMMDDSLASH = 'yy/mm/dd;@' [line 72] [ Top ] #### FORMAT_GENERAL = 'General' [line 39] [ Top ] #### FORMAT_NUMBER = '0' [line 43] [ Top ] #### FORMAT_NUMBER_00 = '0.00' [line 44] [ Top ] #### FORMAT_NUMBER_COMMA_SEPARATED1 = '#,##0.00' [line 45] [ Top ] #### FORMAT_NUMBER_COMMA_SEPARATED2 = '#,##0.00_-' [line 46] [ Top ] #### FORMAT_PERCENTAGE = '0%' [line 48] [ Top ] #### FORMAT_PERCENTAGE_00 = '0.00%' [line 49] [ Top ] #### FORMAT_TEXT = '@' [line 41] [ Top ] Documentation generated on Sun, 27 Feb 2011 16:32:51 -0800 by phpDocumentor 1.4.3