03:17:32 Create new PHPExcel object
03:17:32 Set document properties
03:17:32 Add data
03:17:32 Set data validation
03:17:32 Write to Excel5 format

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2840
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'B3' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
object(PHPExcel_Cell_DataValidation)[103]
  private 'formula1' => int 10
  private 'formula2' => int 20
  private 'type' => string 'whole' (length=5)
  private 'errorStyle' => string 'stop' (length=4)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean true
  private 'showDropDown' => boolean false
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
  private 'promptTitle' => string 'Allowed input' (length=13)
  private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
Undefined
$error =
Undefined
$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'whole' (length=5)

$errorTitle =
Undefined
$formula1 =
Undefined
$formula2 =
Undefined
$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '²�' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 18

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 4294967295

$operator =
Undefined
$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 1

$prompt =
Undefined
$promptTitle =
Undefined
$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 446

$sz1 =
Undefined
$sz2 =
Undefined
$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 1

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2887
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'B3' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
object(PHPExcel_Cell_DataValidation)[103]
  private 'formula1' => int 10
  private 'formula2' => int 20
  private 'type' => string 'whole' (length=5)
  private 'errorStyle' => string 'stop' (length=4)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean true
  private 'showDropDown' => boolean false
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
  private 'promptTitle' => string 'Allowed input' (length=13)
  private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
Undefined
$error =
Undefined
$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'whole' (length=5)

$errorTitle =
Undefined
$formula1 =
Undefined
$formula2 =
Undefined
$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '²�' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 18

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 4294967295

$operator =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 787201

$prompt =
Undefined
$promptTitle =
Undefined
$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 446

$sz1 =
Undefined
$sz2 =
Undefined
$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 1

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2840
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'B5' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
object(PHPExcel_Cell_DataValidation)[104]
  private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
  private 'formula2' => string '' (length=0)
  private 'type' => string 'list' (length=4)
  private 'errorStyle' => string 'information' (length=11)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean false
  private 'showDropDown' => boolean true
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Value is not in list.' (length=21)
  private 'promptTitle' => string 'Pick from list' (length=14)
  private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
object(PHPExcel_Writer_Exception)[131]
  protected 'message' => string 'Syntax error: , lookahead: , current char: 0' (length=44)
  private 'string' (Exception) => string '' (length=0)
  protected 'code' => int 0
  protected 'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
  protected 'line' => int 1401
  private 'trace' (Exception) => 
    array (size=8)
      0 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1311
          'function' => string 'fact' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      1 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1266
          'function' => string 'term' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      2 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1190
          'function' => string 'expression' (length=10)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      3 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1177
          'function' => string 'condition' (length=9)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      4 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 2933
          'function' => string 'parse' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
      5 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 495
          'function' => string 'writeDataValidity' (length=17)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      6 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5.php' (length=88)
          'line' => int 175
          'function' => string 'close' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      7 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Examples\15datavalidation-xls.php' (length=87)
          'line' => int 140
          'function' => string 'save' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5' (length=22)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
  private 'previous' (Exception) => null
  public 'xdebug_message' => string '<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> PHPExcel_Writer_Exception: Syntax error: , lookahead: , current char: 0 in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php on line <i>1401</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th ali'... (length=4267)

$error =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Only numbers between 10 and 20 are allowed!' (length=43)

$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'list' (length=4)

$errorTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Input error' (length=11)

$formula1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$formula2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '¾þ�' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 254

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 4294967295

$operator =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 3

$prompt =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Only numbers between 10 and 20 are allowed.' (length=43)

$promptTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Allowed input' (length=13)

$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 446

$sz1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$sz2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 3

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2887
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'B5' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
object(PHPExcel_Cell_DataValidation)[104]
  private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
  private 'formula2' => string '' (length=0)
  private 'type' => string 'list' (length=4)
  private 'errorStyle' => string 'information' (length=11)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean false
  private 'showDropDown' => boolean true
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Value is not in list.' (length=21)
  private 'promptTitle' => string 'Pick from list' (length=14)
  private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
object(PHPExcel_Writer_Exception)[131]
  protected 'message' => string 'Syntax error: , lookahead: , current char: 0' (length=44)
  private 'string' (Exception) => string '' (length=0)
  protected 'code' => int 0
  protected 'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
  protected 'line' => int 1401
  private 'trace' (Exception) => 
    array (size=8)
      0 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1311
          'function' => string 'fact' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      1 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1266
          'function' => string 'term' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      2 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1190
          'function' => string 'expression' (length=10)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      3 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php' (length=95)
          'line' => int 1177
          'function' => string 'condition' (length=9)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      4 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 2933
          'function' => string 'parse' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Parser' (length=29)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
      5 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 495
          'function' => string 'writeDataValidity' (length=17)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      6 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5.php' (length=88)
          'line' => int 175
          'function' => string 'close' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      7 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Examples\15datavalidation-xls.php' (length=87)
          'line' => int 140
          'function' => string 'save' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5' (length=22)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
  private 'previous' (Exception) => null
  public 'xdebug_message' => string '<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> PHPExcel_Writer_Exception: Syntax error: , lookahead: , current char: 0 in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Parser.php on line <i>1401</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th ali'... (length=4267)

$error =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Only numbers between 10 and 20 are allowed!' (length=43)

$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'list' (length=4)

$errorTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Input error' (length=11)

$formula1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$formula2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '¾þ�' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 254

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 4294967295

$operator =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 786563

$prompt =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Only numbers between 10 and 20 are allowed.' (length=43)

$promptTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Allowed input' (length=13)

$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 446

$sz1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$sz2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 3

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2840
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'B7' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
object(PHPExcel_Cell_DataValidation)[105]
  private 'formula1' => string '$D$2:$D$6' (length=9)
  private 'formula2' => string '' (length=0)
  private 'type' => string 'list' (length=4)
  private 'errorStyle' => string 'information' (length=11)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean false
  private 'showDropDown' => boolean true
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Value is not in list.' (length=21)
  private 'promptTitle' => string 'Pick from list' (length=14)
  private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
object(PHPExcel_Writer_Exception)[130]
  protected 'message' => string 'No formula2' (length=11)
  private 'string' (Exception) => string '' (length=0)
  protected 'code' => int 0
  protected 'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
  protected 'line' => int 2931
  private 'trace' (Exception) => 
    array (size=3)
      0 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 495
          'function' => string 'writeDataValidity' (length=17)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      1 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5.php' (length=88)
          'line' => int 175
          'function' => string 'close' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      2 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Examples\15datavalidation-xls.php' (length=87)
          'line' => int 140
          'function' => string 'save' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5' (length=22)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
  private 'previous' (Exception) => null
  public 'xdebug_message' => string '<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> PHPExcel_Writer_Exception: No formula2 in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line <i>2931</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Me'... (length=31023)

$error =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Value is not in list.' (length=21)

$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'list' (length=4)

$errorTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Input error' (length=11)

$formula1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'I�t�e�m� �A���I�t�e�m� �B���I�t�e�m� �C�' (length=43)

$formula2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '¾' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 257

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 4294967295

$operator =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 3

$prompt =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Please pick a value from the drop-down list.' (length=44)

$promptTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Pick from list' (length=14)

$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 446

$sz1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 43

$sz2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 3

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2887
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'B7' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
object(PHPExcel_Cell_DataValidation)[105]
  private 'formula1' => string '$D$2:$D$6' (length=9)
  private 'formula2' => string '' (length=0)
  private 'type' => string 'list' (length=4)
  private 'errorStyle' => string 'information' (length=11)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean false
  private 'showDropDown' => boolean true
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Value is not in list.' (length=21)
  private 'promptTitle' => string 'Pick from list' (length=14)
  private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
object(PHPExcel_Writer_Exception)[130]
  protected 'message' => string 'No formula2' (length=11)
  private 'string' (Exception) => string '' (length=0)
  protected 'code' => int 0
  protected 'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
  protected 'line' => int 2931
  private 'trace' (Exception) => 
    array (size=3)
      0 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 495
          'function' => string 'writeDataValidity' (length=17)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      1 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5.php' (length=88)
          'line' => int 175
          'function' => string 'close' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      2 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Examples\15datavalidation-xls.php' (length=87)
          'line' => int 140
          'function' => string 'save' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5' (length=22)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
  private 'previous' (Exception) => null
  public 'xdebug_message' => string '<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> PHPExcel_Writer_Exception: No formula2 in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line <i>2931</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Me'... (length=31023)

$error =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Value is not in list.' (length=21)

$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'list' (length=4)

$errorTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Input error' (length=11)

$formula1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'I�t�e�m� �A���I�t�e�m� �B���I�t�e�m� �C�' (length=43)

$formula2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '¾' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 257

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 4294967295

$operator =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 786435

$prompt =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Please pick a value from the drop-down list.' (length=44)

$promptTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Pick from list' (length=14)

$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 446

$sz1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 43

$sz2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 3

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2840
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'B9' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
object(PHPExcel_Cell_DataValidation)[107]
  private 'formula1' => int 6
  private 'formula2' => string '' (length=0)
  private 'type' => string 'textLength' (length=10)
  private 'errorStyle' => string 'stop' (length=4)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean true
  private 'showDropDown' => boolean false
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Text exceeds maximum length' (length=27)
  private 'promptTitle' => string 'Allowed input' (length=13)
  private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:
object(PHPExcel_Writer_Exception)[131]
  protected 'message' => string 'No formula2' (length=11)
  private 'string' (Exception) => string '' (length=0)
  protected 'code' => int 0
  protected 'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
  protected 'line' => int 2931
  private 'trace' (Exception) => 
    array (size=3)
      0 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 495
          'function' => string 'writeDataValidity' (length=17)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      1 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5.php' (length=88)
          'line' => int 175
          'function' => string 'close' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      2 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Examples\15datavalidation-xls.php' (length=87)
          'line' => int 140
          'function' => string 'save' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5' (length=22)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
  private 'previous' (Exception) => null
  public 'xdebug_message' => string '<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> PHPExcel_Writer_Exception: No formula2 in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line <i>2931</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Me'... (length=26122)

$error =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Value is not in list.' (length=21)

$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'textLength' (length=10)

$errorTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Input error' (length=11)

$formula1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '%����' (length=9)

$formula2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '¾ß�' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 223

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 4294967295

$operator =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string '' (length=0)

$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 6

$prompt =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Please pick a value from the drop-down list.' (length=44)

$promptTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:string 'Pick from list' (length=14)

$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 446

$sz1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 9

$sz2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 6

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2840:int 0

( ! ) Warning: A non-numeric value encountered in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line 2887
Call Stack
#TimeMemoryFunctionLocation
10.0478436624{main}( )...\15datavalidation-xls.php:0
20.08963511552PHPExcel_Writer_Excel5->save( )...\15datavalidation-xls.php:140
30.10274759312PHPExcel_Writer_Excel5_Worksheet->close( )...\Excel5.php:175
40.10564862968PHPExcel_Writer_Excel5_Worksheet->writeDataValidity( )...\Worksheet.php:495
Variables in local scope (#4)
$cellCoordinate =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'B9' (length=2)

$data =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$dataValidation =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
object(PHPExcel_Cell_DataValidation)[107]
  private 'formula1' => int 6
  private 'formula2' => string '' (length=0)
  private 'type' => string 'textLength' (length=10)
  private 'errorStyle' => string 'stop' (length=4)
  private 'operator' => string '' (length=0)
  private 'allowBlank' => boolean true
  private 'showDropDown' => boolean false
  private 'showInputMessage' => boolean true
  private 'showErrorMessage' => boolean true
  private 'errorTitle' => string 'Input error' (length=11)
  private 'error' => string 'Text exceeds maximum length' (length=27)
  private 'promptTitle' => string 'Allowed input' (length=13)
  private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$dataValidationCollection =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
array (size=4)
  'B3' => 
    object(PHPExcel_Cell_DataValidation)[103]
      private 'formula1' => int 10
      private 'formula2' => int 20
      private 'type' => string 'whole' (length=5)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Only numbers between 10 and 20 are allowed!' (length=43)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Only numbers between 10 and 20 are allowed.' (length=43)
  'B5' => 
    object(PHPExcel_Cell_DataValidation)[104]
      private 'formula1' => string '"Item A,Item B,Item C"' (length=22)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B7' => 
    object(PHPExcel_Cell_DataValidation)[105]
      private 'formula1' => string '$D$2:$D$6' (length=9)
      private 'formula2' => string '' (length=0)
      private 'type' => string 'list' (length=4)
      private 'errorStyle' => string 'information' (length=11)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean false
      private 'showDropDown' => boolean true
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Value is not in list.' (length=21)
      private 'promptTitle' => string 'Pick from list' (length=14)
      private 'prompt' => string 'Please pick a value from the drop-down list.' (length=44)
  'B9' => 
    object(PHPExcel_Cell_DataValidation)[107]
      private 'formula1' => int 6
      private 'formula2' => string '' (length=0)
      private 'type' => string 'textLength' (length=10)
      private 'errorStyle' => string 'stop' (length=4)
      private 'operator' => string '' (length=0)
      private 'allowBlank' => boolean true
      private 'showDropDown' => boolean false
      private 'showInputMessage' => boolean true
      private 'showErrorMessage' => boolean true
      private 'errorTitle' => string 'Input error' (length=11)
      private 'error' => string 'Text exceeds maximum length' (length=27)
      private 'promptTitle' => string 'Allowed input' (length=13)
      private 'prompt' => string 'Maximum text length is 6 characters.' (length=36)

$e =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:
object(PHPExcel_Writer_Exception)[131]
  protected 'message' => string 'No formula2' (length=11)
  private 'string' (Exception) => string '' (length=0)
  protected 'code' => int 0
  protected 'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
  protected 'line' => int 2931
  private 'trace' (Exception) => 
    array (size=3)
      0 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php' (length=98)
          'line' => int 495
          'function' => string 'writeDataValidity' (length=17)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      1 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5.php' (length=88)
          'line' => int 175
          'function' => string 'close' (length=5)
          'class' => string 'PHPExcel_Writer_Excel5_Worksheet' (length=32)
          'type' => string '->' (length=2)
          'args' => 
            array (size=0)
              ...
      2 => 
        array (size=6)
          'file' => string 'C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Examples\15datavalidation-xls.php' (length=87)
          'line' => int 140
          'function' => string 'save' (length=4)
          'class' => string 'PHPExcel_Writer_Excel5' (length=22)
          'type' => string '->' (length=2)
          'args' => 
            array (size=1)
              ...
  private 'previous' (Exception) => null
  public 'xdebug_message' => string '<tr><th align='left' bgcolor='#f57900' colspan="5"><span style='background-color: #cc0000; color: #fce94f; font-size: x-large;'>( ! )</span> PHPExcel_Writer_Exception: No formula2 in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php on line <i>2931</i></th></tr>
<tr><th align='left' bgcolor='#e9b96e' colspan='5'>Call Stack</th></tr>
<tr><th align='center' bgcolor='#eeeeec'>#</th><th align='left' bgcolor='#eeeeec'>Time</th><th align='left' bgcolor='#eeeeec'>Me'... (length=26122)

$error =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Value is not in list.' (length=21)

$errorStyle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'textLength' (length=10)

$errorTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Input error' (length=11)

$formula1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '%����' (length=9)

$formula2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$grbit =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$header =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '¾ß�' (length=4)

$horPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$length =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 223

$objId =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 4294967295

$operator =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string '' (length=0)

$options =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 787206

$prompt =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Please pick a value from the drop-down list.' (length=44)

$promptTitle =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:string 'Pick from list' (length=14)

$record =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 446

$sz1 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 9

$sz2 =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0

$type =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 6

$verPos =
C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Classes\PHPExcel\Writer\Excel5\Worksheet.php:2887:int 0
03:17:32 File written to 15datavalidation-xls.xls
Call time to write Workbook was 0.0434 seconds
03:17:32 Current memory usage: 2 MB
03:17:32 Peak memory usage: 2 MB
03:17:32 Done writing file
File has been created in C:\Apache24\htdocs\hris_neo\vendor\phpoffice\phpexcel\Examples