private function PHPExcel_Reader_Excel5::_getFormulaFromData in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php \PHPExcel_Reader_Excel5::_getFormulaFromData()

* Take formula data and additional data for formula and return human readable formula * *

Parameters

string $formulaData The binary data for the formula itself: * @param string $additionalData Additional binary data going with the formula * @param string $baseCell Base cell, only needed when formula contains tRefN tokens, e.g. with shared formulas * @return string Human readable formula

2 calls to PHPExcel_Reader_Excel5::_getFormulaFromData()

PHPExcel_Reader_Excel5::_getFormulaFromStructure in vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php

* Convert formula structure into human readable Excel formula like 'A3+A5*5' * *

PHPExcel_Reader_Excel5::_getNextToken in vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php

* Fetch next token from binary formula data * *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php, line 5256

Class

PHPExcel_Reader_Excel5

PHPExcel_Reader_Excel5

Code

private function _getFormulaFromData($formulaData, $additionalData = '', $baseCell = 'A1') {

  // start parsing the formula data
  $tokens = array();
  while (strlen($formulaData) > 0 and $token = $this
    ->_getNextToken($formulaData, $baseCell)) {
    $tokens[] = $token;
    $formulaData = substr($formulaData, $token['size']);

    // for debug: dump the token

    //var_dump($token);
  }
  $formulaString = $this
    ->_createFormulaFromTokens($tokens, $additionalData);
  return $formulaString;
}