private function PHPExcel_Reader_Excel5::_getFormulaFromStructure 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::_getFormulaFromStructure()

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

Parameters

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

5 calls to PHPExcel_Reader_Excel5::_getFormulaFromStructure()

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

* Loads PHPExcel from file * *

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

* Read DATAVALIDATION record

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

* DEFINEDNAME * * This record is part of a Link Table. It contains the name * and the token array of an internal defined name. Token * arrays of defined names contain tokens with aberrant * token classes. * *…

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

* Read EXTERNNAME record.

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

* Read FORMULA record + perhaps a following STRING record if formula result is a string * This record contains the token array and the result of a * formula cell. * * -- "OpenOffice.org's Documentation of the Microsoft * Excel…

File

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

Class

PHPExcel_Reader_Excel5

PHPExcel_Reader_Excel5

Code

private function _getFormulaFromStructure($formulaStructure, $baseCell = 'A1') {

  // offset: 0; size: 2; size of the following formula data
  $sz = self::_GetInt2d($formulaStructure, 0);

  // offset: 2; size: sz
  $formulaData = substr($formulaStructure, 2, $sz);

  // for debug: dump the formula data

  //echo '<xmp>';

  //echo 'size: ' . $sz . "\n";

  //echo 'the entire formula data: ';

  //Debug::dump($formulaData);

  //echo "\n----\n";

  // offset: 2 + sz; size: variable (optional)
  if (strlen($formulaStructure) > 2 + $sz) {
    $additionalData = substr($formulaStructure, 2 + $sz);

    // for debug: dump the additional data

    //echo 'the entire additional data: ';

    //Debug::dump($additionalData);

    //echo "\n----\n";
  }
  else {
    $additionalData = '';
  }
  return $this
    ->_getFormulaFromData($formulaData, $additionalData, $baseCell);
}