PHPExcel_Style_NumberFormat Class Reference

Inheritance diagram for PHPExcel_Style_NumberFormat:

Collaboration diagram for PHPExcel_Style_NumberFormat:

Public Member Functions
	__construct ($isSupervisor=false)
	Create a new PHPExcel_Style_NumberFormat.
	bindParent ($parent)
	Bind parent.
	getIsSupervisor ()
	Is this a supervisor or a real style component?
	getSharedComponent ()
	Get the shared style component for the currently active cell in currently active sheet.
	getActiveSheet ()
	Get the currently active sheet.
	getXSelectedCells ()
	Get the currently active cell coordinate in currently active sheet.
	getXActiveCell ()
	Get the currently active cell coordinate in currently active sheet.
	getStyleArray ($array)
	Build style array from subcomponents.
	applyFromArray ($pStyles=null)
	Apply styles from array.
	getFormatCode ()
	Get Format Code.
	setFormatCode ($pValue=PHPExcel_Style_NumberFormat::FORMAT_GENERAL)
	Set Format Code.
	getBuiltInFormatCode ()
	Get Built-In Format Code.
	setBuiltInFormatCode ($pValue=0)
	Set Built-In Format Code.
	getHashCode ()
	Get hash code.
	getHashIndex ()
	Get hash index.
	setHashIndex ($value)
	Set hash index.
	__clone ()
	Implement PHP __clone to create a deep clone, not just a shallow copy.

Static Public Member Functions
static	builtInFormatCode ($pIndex)
	Get built-in format code.
static	builtInFormatCodeIndex ($formatCode)
	Get built-in format code index.
static	toFormattedString ($value= '', $format= '')
	Convert a value in a pre-defined format to a PHP string.

Data Fields
const	FORMAT_GENERAL = 'General'
const	FORMAT_TEXT = '@'
const	FORMAT_NUMBER = '0'
const	FORMAT_NUMBER_00 = '0.00'
const	FORMAT_NUMBER_COMMA_SEPARATED1 = '#,##0.00'
const	FORMAT_NUMBER_COMMA_SEPARATED2 = '#,##0.00_-'
const	FORMAT_PERCENTAGE = '0%'
const	FORMAT_PERCENTAGE_00 = '0.00%'
const	FORMAT_DATE_YYYYMMDD2 = 'yyyy-mm-dd'
const	FORMAT_DATE_YYYYMMDD = 'yy-mm-dd'
const	FORMAT_DATE_DDMMYYYY = 'dd/mm/yy'
const	FORMAT_DATE_DMYSLASH = 'd/m/y'
const	FORMAT_DATE_DMYMINUS = 'd-m-y'
const	FORMAT_DATE_DMMINUS = 'd-m'
const	FORMAT_DATE_MYMINUS = 'm-y'
const	FORMAT_DATE_XLSX14 = 'mm-dd-yy'
const	FORMAT_DATE_XLSX15 = 'd-mmm-yy'
const	FORMAT_DATE_XLSX16 = 'd-mmm'
const	FORMAT_DATE_XLSX17 = 'mmm-yy'
const	FORMAT_DATE_XLSX22 = 'm/d/yy h:mm'
const	FORMAT_DATE_DATETIME = 'd/m/y h:mm'
const	FORMAT_DATE_TIME1 = 'h:mm AM/PM'
const	FORMAT_DATE_TIME2 = 'h:mm:ss AM/PM'
const	FORMAT_DATE_TIME3 = 'h:mm'
const	FORMAT_DATE_TIME4 = 'h:mm:ss'
const	FORMAT_DATE_TIME5 = 'mm:ss'
const	FORMAT_DATE_TIME6 = 'h:mm:ss'
const	FORMAT_DATE_TIME7 = 'i:s.S'
const	FORMAT_DATE_TIME8 = 'h:mm:ss;@'
const	FORMAT_DATE_YYYYMMDDSLASH = 'yy/mm/dd;@'
const	FORMAT_CURRENCY_USD_SIMPLE = '"$"#,##0.00_-'
const	FORMAT_CURRENCY_USD = '$#,##0_-'
const	FORMAT_CURRENCY_EUR_SIMPLE = '[$EUR ]#,##0.00_-'

Static Private Member Functions
static	fillBuiltInFormatCodes ()
	Fill built-in format codes.

Private Attributes
	$_formatCode
	$_builtInFormatCode
	$_parentPropertyName
	$_isSupervisor
	$_parent
	$_hashIndex

Static Private Attributes
static	$_builtInFormats
static	$_flippedBuiltInFormats

Detailed Description

Definition at line 54 of file NumberFormat.php.

Constructor & Destructor Documentation

PHPExcel_Style_NumberFormat::__construct

(

$isSupervisor = false

)

Create a new PHPExcel_Style_NumberFormat.

Definition at line 148 of file NumberFormat.php.

References FORMAT_GENERAL.

    {
        // Supervisor?
                $this->_isSupervisor = $isSupervisor;

        // Initialise values
        $this->_formatCode                      = PHPExcel_Style_NumberFormat::FORMAT_GENERAL;
        $this->_builtInFormatCode       = 0;
    }

Member Function Documentation

PHPExcel_Style_NumberFormat::__clone

(

)

Implement PHP __clone to create a deep clone, not just a shallow copy.

Definition at line 483 of file NumberFormat.php.

References $key.

                                  {
                $vars = get_object_vars($this);
                foreach ($vars as $key => $value) {
                        if (is_object($value)) {
                                $this->$key = clone $value;
                        } else {
                                $this->$key = $value;
                        }
                }
        }

PHPExcel_Style_NumberFormat::applyFromArray

(

$pStyles = null

)

Apply styles from array.

$objPHPExcel->getActiveSheet()->getStyle('B2')->getNumberFormat()->applyFromArray( array( 'code' => PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE ) );

Parameters

array

$pStyles

Array containing style information

Exceptions

Exception

Returns

PHPExcel_Style_NumberFormat

Definition at line 248 of file NumberFormat.php.

References getActiveSheet(), getStyleArray(), getXSelectedCells(), and setFormatCode().

                                                        {
                if (is_array($pStyles)) {
                        if ($this->_isSupervisor) {
                                $this->getActiveSheet()->getStyle($this->getXSelectedCells())->applyFromArray($this->getStyleArray($pStyles));
                        } else {
                                if (array_key_exists('code', $pStyles)) {
                                        $this->setFormatCode($pStyles['code']);
                                }
                        }
                } else {
                        throw new Exception("Invalid style array passed.");
                }
                return $this;
        }

Here is the call graph for this function:

PHPExcel_Style_NumberFormat::bindParent

(

$parent

)

Bind parent.

Only used for supervisor

Parameters

PHPExcel_Style

$parent

Returns

PHPExcel_Style_NumberFormat

Definition at line 164 of file NumberFormat.php.

        {
                $this->_parent = $parent;
        }

static PHPExcel_Style_NumberFormat::builtInFormatCode (   $pIndex )

static

Get built-in format code.

Parameters

int

$pIndex

Returns

string

Definition at line 400 of file NumberFormat.php.

References fillBuiltInFormatCodes().

Referenced by PHPExcel_Reader_Excel5\_readXf(), getFormatCode(), PHPExcel_Reader_Excel2007\load(), and setBuiltInFormatCode().

                                                      {
        // Clean parameter
                $pIndex = intval($pIndex);

                // Ensure built-in format codes are available
        self::fillBuiltInFormatCodes();

                // Lookup format code
                if (array_key_exists($pIndex, self::$_builtInFormats)) {
                        return self::$_builtInFormats[$pIndex];
                }

        return '';
    }

Here is the call graph for this function:

Here is the caller graph for this function:

static PHPExcel_Style_NumberFormat::builtInFormatCodeIndex (   $formatCode )

static

Get built-in format code index.

Parameters

string

$formatCode

Returns

int|boolean

Definition at line 421 of file NumberFormat.php.

References fillBuiltInFormatCodes().

Referenced by setFormatCode().

                                                               {
        // Ensure built-in format codes are available
        self::fillBuiltInFormatCodes();

                // Lookup format code
                if (array_key_exists($formatCode, self::$_flippedBuiltInFormats)) {
                        return self::$_flippedBuiltInFormats[$formatCode];
                }

        return false;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

static PHPExcel_Style_NumberFormat::fillBuiltInFormatCodes ( )

staticprivate

Fill built-in format codes.

Definition at line 332 of file NumberFormat.php.

Referenced by builtInFormatCode(), and builtInFormatCodeIndex().

    {
        // Built-in format codes
        if (is_null(self::$_builtInFormats)) {
                        self::$_builtInFormats = array();

                        // General
                        self::$_builtInFormats[0] = 'General';
                        self::$_builtInFormats[1] = '0';
                        self::$_builtInFormats[2] = '0.00';
                        self::$_builtInFormats[3] = '#,##0';
                        self::$_builtInFormats[4] = '#,##0.00';

                        self::$_builtInFormats[9] = '0%';
                        self::$_builtInFormats[10] = '0.00%';
                        self::$_builtInFormats[11] = '0.00E+00';
                        self::$_builtInFormats[12] = '# ?/?';
                        self::$_builtInFormats[13] = '# ??/??';
                        self::$_builtInFormats[14] = 'mm-dd-yy';
                        self::$_builtInFormats[15] = 'd-mmm-yy';
                        self::$_builtInFormats[16] = 'd-mmm';
                        self::$_builtInFormats[17] = 'mmm-yy';
                        self::$_builtInFormats[18] = 'h:mm AM/PM';
                        self::$_builtInFormats[19] = 'h:mm:ss AM/PM';
                        self::$_builtInFormats[20] = 'h:mm';
                        self::$_builtInFormats[21] = 'h:mm:ss';
                        self::$_builtInFormats[22] = 'm/d/yy h:mm';

                        self::$_builtInFormats[37] = '#,##0 ;(#,##0)';
                        self::$_builtInFormats[38] = '#,##0 ;[Red](#,##0)';
                        self::$_builtInFormats[39] = '#,##0.00;(#,##0.00)';
                        self::$_builtInFormats[40] = '#,##0.00;[Red](#,##0.00)';

                        self::$_builtInFormats[44] = '_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)';
                        self::$_builtInFormats[45] = 'mm:ss';
                        self::$_builtInFormats[46] = '[h]:mm:ss';
                        self::$_builtInFormats[47] = 'mmss.0';
                        self::$_builtInFormats[48] = '##0.0E+0';
                        self::$_builtInFormats[49] = '@';

                        // CHT
                        self::$_builtInFormats[27] = '[$-404]e/m/d';
                        self::$_builtInFormats[30] = 'm/d/yy';
                        self::$_builtInFormats[36] = '[$-404]e/m/d';
                        self::$_builtInFormats[50] = '[$-404]e/m/d';
                        self::$_builtInFormats[57] = '[$-404]e/m/d';

                        // THA
                        self::$_builtInFormats[59] = 't0';
                        self::$_builtInFormats[60] = 't0.00';
                        self::$_builtInFormats[61] = 't#,##0';
                        self::$_builtInFormats[62] = 't#,##0.00';
                        self::$_builtInFormats[67] = 't0%';
                        self::$_builtInFormats[68] = 't0.00%';
                        self::$_builtInFormats[69] = 't# ?/?';
                        self::$_builtInFormats[70] = 't# ??/??';

                        // Flip array (for faster lookups)
                        self::$_flippedBuiltInFormats = array_flip(self::$_builtInFormats);
        }
    }

Here is the caller graph for this function:

PHPExcel_Style_NumberFormat::getActiveSheet

(

)

Get the currently active sheet.

Only used for supervisor

Returns

PHPExcel_Worksheet

Definition at line 195 of file NumberFormat.php.

Referenced by applyFromArray(), getXActiveCell(), getXSelectedCells(), setBuiltInFormatCode(), and setFormatCode().

        {
                return $this->_parent->getActiveSheet();
        }

Here is the caller graph for this function:

PHPExcel_Style_NumberFormat::getBuiltInFormatCode

(

)

Get Built-In Format Code.

Returns

int

Definition at line 304 of file NumberFormat.php.

References $_builtInFormatCode, and getSharedComponent().

                                           {
                if ($this->_isSupervisor) {
                        return $this->getSharedComponent()->getBuiltInFormatCode();
                }
        return $this->_builtInFormatCode;
    }

Here is the call graph for this function:

PHPExcel_Style_NumberFormat::getFormatCode

(

)

Get Format Code.

Returns

string

Definition at line 268 of file NumberFormat.php.

References $_formatCode, builtInFormatCode(), and getSharedComponent().

Referenced by PHPExcel_Shared_Date\isDateTimeFormat().

                                    {
                if ($this->_isSupervisor) {
                        return $this->getSharedComponent()->getFormatCode();
                }
        if ($this->_builtInFormatCode !== false)
        {
                return self::builtInFormatCode($this->_builtInFormatCode);
        }
        return $this->_formatCode;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

PHPExcel_Style_NumberFormat::getHashCode

(

)

Get hash code.

Returns

string Hash code

Implements PHPExcel_IComparable.

Definition at line 438 of file NumberFormat.php.

References getSharedComponent().

                                      {
                if ($this->_isSupervisor) {
                        return $this->getSharedComponent()->getHashCode();
                }
        return md5(
                  $this->_formatCode
                . $this->_builtInFormatCode
                . __CLASS__
        );
    }

Here is the call graph for this function:

PHPExcel_Style_NumberFormat::getHashIndex

(

)

Get hash index.

Note that this index may vary during script execution! Only reliable moment is while doing a write of a workbook and when changes are not allowed.

Returns

string Hash index

Implements PHPExcel_IComparable.

Definition at line 464 of file NumberFormat.php.

References $_hashIndex.

                                       {
                return $this->_hashIndex;
        }

PHPExcel_Style_NumberFormat::getIsSupervisor

(

)

Is this a supervisor or a real style component?

Returns

boolean

Definition at line 174 of file NumberFormat.php.

References $_isSupervisor.

        {
                return $this->_isSupervisor;
        }

PHPExcel_Style_NumberFormat::getSharedComponent

(

)

Get the shared style component for the currently active cell in currently active sheet.

Only used for style supervisor

Returns

PHPExcel_Style_NumberFormat

Definition at line 185 of file NumberFormat.php.

Referenced by getBuiltInFormatCode(), getFormatCode(), and getHashCode().

        {
                return $this->_parent->getSharedComponent()->getNumberFormat();
        }

Here is the caller graph for this function:

PHPExcel_Style_NumberFormat::getStyleArray

(

$array

)

Build style array from subcomponents.

Parameters

array

$array

Returns

array

Definition at line 228 of file NumberFormat.php.

Referenced by applyFromArray(), setBuiltInFormatCode(), and setFormatCode().

        {
                return array('numberformat' => $array);
        }

Here is the caller graph for this function:

PHPExcel_Style_NumberFormat::getXActiveCell

(

)

Get the currently active cell coordinate in currently active sheet.

Only used for supervisor

Returns

string E.g. 'A1'

Definition at line 217 of file NumberFormat.php.

References getActiveSheet().

        {
                return $this->getActiveSheet()->getXActiveCell();
        }

Here is the call graph for this function:

PHPExcel_Style_NumberFormat::getXSelectedCells

(

)

Get the currently active cell coordinate in currently active sheet.

Only used for supervisor

Returns

string E.g. 'A1'

Definition at line 206 of file NumberFormat.php.

References getActiveSheet().

Referenced by applyFromArray(), setBuiltInFormatCode(), and setFormatCode().

        {
                return $this->getActiveSheet()->getXSelectedCells();
        }

Here is the call graph for this function:

Here is the caller graph for this function:

PHPExcel_Style_NumberFormat::setBuiltInFormatCode

(

$pValue = 0

)

Set Built-In Format Code.

Parameters

int

$pValue

Returns

PHPExcel_Style_NumberFormat

Definition at line 317 of file NumberFormat.php.

References builtInFormatCode(), getActiveSheet(), getStyleArray(), and getXSelectedCells().

                                                      {

                if ($this->_isSupervisor) {
                        $styleArray = $this->getStyleArray(array('code' => self::builtInFormatCode($pValue)));
                        $this->getActiveSheet()->getStyle($this->getXSelectedCells())->applyFromArray($styleArray);
                } else {
                        $this->_builtInFormatCode = $pValue;
                        $this->_formatCode = self::builtInFormatCode($pValue);
                }
                return $this;
    }

Here is the call graph for this function:

PHPExcel_Style_NumberFormat::setFormatCode

(

$pValue = PHPExcel_Style_NumberFormat::FORMAT_GENERAL

)

Set Format Code.

Parameters

string

$pValue

Returns

PHPExcel_Style_NumberFormat

Definition at line 285 of file NumberFormat.php.

References builtInFormatCodeIndex(), FORMAT_GENERAL, getActiveSheet(), getStyleArray(), and getXSelectedCells().

Referenced by applyFromArray().

                                                                                       {
        if ($pValue == '') {
                $pValue = PHPExcel_Style_NumberFormat::FORMAT_GENERAL;
        }
                if ($this->_isSupervisor) {
                        $styleArray = $this->getStyleArray(array('code' => $pValue));
                        $this->getActiveSheet()->getStyle($this->getXSelectedCells())->applyFromArray($styleArray);
                } else {
                        $this->_formatCode = $pValue;
                        $this->_builtInFormatCode = self::builtInFormatCodeIndex($pValue);
                }
                return $this;
    }

Here is the call graph for this function:

Here is the caller graph for this function:

PHPExcel_Style_NumberFormat::setHashIndex

(

$value

)

Set hash index.

Note that this index may vary during script execution! Only reliable moment is while doing a write of a workbook and when changes are not allowed.

Parameters

string

$value

Hash index

Implements PHPExcel_IComparable.

Definition at line 476 of file NumberFormat.php.

                                             {
                $this->_hashIndex = $value;
        }

static PHPExcel_Style_NumberFormat::toFormattedString (   $value = '',   $format = ''  )

static

Convert a value in a pre-defined format to a PHP string.

Parameters

mixed	$value	Value to format
string	$format	Format code

Returns

string Formatted string

Definition at line 501 of file NumberFormat.php.

References PHPExcel_Shared_Date\ExcelToPHP(), and PHPExcel_Calculation_Functions\GCD().

Referenced by PHPExcel_Writer_HTML\_generateRow(), PHPExcel_Calculation_Functions\TEXTFORMAT(), and PHPExcel_Worksheet\toArray().

                                                                            {
                // For now we do not treat strings although part 4 of a format code affects strings
                if (!is_numeric($value)) return $value;

                // For 'General' format code, we just pass the value although this is not entirely the way Excel does it,
                // it seems to round numbers to a total of 10 digits.
                if ($format === 'General') {
                        return $value;
                }

                // Get the parts, there can be up to four parts
                $parts = explode(';', $format);

                // We should really fetch the relevant part depending on whether we have a positive number,
                // negative number, zero, or text. But for now we just use first part
                $format = $parts[0];

                if (preg_match("/^[hmsdy]/i", $format)) { // custom datetime format
                        // dvc: convert Excel formats to PHP date formats
                        // first remove escapes related to non-format characters

                        // OpenOffice.org uses upper-case number formats, e.g. 'YYYY', convert to lower-case
                        $format = strtolower($format);

                        $format = str_replace('\\', '', $format);

                        //      4-digit year
                        $format = str_replace('yyyy', 'Y', $format);
                        //      2-digit year
                        $format = str_replace('yy', 'y', $format);
                        //      first letter of month - no php equivalent
                        $format = str_replace('mmmmm', 'M', $format);
                        //      full month name
                        $format = str_replace('mmmm', 'F', $format);
                        //      short month name
                        $format = str_replace('mmm', 'M', $format);
                        //      mm is minutes if time or month w/leading zero
                        $format = str_replace(':mm', ':i', $format);
                        //      tmp place holder
                        $format = str_replace('mm', 'x', $format);
                        //      month no leading zero
                        $format = str_replace('m', 'n', $format);
                        //      month leading zero
                        $format = str_replace('x', 'm', $format);
                        //      12-hour suffix
                        $format = str_replace('am/pm', 'A', $format);
                        //      full day of week name
                        $format = str_replace('dddd', 'l', $format);
                        //      short day of week name
                        $format = str_replace('ddd', 'D', $format);
                        //      tmp place holder
                        $format = str_replace('dd', 'x', $format);
                        //      days no leading zero
                        $format = str_replace('d', 'j', $format);
                        //      days leading zero
                        $format = str_replace('x', 'd', $format);
                        //      seconds
                        $format = str_replace('ss', 's', $format);
                        //      fractional seconds - no php equivalent
                        $format = str_replace('.s', '', $format);

                        if (!strpos($format,'A')) { // 24-hour format
                                $format = str_replace('h', 'H', $format);
                        }

                        return gmdate($format, PHPExcel_Shared_Date::ExcelToPHP($value));

                } else if (preg_match('/%$/', $format)) { // % number format
                        if ($format === self::FORMAT_PERCENTAGE) {
                                return round( (100 * $value), 0) . '%';
                        }
                        if (preg_match('/\.[#0]+/i', $format, $m)) {
                                $s = substr($m[0], 0, 1) . (strlen($m[0]) - 1);
                                $format = str_replace($m[0], $s, $format);
                        }
                        if (preg_match('/^[#0]+/', $format, $m)) {
                                $format = str_replace($m[0], strlen($m[0]), $format);
                        }
                        $format = '%' . str_replace('%', 'f%%', $format);

                        return sprintf($format, 100 * $value);

                } else {
                        if (preg_match ("/^([0-9.,-]+)$/", $value)) {
                                if ($format === self::FORMAT_CURRENCY_EUR_SIMPLE) {
                                        return 'EUR ' . sprintf('%1.2f', $value);

                                } else {
                                        // In Excel formats, "_" is used to add spacing, which we can't do in HTML
                                        $format = preg_replace('/_./', '', $format);

                                        // Some non-number characters are escaped with \, which we don't need
                                        $format = preg_replace("/\\\\/", '', $format);

                                        // Some non-number strings are quoted, so we'll get rid of the quotes
                                        $format = preg_replace('/"/', '', $format);

                                        // TEMPORARY - Convert # to 0
                                        $format = preg_replace('/\\#/', '0', $format);

                                        // Find out if we need thousands separator
                                        $useThousands = preg_match('/,/', $format);
                                        if ($useThousands) {
                                                $format = preg_replace('/,/', '', $format);
                                        }

                                        if (preg_match('/0?.*\?\/\?/', $format, $m)) {
                                                //echo 'Format mask is fractional '.$format.' <br />';
                                                $sign = ($value < 0) ? '-' : '';

                                                $integerPart = floor(abs($value));
                                                $decimalPart = trim(fmod(abs($value),1),'0.');
                                                $decimalLength = strlen($decimalPart);
                                                $decimalDivisor = pow(10,$decimalLength);

                                                $GCD = PHPExcel_Calculation_Functions::GCD($decimalPart,$decimalDivisor);

                                                $adjustedDecimalPart = $decimalPart/$GCD;
                                                $adjustedDecimalDivisor = $decimalDivisor/$GCD;

                                                if (strpos($format,'0') !== false) {
                                                        $value = "$sign$integerPart $adjustedDecimalPart/$adjustedDecimalDivisor";
                                                } else {
                                                        $adjustedDecimalPart += $integerPart * $adjustedDecimalDivisor;
                                                        $value = "$sign$adjustedDecimalPart/$adjustedDecimalDivisor";
                                                }

                                        } else {
                                                // Handle the number itself
                                                $number_regex = "/(\d+)(\.?)(\d*)/";
                                                if (preg_match($number_regex, $format, $matches)) {
                                                        $left = $matches[1];
                                                        $dec = $matches[2];
                                                        $right = $matches[3];
                                                        if ($useThousands) {
                                                                $localeconv = localeconv();
                                                                if (($localeconv['thousands_sep'] == '') || ($localeconv['decimal_point'] == '')) {
                                                                        $value = number_format($value, strlen($right), $localeconv['mon_decimal_point'], $localeconv['mon_thousands_sep']);
                                                                } else {
                                                                        $value = number_format($value, strlen($right), $localeconv['decimal_point'], $localeconv['thousands_sep']);
                                                                }
                                                        } else {
                                                                $sprintf_pattern = "%1." . strlen($right) . "f";
                                                                $value = sprintf($sprintf_pattern, $value);
                                                        }
                                                        $value = preg_replace($number_regex, $value, $format);
                                                }
                                        }

                                        return $value;

                                }
                        }

                        return $value;
                }
        }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

PHPExcel_Style_NumberFormat::$_builtInFormatCode

private

Definition at line 122 of file NumberFormat.php.

Referenced by getBuiltInFormatCode().

PHPExcel_Style_NumberFormat::$_builtInFormats

staticprivate

Definition at line 101 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_flippedBuiltInFormats

staticprivate

Definition at line 108 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_formatCode

private

Definition at line 115 of file NumberFormat.php.

Referenced by getFormatCode().

PHPExcel_Style_NumberFormat::$_hashIndex

private

Definition at line 454 of file NumberFormat.php.

Referenced by getHashIndex().

PHPExcel_Style_NumberFormat::$_isSupervisor

private

Definition at line 136 of file NumberFormat.php.

Referenced by getIsSupervisor().

PHPExcel_Style_NumberFormat::$_parent

private

Definition at line 143 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_parentPropertyName

private

Definition at line 129 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE = '[$EUR ]#,##0.00_-'

Definition at line 94 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD = '$#,##0_-'

Definition at line 93 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_USD_SIMPLE = '"$"#,##0.00_-'

Definition at line 92 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_DATE_DATETIME = 'd/m/y h:mm'

Definition at line 81 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_DDMMYYYY = 'dd/mm/yy'

Definition at line 71 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_DMMINUS = 'd-m'

Definition at line 74 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYMINUS = 'd-m-y'

Definition at line 73 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_DMYSLASH = 'd/m/y'

Definition at line 72 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_MYMINUS = 'm-y'

Definition at line 75 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME1 = 'h:mm AM/PM'

Definition at line 82 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME2 = 'h:mm:ss AM/PM'

Definition at line 83 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3 = 'h:mm'

Definition at line 84 of file NumberFormat.php.

Referenced by PHPExcel_Cell_AdvancedValueBinder\bindValue(), and PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME4 = 'h:mm:ss'

Definition at line 85 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME5 = 'mm:ss'

Definition at line 86 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME6 = 'h:mm:ss'

Definition at line 87 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME7 = 'i:s.S'

Definition at line 88 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME8 = 'h:mm:ss;@'

Definition at line 89 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX14 = 'mm-dd-yy'

Definition at line 76 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX15 = 'd-mmm-yy'

Definition at line 77 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX16 = 'd-mmm'

Definition at line 78 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX17 = 'mmm-yy'

Definition at line 79 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX22 = 'm/d/yy h:mm'

Definition at line 80 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD = 'yy-mm-dd'

Definition at line 70 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDD2 = 'yyyy-mm-dd'

Definition at line 69 of file NumberFormat.php.

Referenced by PHPExcel_Cell_AdvancedValueBinder\bindValue(), and PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_YYYYMMDDSLASH = 'yy/mm/dd;@'

Definition at line 90 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_GENERAL = 'General'

Definition at line 57 of file NumberFormat.php.

Referenced by __construct(), PHPExcel_Reader_Excel2007\load(), and setFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_NUMBER = '0'

Definition at line 61 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00 = '0.00'

Definition at line 62 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED1 = '#,##0.00'

Definition at line 63 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_NUMBER_COMMA_SEPARATED2 = '#,##0.00_-'

Definition at line 64 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE = '0%'

Definition at line 66 of file NumberFormat.php.

Referenced by PHPExcel_Cell_AdvancedValueBinder\bindValue().

const PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00 = '0.00%'

Definition at line 67 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_TEXT = '@'

Definition at line 59 of file NumberFormat.php.

Referenced by PHPExcel_Cell_AdvancedValueBinder\bindValue().

---

The documentation for this class was generated from the following file:

• Services/Excel/classes/PHPExcel/Style/NumberFormat.php