| [ Index ] |
PHP Cross Reference of moodle-2.8 |
[Summary view] [Print] [Text view]
1 <?php 2 /** 3 * PHPExcel 4 * 5 * Copyright (c) 2006 - 2014 PHPExcel 6 * 7 * This library is free software; you can redistribute it and/or 8 * modify it under the terms of the GNU Lesser General Public 9 * License as published by the Free Software Foundation; either 10 * version 2.1 of the License, or (at your option) any later version. 11 * 12 * This library is distributed in the hope that it will be useful, 13 * but WITHOUT ANY WARRANTY; without even the implied warranty of 14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU 15 * Lesser General Public License for more details. 16 * 17 * You should have received a copy of the GNU Lesser General Public 18 * License along with this library; if not, write to the Free Software 19 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA 20 * 21 * @category PHPExcel 22 * @package PHPExcel_Style 23 * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) 24 * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL 25 * @version ##VERSION##, ##DATE## 26 */ 27 28 29 /** 30 * PHPExcel_Style_NumberFormat 31 * 32 * @category PHPExcel 33 * @package PHPExcel_Style 34 * @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel) 35 */ 36 class PHPExcel_Style_NumberFormat extends PHPExcel_Style_Supervisor implements PHPExcel_IComparable 37 { 38 /* Pre-defined formats */ 39 const FORMAT_GENERAL = 'General'; 40 41 const FORMAT_TEXT = '@'; 42 43 const FORMAT_NUMBER = '0'; 44 const FORMAT_NUMBER_00 = '0.00'; 45 const FORMAT_NUMBER_COMMA_SEPARATED1 = '#,##0.00'; 46 const FORMAT_NUMBER_COMMA_SEPARATED2 = '#,##0.00_-'; 47 48 const FORMAT_PERCENTAGE = '0%'; 49 const FORMAT_PERCENTAGE_00 = '0.00%'; 50 51 const FORMAT_DATE_YYYYMMDD2 = 'yyyy-mm-dd'; 52 const FORMAT_DATE_YYYYMMDD = 'yy-mm-dd'; 53 const FORMAT_DATE_DDMMYYYY = 'dd/mm/yy'; 54 const FORMAT_DATE_DMYSLASH = 'd/m/y'; 55 const FORMAT_DATE_DMYMINUS = 'd-m-y'; 56 const FORMAT_DATE_DMMINUS = 'd-m'; 57 const FORMAT_DATE_MYMINUS = 'm-y'; 58 const FORMAT_DATE_XLSX14 = 'mm-dd-yy'; 59 const FORMAT_DATE_XLSX15 = 'd-mmm-yy'; 60 const FORMAT_DATE_XLSX16 = 'd-mmm'; 61 const FORMAT_DATE_XLSX17 = 'mmm-yy'; 62 const FORMAT_DATE_XLSX22 = 'm/d/yy h:mm'; 63 const FORMAT_DATE_DATETIME = 'd/m/y h:mm'; 64 const FORMAT_DATE_TIME1 = 'h:mm AM/PM'; 65 const FORMAT_DATE_TIME2 = 'h:mm:ss AM/PM'; 66 const FORMAT_DATE_TIME3 = 'h:mm'; 67 const FORMAT_DATE_TIME4 = 'h:mm:ss'; 68 const FORMAT_DATE_TIME5 = 'mm:ss'; 69 const FORMAT_DATE_TIME6 = 'h:mm:ss'; 70 const FORMAT_DATE_TIME7 = 'i:s.S'; 71 const FORMAT_DATE_TIME8 = 'h:mm:ss;@'; 72 const FORMAT_DATE_YYYYMMDDSLASH = 'yy/mm/dd;@'; 73 74 const FORMAT_CURRENCY_USD_SIMPLE = '"$"#,##0.00_-'; 75 const FORMAT_CURRENCY_USD = '$#,##0_-'; 76 const FORMAT_CURRENCY_EUR_SIMPLE = '[$EUR ]#,##0.00_-'; 77 78 /** 79 * Excel built-in number formats 80 * 81 * @var array 82 */ 83 protected static $_builtInFormats; 84 85 /** 86 * Excel built-in number formats (flipped, for faster lookups) 87 * 88 * @var array 89 */ 90 protected static $_flippedBuiltInFormats; 91 92 /** 93 * Format Code 94 * 95 * @var string 96 */ 97 protected $_formatCode = PHPExcel_Style_NumberFormat::FORMAT_GENERAL; 98 99 /** 100 * Built-in format Code 101 * 102 * @var string 103 */ 104 protected $_builtInFormatCode = 0; 105 106 /** 107 * Create a new PHPExcel_Style_NumberFormat 108 * 109 * @param boolean $isSupervisor Flag indicating if this is a supervisor or not 110 * Leave this value at default unless you understand exactly what 111 * its ramifications are 112 * @param boolean $isConditional Flag indicating if this is a conditional style or not 113 * Leave this value at default unless you understand exactly what 114 * its ramifications are 115 */ 116 public function __construct($isSupervisor = FALSE, $isConditional = FALSE) 117 { 118 // Supervisor? 119 parent::__construct($isSupervisor); 120 121 if ($isConditional) { 122 $this->_formatCode = NULL; 123 } 124 } 125 126 /** 127 * Get the shared style component for the currently active cell in currently active sheet. 128 * Only used for style supervisor 129 * 130 * @return PHPExcel_Style_NumberFormat 131 */ 132 public function getSharedComponent() 133 { 134 return $this->_parent->getSharedComponent()->getNumberFormat(); 135 } 136 137 /** 138 * Build style array from subcomponents 139 * 140 * @param array $array 141 * @return array 142 */ 143 public function getStyleArray($array) 144 { 145 return array('numberformat' => $array); 146 } 147 148 /** 149 * Apply styles from array 150 * 151 * <code> 152 * $objPHPExcel->getActiveSheet()->getStyle('B2')->getNumberFormat()->applyFromArray( 153 * array( 154 * 'code' => PHPExcel_Style_NumberFormat::FORMAT_CURRENCY_EUR_SIMPLE 155 * ) 156 * ); 157 * </code> 158 * 159 * @param array $pStyles Array containing style information 160 * @throws PHPExcel_Exception 161 * @return PHPExcel_Style_NumberFormat 162 */ 163 public function applyFromArray($pStyles = null) 164 { 165 if (is_array($pStyles)) { 166 if ($this->_isSupervisor) { 167 $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($this->getStyleArray($pStyles)); 168 } else { 169 if (array_key_exists('code', $pStyles)) { 170 $this->setFormatCode($pStyles['code']); 171 } 172 } 173 } else { 174 throw new PHPExcel_Exception("Invalid style array passed."); 175 } 176 return $this; 177 } 178 179 /** 180 * Get Format Code 181 * 182 * @return string 183 */ 184 public function getFormatCode() 185 { 186 if ($this->_isSupervisor) { 187 return $this->getSharedComponent()->getFormatCode(); 188 } 189 if ($this->_builtInFormatCode !== false) 190 { 191 return self::builtInFormatCode($this->_builtInFormatCode); 192 } 193 return $this->_formatCode; 194 } 195 196 /** 197 * Set Format Code 198 * 199 * @param string $pValue 200 * @return PHPExcel_Style_NumberFormat 201 */ 202 public function setFormatCode($pValue = PHPExcel_Style_NumberFormat::FORMAT_GENERAL) 203 { 204 if ($pValue == '') { 205 $pValue = PHPExcel_Style_NumberFormat::FORMAT_GENERAL; 206 } 207 if ($this->_isSupervisor) { 208 $styleArray = $this->getStyleArray(array('code' => $pValue)); 209 $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); 210 } else { 211 $this->_formatCode = $pValue; 212 $this->_builtInFormatCode = self::builtInFormatCodeIndex($pValue); 213 } 214 return $this; 215 } 216 217 /** 218 * Get Built-In Format Code 219 * 220 * @return int 221 */ 222 public function getBuiltInFormatCode() 223 { 224 if ($this->_isSupervisor) { 225 return $this->getSharedComponent()->getBuiltInFormatCode(); 226 } 227 return $this->_builtInFormatCode; 228 } 229 230 /** 231 * Set Built-In Format Code 232 * 233 * @param int $pValue 234 * @return PHPExcel_Style_NumberFormat 235 */ 236 public function setBuiltInFormatCode($pValue = 0) 237 { 238 239 if ($this->_isSupervisor) { 240 $styleArray = $this->getStyleArray(array('code' => self::builtInFormatCode($pValue))); 241 $this->getActiveSheet()->getStyle($this->getSelectedCells())->applyFromArray($styleArray); 242 } else { 243 $this->_builtInFormatCode = $pValue; 244 $this->_formatCode = self::builtInFormatCode($pValue); 245 } 246 return $this; 247 } 248 249 /** 250 * Fill built-in format codes 251 */ 252 private static function fillBuiltInFormatCodes() 253 { 254 // Built-in format codes 255 if (is_null(self::$_builtInFormats)) { 256 self::$_builtInFormats = array(); 257 258 // General 259 self::$_builtInFormats[0] = PHPExcel_Style_NumberFormat::FORMAT_GENERAL; 260 self::$_builtInFormats[1] = '0'; 261 self::$_builtInFormats[2] = '0.00'; 262 self::$_builtInFormats[3] = '#,##0'; 263 self::$_builtInFormats[4] = '#,##0.00'; 264 265 self::$_builtInFormats[9] = '0%'; 266 self::$_builtInFormats[10] = '0.00%'; 267 self::$_builtInFormats[11] = '0.00E+00'; 268 self::$_builtInFormats[12] = '# ?/?'; 269 self::$_builtInFormats[13] = '# ??/??'; 270 self::$_builtInFormats[14] = 'mm-dd-yy'; 271 self::$_builtInFormats[15] = 'd-mmm-yy'; 272 self::$_builtInFormats[16] = 'd-mmm'; 273 self::$_builtInFormats[17] = 'mmm-yy'; 274 self::$_builtInFormats[18] = 'h:mm AM/PM'; 275 self::$_builtInFormats[19] = 'h:mm:ss AM/PM'; 276 self::$_builtInFormats[20] = 'h:mm'; 277 self::$_builtInFormats[21] = 'h:mm:ss'; 278 self::$_builtInFormats[22] = 'm/d/yy h:mm'; 279 280 self::$_builtInFormats[37] = '#,##0 ;(#,##0)'; 281 self::$_builtInFormats[38] = '#,##0 ;[Red](#,##0)'; 282 self::$_builtInFormats[39] = '#,##0.00;(#,##0.00)'; 283 self::$_builtInFormats[40] = '#,##0.00;[Red](#,##0.00)'; 284 285 self::$_builtInFormats[44] = '_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)'; 286 self::$_builtInFormats[45] = 'mm:ss'; 287 self::$_builtInFormats[46] = '[h]:mm:ss'; 288 self::$_builtInFormats[47] = 'mmss.0'; 289 self::$_builtInFormats[48] = '##0.0E+0'; 290 self::$_builtInFormats[49] = '@'; 291 292 // CHT 293 self::$_builtInFormats[27] = '[$-404]e/m/d'; 294 self::$_builtInFormats[30] = 'm/d/yy'; 295 self::$_builtInFormats[36] = '[$-404]e/m/d'; 296 self::$_builtInFormats[50] = '[$-404]e/m/d'; 297 self::$_builtInFormats[57] = '[$-404]e/m/d'; 298 299 // THA 300 self::$_builtInFormats[59] = 't0'; 301 self::$_builtInFormats[60] = 't0.00'; 302 self::$_builtInFormats[61] = 't#,##0'; 303 self::$_builtInFormats[62] = 't#,##0.00'; 304 self::$_builtInFormats[67] = 't0%'; 305 self::$_builtInFormats[68] = 't0.00%'; 306 self::$_builtInFormats[69] = 't# ?/?'; 307 self::$_builtInFormats[70] = 't# ??/??'; 308 309 // Flip array (for faster lookups) 310 self::$_flippedBuiltInFormats = array_flip(self::$_builtInFormats); 311 } 312 } 313 314 /** 315 * Get built-in format code 316 * 317 * @param int $pIndex 318 * @return string 319 */ 320 public static function builtInFormatCode($pIndex) 321 { 322 // Clean parameter 323 $pIndex = intval($pIndex); 324 325 // Ensure built-in format codes are available 326 self::fillBuiltInFormatCodes(); 327 328 // Lookup format code 329 if (isset(self::$_builtInFormats[$pIndex])) { 330 return self::$_builtInFormats[$pIndex]; 331 } 332 333 return ''; 334 } 335 336 /** 337 * Get built-in format code index 338 * 339 * @param string $formatCode 340 * @return int|boolean 341 */ 342 public static function builtInFormatCodeIndex($formatCode) 343 { 344 // Ensure built-in format codes are available 345 self::fillBuiltInFormatCodes(); 346 347 // Lookup format code 348 if (isset(self::$_flippedBuiltInFormats[$formatCode])) { 349 return self::$_flippedBuiltInFormats[$formatCode]; 350 } 351 352 return false; 353 } 354 355 /** 356 * Get hash code 357 * 358 * @return string Hash code 359 */ 360 public function getHashCode() 361 { 362 if ($this->_isSupervisor) { 363 return $this->getSharedComponent()->getHashCode(); 364 } 365 return md5( 366 $this->_formatCode 367 . $this->_builtInFormatCode 368 . __CLASS__ 369 ); 370 } 371 372 /** 373 * Search/replace values to convert Excel date/time format masks to PHP format masks 374 * 375 * @var array 376 */ 377 private static $_dateFormatReplacements = array( 378 // first remove escapes related to non-format characters 379 '\\' => '', 380 // 12-hour suffix 381 'am/pm' => 'A', 382 // 4-digit year 383 'e' => 'Y', 384 'yyyy' => 'Y', 385 // 2-digit year 386 'yy' => 'y', 387 // first letter of month - no php equivalent 388 'mmmmm' => 'M', 389 // full month name 390 'mmmm' => 'F', 391 // short month name 392 'mmm' => 'M', 393 // mm is minutes if time, but can also be month w/leading zero 394 // so we try to identify times be the inclusion of a : separator in the mask 395 // It isn't perfect, but the best way I know how 396 ':mm' => ':i', 397 'mm:' => 'i:', 398 // month leading zero 399 'mm' => 'm', 400 // month no leading zero 401 'm' => 'n', 402 // full day of week name 403 'dddd' => 'l', 404 // short day of week name 405 'ddd' => 'D', 406 // days leading zero 407 'dd' => 'd', 408 // days no leading zero 409 'd' => 'j', 410 // seconds 411 'ss' => 's', 412 // fractional seconds - no php equivalent 413 '.s' => '' 414 ); 415 /** 416 * Search/replace values to convert Excel date/time format masks hours to PHP format masks (24 hr clock) 417 * 418 * @var array 419 */ 420 private static $_dateFormatReplacements24 = array( 421 'hh' => 'H', 422 'h' => 'G' 423 ); 424 /** 425 * Search/replace values to convert Excel date/time format masks hours to PHP format masks (12 hr clock) 426 * 427 * @var array 428 */ 429 private static $_dateFormatReplacements12 = array( 430 'hh' => 'h', 431 'h' => 'g' 432 ); 433 434 private static function _formatAsDate(&$value, &$format) 435 { 436 // dvc: convert Excel formats to PHP date formats 437 438 // strip off first part containing e.g. [$-F800] or [$USD-409] 439 // general syntax: [$<Currency string>-<language info>] 440 // language info is in hexadecimal 441 $format = preg_replace('/^(\[\$[A-Z]*-[0-9A-F]*\])/i', '', $format); 442 443 // OpenOffice.org uses upper-case number formats, e.g. 'YYYY', convert to lower-case 444 $format = strtolower($format); 445 446 $format = strtr($format,self::$_dateFormatReplacements); 447 if (!strpos($format,'A')) { // 24-hour time format 448 $format = strtr($format,self::$_dateFormatReplacements24); 449 } else { // 12-hour time format 450 $format = strtr($format,self::$_dateFormatReplacements12); 451 } 452 453 $dateObj = PHPExcel_Shared_Date::ExcelToPHPObject($value); 454 $value = $dateObj->format($format); 455 } 456 457 private static function _formatAsPercentage(&$value, &$format) 458 { 459 if ($format === self::FORMAT_PERCENTAGE) { 460 $value = round( (100 * $value), 0) . '%'; 461 } else { 462 if (preg_match('/\.[#0]+/i', $format, $m)) { 463 $s = substr($m[0], 0, 1) . (strlen($m[0]) - 1); 464 $format = str_replace($m[0], $s, $format); 465 } 466 if (preg_match('/^[#0]+/', $format, $m)) { 467 $format = str_replace($m[0], strlen($m[0]), $format); 468 } 469 $format = '%' . str_replace('%', 'f%%', $format); 470 471 $value = sprintf($format, 100 * $value); 472 } 473 } 474 475 private static function _formatAsFraction(&$value, &$format) 476 { 477 $sign = ($value < 0) ? '-' : ''; 478 479 $integerPart = floor(abs($value)); 480 $decimalPart = trim(fmod(abs($value),1),'0.'); 481 $decimalLength = strlen($decimalPart); 482 $decimalDivisor = pow(10,$decimalLength); 483 484 $GCD = PHPExcel_Calculation_MathTrig::GCD($decimalPart,$decimalDivisor); 485 486 $adjustedDecimalPart = $decimalPart/$GCD; 487 $adjustedDecimalDivisor = $decimalDivisor/$GCD; 488 489 if ((strpos($format,'0') !== false) || (strpos($format,'#') !== false) || (substr($format,0,3) == '? ?')) { 490 if ($integerPart == 0) { 491 $integerPart = ''; 492 } 493 $value = "$sign$integerPart $adjustedDecimalPart/$adjustedDecimalDivisor"; 494 } else { 495 $adjustedDecimalPart += $integerPart * $adjustedDecimalDivisor; 496 $value = "$sign$adjustedDecimalPart/$adjustedDecimalDivisor"; 497 } 498 } 499 500 private static function _complexNumberFormatMask($number, $mask) { 501 if (strpos($mask,'.') !== false) { 502 $numbers = explode('.', $number . '.0'); 503 $masks = explode('.', $mask . '.0'); 504 $result1 = self::_complexNumberFormatMask($numbers[0], $masks[0]); 505 $result2 = strrev(self::_complexNumberFormatMask(strrev($numbers[1]), strrev($masks[1]))); 506 return $result1 . '.' . $result2; 507 } 508 509 $r = preg_match_all('/0+/', $mask, $result, PREG_OFFSET_CAPTURE); 510 if ($r > 1) { 511 $result = array_reverse($result[0]); 512 513 foreach($result as $block) { 514 $divisor = 1 . $block[0]; 515 $size = strlen($block[0]); 516 $offset = $block[1]; 517 518 $blockValue = sprintf( 519 '%0' . $size . 'd', 520 fmod($number, $divisor) 521 ); 522 $number = floor($number / $divisor); 523 $mask = substr_replace($mask,$blockValue, $offset, $size); 524 } 525 if ($number > 0) { 526 $mask = substr_replace($mask, $number, $offset, 0); 527 } 528 $result = $mask; 529 } else { 530 $result = $number; 531 } 532 533 return $result; 534 } 535 536 /** 537 * Convert a value in a pre-defined format to a PHP string 538 * 539 * @param mixed $value Value to format 540 * @param string $format Format code 541 * @param array $callBack Callback function for additional formatting of string 542 * @return string Formatted string 543 */ 544 public static function toFormattedString($value = '0', $format = PHPExcel_Style_NumberFormat::FORMAT_GENERAL, $callBack = null) 545 { 546 // For now we do not treat strings although section 4 of a format code affects strings 547 if (!is_numeric($value)) return $value; 548 549 // For 'General' format code, we just pass the value although this is not entirely the way Excel does it, 550 // it seems to round numbers to a total of 10 digits. 551 if (($format === PHPExcel_Style_NumberFormat::FORMAT_GENERAL) || ($format === PHPExcel_Style_NumberFormat::FORMAT_TEXT)) { 552 return $value; 553 } 554 555 // Get the sections, there can be up to four sections 556 $sections = explode(';', $format); 557 558 // Fetch the relevant section depending on whether number is positive, negative, or zero? 559 // Text not supported yet. 560 // Here is how the sections apply to various values in Excel: 561 // 1 section: [POSITIVE/NEGATIVE/ZERO/TEXT] 562 // 2 sections: [POSITIVE/ZERO/TEXT] [NEGATIVE] 563 // 3 sections: [POSITIVE/TEXT] [NEGATIVE] [ZERO] 564 // 4 sections: [POSITIVE] [NEGATIVE] [ZERO] [TEXT] 565 switch (count($sections)) { 566 case 1: 567 $format = $sections[0]; 568 break; 569 570 case 2: 571 $format = ($value >= 0) ? $sections[0] : $sections[1]; 572 $value = abs($value); // Use the absolute value 573 break; 574 575 case 3: 576 $format = ($value > 0) ? 577 $sections[0] : ( ($value < 0) ? 578 $sections[1] : $sections[2]); 579 $value = abs($value); // Use the absolute value 580 break; 581 582 case 4: 583 $format = ($value > 0) ? 584 $sections[0] : ( ($value < 0) ? 585 $sections[1] : $sections[2]); 586 $value = abs($value); // Use the absolute value 587 break; 588 589 default: 590 // something is wrong, just use first section 591 $format = $sections[0]; 592 break; 593 } 594 595 // Save format with color information for later use below 596 $formatColor = $format; 597 598 // Strip color information 599 $color_regex = '/^\\[[a-zA-Z]+\\]/'; 600 $format = preg_replace($color_regex, '', $format); 601 602 // Let's begin inspecting the format and converting the value to a formatted string 603 if (preg_match('/^(\[\$[A-Z]*-[0-9A-F]*\])*[hmsdy]/i', $format)) { // datetime format 604 self::_formatAsDate($value, $format); 605 } else if (preg_match('/%$/', $format)) { // % number format 606 self::_formatAsPercentage($value, $format); 607 } else { 608 if ($format === self::FORMAT_CURRENCY_EUR_SIMPLE) { 609 $value = 'EUR ' . sprintf('%1.2f', $value); 610 } else { 611 // In Excel formats, "_" is used to add spacing, which we can't do in HTML 612 $format = preg_replace('/_./', '', $format); 613 614 // Some non-number characters are escaped with \, which we don't need 615 $format = preg_replace("/\\\\/", '', $format); 616 617 // Some non-number strings are quoted, so we'll get rid of the quotes, likewise any positional * symbols 618 $format = str_replace(array('"','*'), '', $format); 619 620 // Find out if we need thousands separator 621 // This is indicated by a comma enclosed by a digit placeholder: 622 // #,# or 0,0 623 $useThousands = preg_match('/(#,#|0,0)/', $format); 624 if ($useThousands) { 625 $format = preg_replace('/0,0/', '00', $format); 626 $format = preg_replace('/#,#/', '##', $format); 627 } 628 629 // Scale thousands, millions,... 630 // This is indicated by a number of commas after a digit placeholder: 631 // #, or 0.0,, 632 $scale = 1; // same as no scale 633 $matches = array(); 634 if (preg_match('/(#|0)(,+)/', $format, $matches)) { 635 $scale = pow(1000, strlen($matches[2])); 636 637 // strip the commas 638 $format = preg_replace('/0,+/', '0', $format); 639 $format = preg_replace('/#,+/', '#', $format); 640 } 641 642 if (preg_match('/#?.*\?\/\?/', $format, $m)) { 643 //echo 'Format mask is fractional '.$format.' <br />'; 644 if ($value != (int)$value) { 645 self::_formatAsFraction($value, $format); 646 } 647 648 } else { 649 // Handle the number itself 650 651 // scale number 652 $value = $value / $scale; 653 654 // Strip # 655 $format = preg_replace('/\\#/', '0', $format); 656 657 $n = "/\[[^\]]+\]/"; 658 $m = preg_replace($n, '', $format); 659 $number_regex = "/(0+)(\.?)(0*)/"; 660 if (preg_match($number_regex, $m, $matches)) { 661 $left = $matches[1]; 662 $dec = $matches[2]; 663 $right = $matches[3]; 664 665 // minimun width of formatted number (including dot) 666 $minWidth = strlen($left) + strlen($dec) + strlen($right); 667 if ($useThousands) { 668 $value = number_format( 669 $value 670 , strlen($right) 671 , PHPExcel_Shared_String::getDecimalSeparator() 672 , PHPExcel_Shared_String::getThousandsSeparator() 673 ); 674 $value = preg_replace($number_regex, $value, $format); 675 } else { 676 if (preg_match('/[0#]E[+-]0/i', $format)) { 677 // Scientific format 678 $value = sprintf('%5.2E', $value); 679 } elseif (preg_match('/0([^\d\.]+)0/', $format)) { 680 $value = self::_complexNumberFormatMask($value, $format); 681 } else { 682 $sprintf_pattern = "%0$minWidth." . strlen($right) . "f"; 683 $value = sprintf($sprintf_pattern, $value); 684 $value = preg_replace($number_regex, $value, $format); 685 } 686 } 687 } 688 } 689 if (preg_match('/\[\$(.*)\]/u', $format, $m)) { 690 // Currency or Accounting 691 $currencyFormat = $m[0]; 692 $currencyCode = $m[1]; 693 list($currencyCode) = explode('-',$currencyCode); 694 if ($currencyCode == '') { 695 $currencyCode = PHPExcel_Shared_String::getCurrencyCode(); 696 } 697 $value = preg_replace('/\[\$([^\]]*)\]/u',$currencyCode,$value); 698 } 699 } 700 } 701 702 // Additional formatting provided by callback function 703 if ($callBack !== null) { 704 list($writerInstance, $function) = $callBack; 705 $value = $writerInstance->$function($value, $formatColor); 706 } 707 708 return $value; 709 } 710 711 }
title
Description
Body
title
Description
Body
title
Description
Body
title
Body
| Generated: Fri Nov 28 20:29:05 2014 | Cross-referenced by PHPXref 0.7.1 |