You are here

private static property PHPExcel_Style_NumberFormat::$_dateFormatReplacements in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Style/NumberFormat.php \PHPExcel_Style_NumberFormat::_dateFormatReplacements

* Search/replace values to convert Excel date/time format masks to PHP format masks * *

Type: array

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Style/NumberFormat.php, line 378

Class

PHPExcel_Style_NumberFormat
PHPExcel_Style_NumberFormat

Code

private static $_dateFormatReplacements = array(
  // first remove escapes related to non-format characters
  '\\' => '',
  //	12-hour suffix
  'am/pm' => 'A',
  //	4-digit year
  'e' => 'Y',
  'yyyy' => 'Y',
  //	2-digit year
  'yy' => 'y',
  //	first letter of month - no php equivalent
  'mmmmm' => 'M',
  //	full month name
  'mmmm' => 'F',
  //	short month name
  'mmm' => 'M',
  //	mm is minutes if time, but can also be month w/leading zero
  //	so we try to identify times be the inclusion of a : separator in the mask
  //	It isn't perfect, but the best way I know how
  ':mm' => ':i',
  'mm:' => 'i:',
  //	month leading zero
  'mm' => 'm',
  //	month no leading zero
  'm' => 'n',
  //	full day of week name
  'dddd' => 'l',
  //	short day of week name
  'ddd' => 'D',
  //	days leading zero
  'dd' => 'd',
  //	days no leading zero
  'd' => 'j',
  //	seconds
  'ss' => 's',
  //	fractional seconds - no php equivalent
  '.s' => '',
);