private function PHPExcel_Writer_Excel5_Workbook::_writeShortNameBiff8 in Loft Data Grids 6.2

Same name and namespace in other branches

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

* Write a short NAME record * *

Parameters

string $name: * @param string $sheetIndex 1-based sheet index the defined name applies to. 0 = global * @param integer[][] $rangeBounds range boundaries * @param boolean $isHidden * @return string Complete binary record data *

1 call to PHPExcel_Writer_Excel5_Workbook::_writeShortNameBiff8()

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 845

Class

PHPExcel_Writer_Excel5_Workbook

PHPExcel_Writer_Excel5_Workbook

Code

private function _writeShortNameBiff8($name, $sheetIndex = 0, $rangeBounds, $isHidden = false) {
  $record = 0x18;

  // option flags
  $options = $isHidden ? 0x21 : 0x0;
  $extra = pack('Cvvvvv', 0x3b, $sheetIndex - 1, $rangeBounds[0][1] - 1, $rangeBounds[1][1] - 1, $rangeBounds[0][0] - 1, $rangeBounds[1][0] - 1);

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

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