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.
	getSelectedCells ()
	Get the currently active cell coordinate in currently active sheet.
	getActiveCell ()
	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.
	__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= '', $callBack=null)
	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 = PHPExcel_Style_NumberFormat::FORMAT_GENERAL
	$_builtInFormatCode = 0
	$_parentPropertyName
	$_isSupervisor
	$_parent

Static Private Attributes
static	$_builtInFormats
static	$_flippedBuiltInFormats
static	$_dateFormatReplacements
static	$_dateFormatReplacements24
static	$_dateFormatReplacements12

Detailed Description

Definition at line 36 of file NumberFormat.php.

Constructor & Destructor Documentation

PHPExcel_Style_NumberFormat::__construct ( $isSupervisor = false )

Create a new PHPExcel_Style_NumberFormat.

Definition at line 130 of file NumberFormat.php.

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

Member Function Documentation

PHPExcel_Style_NumberFormat::__clone ( )

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

Definition at line 438 of file NumberFormat.php.

        {
                $vars = get_object_vars($this);
                foreach ($vars as $key => $value) {
                        if ((is_object($value)) && ($key != '_parent')) {
                                $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 226 of file NumberFormat.php.

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

        {
                if (is_array($pStyles)) {
                        if ($this->_isSupervisor) {
                                $this->getActiveSheet()->getStyle($this->getSelectedCells())->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 142 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 383 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 (isset(self::$_builtInFormats[$pIndex])) {
                        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 405 of file NumberFormat.php.

References fillBuiltInFormatCodes().

Referenced by setFormatCode().

        {
                // Ensure built-in format codes are available
                self::fillBuiltInFormatCodes();
                // Lookup format code
                if (isset(self::$_flippedBuiltInFormats[$formatCode])) {
                        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 315 of file NumberFormat.php.

References FORMAT_GENERAL.

Referenced by builtInFormatCode(), and builtInFormatCodeIndex().

        {
                // Built-in format codes
                if (is_null(self::$_builtInFormats)) {
                        self::$_builtInFormats = array();
                        // General
                        self::$_builtInFormats[0] = PHPExcel_Style_NumberFormat::FORMAT_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::getActiveCell ( )

Get the currently active cell coordinate in currently active sheet.

Only used for supervisor

Returns: string E.g. 'A1'

Definition at line 195 of file NumberFormat.php.

References getActiveSheet().

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

Here is the call graph for this function:

PHPExcel_Style_NumberFormat::getActiveSheet ( )

Get the currently active sheet.

Only used for supervisor

Returns: PHPExcel_Worksheet

Definition at line 173 of file NumberFormat.php.

Referenced by applyFromArray(), getActiveCell(), getSelectedCells(), 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 285 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 247 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 423 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::getIsSupervisor ( )

Is this a supervisor or a real style component?

Returns: boolean

Definition at line 152 of file NumberFormat.php.

References $_isSupervisor.

        {
                return $this->_isSupervisor;
        }

PHPExcel_Style_NumberFormat::getSelectedCells ( )

Get the currently active cell coordinate in currently active sheet.

Only used for supervisor

Returns: string E.g. 'A1'

Definition at line 184 of file NumberFormat.php.

References getActiveSheet().

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

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

Here is the call graph for this function:

Here is the caller graph for this function:

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 163 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 206 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::setBuiltInFormatCode ( $pValue = 0 )

Set Built-In Format Code.

Parameters

int $pValue

Returns: PHPExcel_Style_NumberFormat

Definition at line 299 of file NumberFormat.php.

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

        {
                if ($this->_isSupervisor) {
                        $styleArray = $this->getStyleArray(array('code' => self::builtInFormatCode($pValue)));
                        $this->getActiveSheet()->getStyle($this->getSelectedCells())->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 265 of file NumberFormat.php.

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

Referenced by applyFromArray().

        {
                if ($pValue == '') {
                        $pValue = PHPExcel_Style_NumberFormat::FORMAT_GENERAL;
                }
                if ($this->_isSupervisor) {
                        $styleArray = $this->getStyleArray(array('code' => $pValue));
                        $this->getActiveSheet()->getStyle($this->getSelectedCells())->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:

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

static

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

Parameters

mixed	$value	Value to format
string	$format	Format code
array	$callBack	Callback function for additional formatting of string

Returns: string Formatted string

Definition at line 501 of file NumberFormat.php.

References PHPExcel_Shared_Date\ExcelToPHPObject(), FORMAT_GENERAL, FORMAT_TEXT, PHPExcel_Calculation_MathTrig\GCD(), PHPExcel_Shared_String\getCurrencyCode(), PHPExcel_Shared_String\getDecimalSeparator(), and PHPExcel_Shared_String\getThousandsSeparator().

Referenced by PHPExcel_Writer_HTML\_generateRow(), PHPExcel_Worksheet\calculateColumnWidths(), PHPExcel_Cell\getFormattedValue(), PHPExcel_Worksheet\rangeToArray(), and PHPExcel_Calculation_TextData\TEXTFORMAT().

        {
                // For now we do not treat strings although section 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 === PHPExcel_Style_NumberFormat::FORMAT_GENERAL) || ($format === PHPExcel_Style_NumberFormat::FORMAT_TEXT)) {
                        return $value;
                }
                // Get the sections, there can be up to four sections
                $sections = explode(';', $format);
                // Fetch the relevant section depending on whether number is positive, negative, or zero?
                // Text not supported yet.
                // Here is how the sections apply to various values in Excel:
                //   1 section:   [POSITIVE/NEGATIVE/ZERO/TEXT]
                //   2 sections:  [POSITIVE/ZERO/TEXT] [NEGATIVE]
                //   3 sections:  [POSITIVE/TEXT] [NEGATIVE] [ZERO]
                //   4 sections:  [POSITIVE] [NEGATIVE] [ZERO] [TEXT]
                switch (count($sections)) {
                        case 1:
                                $format = $sections[0];
                                break;
                        case 2:
                                $format = ($value >= 0) ? $sections[0] : $sections[1];
                                $value = abs($value); // Use the absolute value
                                break;
                        case 3:
                                $format = ($value > 0) ?
                                        $sections[0] : ( ($value < 0) ?
                                                $sections[1] : $sections[2]);
                                $value = abs($value); // Use the absolute value
                                break;
                        case 4:
                                $format = ($value > 0) ?
                                        $sections[0] : ( ($value < 0) ?
                                                $sections[1] : $sections[2]);
                                $value = abs($value); // Use the absolute value
                                break;
                        default:
                                // something is wrong, just use first section
                                $format = $sections[0];
                                break;
                }
                // Save format with color information for later use below
                $formatColor = $format;
                // Strip color information
                $color_regex = '/^\\[[a-zA-Z]+\\]/';
                $format = preg_replace($color_regex, '', $format);
                // Let's begin inspecting the format and converting the value to a formatted string
                if (preg_match('/^(\[\$[A-Z]*-[0-9A-F]*\])*[hmsdy]/i', $format)) { // datetime format
                        // dvc: convert Excel formats to PHP date formats
                        // strip off first part containing e.g. [$-F800] or [$USD-409]
                        // general syntax: [$<Currency string>-<language info>]
                        // language info is in hexadecimal
                        $format = preg_replace('/^(\[\$[A-Z]*-[0-9A-F]*\])/i', '', $format);
                        // OpenOffice.org uses upper-case number formats, e.g. 'YYYY', convert to lower-case
                        $format = strtolower($format);
                        $format = strtr($format,self::$_dateFormatReplacements);
                        if (!strpos($format,'A')) {     // 24-hour time format
                                $format = strtr($format,self::$_dateFormatReplacements24);
                        } else {                                        // 12-hour time format
                                $format = strtr($format,self::$_dateFormatReplacements12);
                        }
                        $dateObj = PHPExcel_Shared_Date::ExcelToPHPObject($value);
                        $value = $dateObj->format($format);
                } else if (preg_match('/%$/', $format)) { // % number format
                        if ($format === self::FORMAT_PERCENTAGE) {
                                $value = round( (100 * $value), 0) . '%';
                        } else {
                                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);
                                $value = sprintf($format, 100 * $value);
                        }
                } else {
                        if ($format === self::FORMAT_CURRENCY_EUR_SIMPLE) {
                                $value = '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, likewise any positional * symbols
                                $format = str_replace(array('"','*'), '', $format);
                                // Find out if we need thousands separator
                                // This is indicated by a comma enclosed by a digit placeholder:
                                //              #,#   or   0,0
                                $useThousands = preg_match('/(#,#|0,0)/', $format);
                                if ($useThousands) {
                                        $format = preg_replace('/0,0/', '00', $format);
                                        $format = preg_replace('/#,#/', '##', $format);
                                }
                                // Scale thousands, millions,...
                                // This is indicated by a number of commas after a digit placeholder:
                                //              #,   or 0.0,,
                                $scale = 1; // same as no scale
                                $matches = array();
                                if (preg_match('/(#|0)(,+)/', $format, $matches)) {
                                        $scale = pow(1000, strlen($matches[2]));
                                        // strip the commas
                                        $format = preg_replace('/0,+/', '0', $format);
                                        $format = preg_replace('/#,+/', '#', $format);
                                }
                                if (preg_match('/#?.*\?\/\?/', $format, $m)) {
                                        //echo 'Format mask is fractional '.$format.' <br />';
                                        if ($value != (int)$value) {
                                                $sign = ($value < 0) ? '-' : '';
                                                $integerPart = floor(abs($value));
                                                $decimalPart = trim(fmod(abs($value),1),'0.');
                                                $decimalLength = strlen($decimalPart);
                                                $decimalDivisor = pow(10,$decimalLength);
                                                $GCD = PHPExcel_Calculation_MathTrig::GCD($decimalPart,$decimalDivisor);
                                                $adjustedDecimalPart = $decimalPart/$GCD;
                                                $adjustedDecimalDivisor = $decimalDivisor/$GCD;
                                                if ((strpos($format,'0') !== false) || (strpos($format,'#') !== false) || (substr($format,0,3) == '? ?')) {
                                                        if ($integerPart == 0) { $integerPart = ''; }
                                                        $value = "$sign$integerPart $adjustedDecimalPart/$adjustedDecimalDivisor";
                                                } else {
                                                        $adjustedDecimalPart += $integerPart * $adjustedDecimalDivisor;
                                                        $value = "$sign$adjustedDecimalPart/$adjustedDecimalDivisor";
                                                }
                                        }
                                } else {
                                        // Handle the number itself
                                        // scale number
                                        $value = $value / $scale;
                                        // Strip #
                                        $format = preg_replace('/\\#/', '', $format);
                                        $n = "/\[[^\]]+\]/";
                                        $m = preg_replace($n, '', $format);
                                        $number_regex = "/(0+)(\.?)(0*)/";
                                        if (preg_match($number_regex, $m, $matches)) {
                                                $left = $matches[1];
                                                $dec = $matches[2];
                                                $right = $matches[3];
                                                // minimun width of formatted number (including dot)
                                                $minWidth = strlen($left) + strlen($dec) + strlen($right);
                                                if ($useThousands) {
                                                        $value = number_format(
                                                                                $value
                                                                                , strlen($right)
                                                                                , PHPExcel_Shared_String::getDecimalSeparator()
                                                                                , PHPExcel_Shared_String::getThousandsSeparator()
                                                                        );
                                                } else {
                                                        $sprintf_pattern = "%0$minWidth." . strlen($right) . "f";
                                                        $value = sprintf($sprintf_pattern, $value);
                                                }
                                                $value = preg_replace($number_regex, $value, $format);
                                        }
                                }
                                if (preg_match('/\[\$(.*)\]/u', $format, $m)) {
                                        //      Currency or Accounting
                                        $currencyFormat = $m[0];
                                        $currencyCode = $m[1];
                                        list($currencyCode) = explode('-',$currencyCode);
                                        if ($currencyCode == '') {
                                                $currencyCode = PHPExcel_Shared_String::getCurrencyCode();
                                        }
                                        $value = preg_replace('/\[\$([^\]]*)\]/u',$currencyCode,$value);
                                }
                        }
                }
                // Additional formatting provided by callback function
                if ($callBack !== null) {
                        list($writerInstance, $function) = $callBack;
                        $value = $writerInstance->$function($value, $formatColor);
                }
                return $value;
        }

Here is the call graph for this function:

Here is the caller graph for this function:

Field Documentation

PHPExcel_Style_NumberFormat::$_builtInFormatCode = 0

private

Definition at line 104 of file NumberFormat.php.

Referenced by getBuiltInFormatCode().

PHPExcel_Style_NumberFormat::$_builtInFormats

staticprivate

Definition at line 83 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_dateFormatReplacements

staticprivate

Definition at line 450 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_dateFormatReplacements12

staticprivate

Initial value:

 array(
                        'hh'    => 'h',
                        'h'             => 'g'
                )

Definition at line 488 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_dateFormatReplacements24

staticprivate

Initial value:

 array(
                        'hh'    => 'H',
                        'h'             => 'G'
                )

Definition at line 484 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_flippedBuiltInFormats

staticprivate

Definition at line 90 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_formatCode = PHPExcel_Style_NumberFormat::FORMAT_GENERAL

private

Definition at line 97 of file NumberFormat.php.

Referenced by getFormatCode().

PHPExcel_Style_NumberFormat::$_isSupervisor

private

Definition at line 118 of file NumberFormat.php.

Referenced by getIsSupervisor().

PHPExcel_Style_NumberFormat::$_parent

private

Definition at line 125 of file NumberFormat.php.

PHPExcel_Style_NumberFormat::$_parentPropertyName

private

Definition at line 111 of file NumberFormat.php.

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

Definition at line 76 of file NumberFormat.php.

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

Definition at line 75 of file NumberFormat.php.

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

Definition at line 74 of file NumberFormat.php.

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

Definition at line 63 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode(), and ilExcelXMLAdapter\setCellValue().

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

Definition at line 53 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_DMMINUS = 'd-m'

Definition at line 56 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 55 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 54 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_MYMINUS = 'm-y'

Definition at line 57 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 64 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 65 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME3 = 'h:mm'

Definition at line 66 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 67 of file NumberFormat.php.

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

const PHPExcel_Style_NumberFormat::FORMAT_DATE_TIME5 = 'mm:ss'

Definition at line 68 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 69 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 70 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 71 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 58 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 59 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode(), and PHPExcel_Reader_OOCalc\loadIntoExisting().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX16 = 'd-mmm'

Definition at line 60 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_DATE_XLSX17 = 'mmm-yy'

Definition at line 61 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 62 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 52 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 51 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

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

Definition at line 72 of file NumberFormat.php.

Referenced by PHPExcel_Shared_Date\isDateTimeFormatCode().

const PHPExcel_Style_NumberFormat::FORMAT_GENERAL = 'General'

Definition at line 39 of file NumberFormat.php.

Referenced by fillBuiltInFormatCodes(), PHPExcel_Reader_Excel2007\load(), setFormatCode(), and toFormattedString().

const PHPExcel_Style_NumberFormat::FORMAT_NUMBER = '0'

Definition at line 43 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_NUMBER_00 = '0.00'

Definition at line 44 of file NumberFormat.php.

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

Definition at line 45 of file NumberFormat.php.

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

Definition at line 46 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE = '0%'

Definition at line 48 of file NumberFormat.php.

Referenced by PHPExcel_Cell_AdvancedValueBinder\bindValue(), and ilExcelXMLAdapter\setCellValue().

const PHPExcel_Style_NumberFormat::FORMAT_PERCENTAGE_00 = '0.00%'

Definition at line 49 of file NumberFormat.php.

const PHPExcel_Style_NumberFormat::FORMAT_TEXT = '@'

Definition at line 41 of file NumberFormat.php.

Referenced by toFormattedString().

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

Services/Excel/PHPExcel/1.7.6/Classes/PHPExcel/Style/NumberFormat.php

Public Member Functions

Static Public Member Functions

Data Fields

Static Private Member Functions

Private Attributes

Static Private Attributes

Detailed Description

Constructor & Destructor Documentation

Member Function Documentation

Field Documentation