You are here

private function PHPExcel_Reader_Excel5_Escher::_readClientAnchor in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5/Escher.php \PHPExcel_Reader_Excel5_Escher::_readClientAnchor()

* Read ClientAnchor record. This record holds information about where the shape is anchored in worksheet

1 call to PHPExcel_Reader_Excel5_Escher::_readClientAnchor()
PHPExcel_Reader_Excel5_Escher::load in vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5/Escher.php
* Load Escher stream data. May be a partial Escher stream. * *

File

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

Class

PHPExcel_Reader_Excel5_Escher
PHPExcel_Reader_Excel5_Escher

Code

private function _readClientAnchor() {
  $length = PHPExcel_Reader_Excel5::_GetInt4d($this->_data, $this->_pos + 4);
  $recordData = substr($this->_data, $this->_pos + 8, $length);

  // move stream pointer to next record
  $this->_pos += 8 + $length;

  // offset: 2; size: 2; upper-left corner column index (0-based)
  $c1 = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 2);

  // offset: 4; size: 2; upper-left corner horizontal offset in 1/1024 of column width
  $startOffsetX = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 4);

  // offset: 6; size: 2; upper-left corner row index (0-based)
  $r1 = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 6);

  // offset: 8; size: 2; upper-left corner vertical offset in 1/256 of row height
  $startOffsetY = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 8);

  // offset: 10; size: 2; bottom-right corner column index (0-based)
  $c2 = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 10);

  // offset: 12; size: 2; bottom-right corner horizontal offset in 1/1024 of column width
  $endOffsetX = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 12);

  // offset: 14; size: 2; bottom-right corner row index (0-based)
  $r2 = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 14);

  // offset: 16; size: 2; bottom-right corner vertical offset in 1/256 of row height
  $endOffsetY = PHPExcel_Reader_Excel5::_GetInt2d($recordData, 16);

  // set the start coordinates
  $this->_object
    ->setStartCoordinates(PHPExcel_Cell::stringFromColumnIndex($c1) . ($r1 + 1));

  // set the start offsetX
  $this->_object
    ->setStartOffsetX($startOffsetX);

  // set the start offsetY
  $this->_object
    ->setStartOffsetY($startOffsetY);

  // set the end coordinates
  $this->_object
    ->setEndCoordinates(PHPExcel_Cell::stringFromColumnIndex($c2) . ($r2 + 1));

  // set the end offsetX
  $this->_object
    ->setEndOffsetX($endOffsetX);

  // set the end offsetY
  $this->_object
    ->setEndOffsetY($endOffsetY);
}