private function PHPExcel_Writer_Excel5_Workbook::_writeDefinedNameBiff8 in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Workbook.php \PHPExcel_Writer_Excel5_Workbook::_writeDefinedNameBiff8()

* Write a DEFINEDNAME record for BIFF8 using explicit binary formula data * *

Parameters

string $name The name in UTF-8: * @param string $formulaData The binary formula data * @param string $sheetIndex 1-based sheet index the defined name applies to. 0 = global * @param boolean $isBuiltIn Built-in name? * @return string Complete binary record data

1 call to PHPExcel_Writer_Excel5_Workbook::_writeDefinedNameBiff8()

PHPExcel_Writer_Excel5_Workbook::_writeAllDefinedNamesBiff8 in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Workbook.php

* Writes all the DEFINEDNAME records (BIFF8). * So far this is only used for repeating rows/columns (print titles) and print areas

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Workbook.php, line 810

Class

PHPExcel_Writer_Excel5_Workbook

PHPExcel_Writer_Excel5_Workbook

Code

private function _writeDefinedNameBiff8($name, $formulaData, $sheetIndex = 0, $isBuiltIn = false) {
  $record = 0x18;

  // option flags
  $options = $isBuiltIn ? 0x20 : 0x0;

  // length of the name, character count
  $nlen = PHPExcel_Shared_String::CountCharacters($name);

  // name with stripped length field
  $name = substr(PHPExcel_Shared_String::UTF8toBIFF8UnicodeLong($name), 2);

  // size of the formula (in bytes)
  $sz = strlen($formulaData);

  // combine the parts
  $data = pack('vCCvvvCCCC', $options, 0, $nlen, $sz, 0, $sheetIndex, 0, 0, 0, 0) . $name . $formulaData;
  $length = strlen($data);
  $header = pack('vv', $record, $length);
  return $header . $data;
}