private function PHPExcel_Writer_Excel5_Worksheet::_writeWindow2 in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php \PHPExcel_Writer_Excel5_Worksheet::_writeWindow2()

* Write BIFF record Window2.

1 call to PHPExcel_Writer_Excel5_Worksheet::_writeWindow2()

PHPExcel_Writer_Excel5_Worksheet::close in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php

* Add data to the beginning of the workbook (note the reverse order) * and to the end of the workbook. * * @access public *

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Worksheet.php, line 1289

Class

PHPExcel_Writer_Excel5_Worksheet

PHPExcel_Writer_Excel5_Worksheet

Code

private function _writeWindow2() {
  $record = 0x23e;

  // Record identifier
  $length = 0x12;
  $grbit = 0xb6;

  // Option flags
  $rwTop = 0x0;

  // Top row visible in window
  $colLeft = 0x0;

  // Leftmost column visible in window
  // The options flags that comprise $grbit
  $fDspFmla = 0;

  // 0 - bit
  $fDspGrid = $this->_phpSheet
    ->getShowGridlines() ? 1 : 0;

  // 1
  $fDspRwCol = $this->_phpSheet
    ->getShowRowColHeaders() ? 1 : 0;

  // 2
  $fFrozen = $this->_phpSheet
    ->getFreezePane() ? 1 : 0;

  // 3
  $fDspZeros = 1;

  // 4
  $fDefaultHdr = 1;

  // 5
  $fArabic = $this->_phpSheet
    ->getRightToLeft() ? 1 : 0;

  // 6
  $fDspGuts = $this->_outline_on;

  // 7
  $fFrozenNoSplit = 0;

  // 0 - bit
  // no support in PHPExcel for selected sheet, therefore sheet is only selected if it is the active sheet
  $fSelected = $this->_phpSheet === $this->_phpSheet
    ->getParent()
    ->getActiveSheet() ? 1 : 0;
  $fPaged = 1;

  // 2
  $fPageBreakPreview = $this->_phpSheet
    ->getSheetView()
    ->getView() === PHPExcel_Worksheet_SheetView::SHEETVIEW_PAGE_BREAK_PREVIEW;
  $grbit = $fDspFmla;
  $grbit |= $fDspGrid << 1;
  $grbit |= $fDspRwCol << 2;
  $grbit |= $fFrozen << 3;
  $grbit |= $fDspZeros << 4;
  $grbit |= $fDefaultHdr << 5;
  $grbit |= $fArabic << 6;
  $grbit |= $fDspGuts << 7;
  $grbit |= $fFrozenNoSplit << 8;
  $grbit |= $fSelected << 9;
  $grbit |= $fPaged << 10;
  $grbit |= $fPageBreakPreview << 11;
  $header = pack("vv", $record, $length);
  $data = pack("vvv", $grbit, $rwTop, $colLeft);

  // FIXME !!!
  $rgbHdr = 0x40;

  // Row/column heading and gridline color index
  $zoom_factor_page_break = $fPageBreakPreview ? $this->_phpSheet
    ->getSheetView()
    ->getZoomScale() : 0x0;
  $zoom_factor_normal = $this->_phpSheet
    ->getSheetView()
    ->getZoomScaleNormal();
  $data .= pack("vvvvV", $rgbHdr, 0x0, $zoom_factor_page_break, $zoom_factor_normal, 0x0);
  $this
    ->_append($header . $data);
}