private function PHPExcel_Writer_Excel5_Workbook::_writeNameLong 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::_writeNameLong()

* Store the NAME record in the long format that is used for storing the repeat * rows and columns when both are specified. This shares a lot of code with * _writeNameShort() but we use a separate method to keep the code clean. * Code abstraction for reuse can be carried too far, and I should know. ;-) * *

Parameters

integer $index Sheet index: * @param integer $type Built-in name type * @param integer $rowmin Start row * @param integer $rowmax End row * @param integer $colmin Start colum * @param integer $colmax End column

1 call to PHPExcel_Writer_Excel5_Workbook::_writeNameLong()

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

* Write the NAME record to define the print area and the repeat rows and cols.

File

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

Class

PHPExcel_Writer_Excel5_Workbook

PHPExcel_Writer_Excel5_Workbook

Code

private function _writeNameLong($index, $type, $rowmin, $rowmax, $colmin, $colmax) {
  $record = 0x18;

  // Record identifier
  $length = 0x3d;

  // Number of bytes to follow
  $grbit = 0x20;

  // Option flags
  $chKey = 0x0;

  // Keyboard shortcut
  $cch = 0x1;

  // Length of text name
  $cce = 0x2e;

  // Length of text definition
  $ixals = $index + 1;

  // Sheet index
  $itab = $ixals;

  // Equal to ixals
  $cchCustMenu = 0x0;

  // Length of cust menu text
  $cchDescription = 0x0;

  // Length of description text
  $cchHelptopic = 0x0;

  // Length of help topic text
  $cchStatustext = 0x0;

  // Length of status bar text
  $rgch = $type;

  // Built-in name type
  $unknown01 = 0x29;
  $unknown02 = 0x2b;
  $unknown03 = 0x3b;
  $unknown04 = 0xffff - $index;
  $unknown05 = 0x0;
  $unknown06 = 0x0;
  $unknown07 = 0x1087;
  $unknown08 = 0x8008;
  $header = pack("vv", $record, $length);
  $data = pack("v", $grbit);
  $data .= pack("C", $chKey);
  $data .= pack("C", $cch);
  $data .= pack("v", $cce);
  $data .= pack("v", $ixals);
  $data .= pack("v", $itab);
  $data .= pack("C", $cchCustMenu);
  $data .= pack("C", $cchDescription);
  $data .= pack("C", $cchHelptopic);
  $data .= pack("C", $cchStatustext);
  $data .= pack("C", $rgch);
  $data .= pack("C", $unknown01);
  $data .= pack("v", $unknown02);

  // Column definition
  $data .= pack("C", $unknown03);
  $data .= pack("v", $unknown04);
  $data .= pack("v", $unknown05);
  $data .= pack("v", $unknown06);
  $data .= pack("v", $unknown07);
  $data .= pack("v", $unknown08);
  $data .= pack("v", $index);
  $data .= pack("v", $index);
  $data .= pack("v", 0x0);
  $data .= pack("v", 0x3fff);
  $data .= pack("C", $colmin);
  $data .= pack("C", $colmax);

  // Row definition
  $data .= pack("C", $unknown03);
  $data .= pack("v", $unknown04);
  $data .= pack("v", $unknown05);
  $data .= pack("v", $unknown06);
  $data .= pack("v", $unknown07);
  $data .= pack("v", $unknown08);
  $data .= pack("v", $index);
  $data .= pack("v", $index);
  $data .= pack("v", $rowmin);
  $data .= pack("v", $rowmax);
  $data .= pack("C", 0x0);
  $data .= pack("C", 0xff);

  // End of data
  $data .= pack("C", 0x10);
  $this
    ->_append($header . $data);
}