private function PHPExcel_Reader_Excel5::_readBIFF8CellRangeAddressFixed in Loft Data Grids 7.2

Same name and namespace in other branches

1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php \PHPExcel_Reader_Excel5::_readBIFF8CellRangeAddressFixed()

* Reads a cell range address in BIFF8 e.g. 'A2:B6' or 'A1' * always fixed range * section 2.5.14 * *

Parameters

string $subData: * @return string * @throws PHPExcel_Reader_Exception

3 calls to PHPExcel_Reader_Excel5::_readBIFF8CellRangeAddressFixed()

PHPExcel_Reader_Excel5::_readBIFF8CellRangeAddressList in vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php

* Read BIFF8 cell range address list * section 2.5.15 * *

PHPExcel_Reader_Excel5::_readHyperLink in vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php

* Read HYPERLINK record

PHPExcel_Reader_Excel5::_readRangeProtection in vendor/phpoffice/phpexcel/Classes/PHPExcel/Reader/Excel5.php

* Read RANGEPROTECTION record * Reading of this record is based on Microsoft Office Excel 97-2000 Binary File Format Specification, * where it is referred to as FEAT record

File

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

Class

PHPExcel_Reader_Excel5

PHPExcel_Reader_Excel5

Code

private function _readBIFF8CellRangeAddressFixed($subData) {

  // offset: 0; size: 2; index to first row
  $fr = self::_GetInt2d($subData, 0) + 1;

  // offset: 2; size: 2; index to last row
  $lr = self::_GetInt2d($subData, 2) + 1;

  // offset: 4; size: 2; index to first column
  $fc = self::_GetInt2d($subData, 4);

  // offset: 6; size: 2; index to last column
  $lc = self::_GetInt2d($subData, 6);

  // check values
  if ($fr > $lr || $fc > $lc) {
    throw new PHPExcel_Reader_Exception('Not a cell range address');
  }

  // column index to letter
  $fc = PHPExcel_Cell::stringFromColumnIndex($fc);
  $lc = PHPExcel_Cell::stringFromColumnIndex($lc);
  if ($fr == $lr and $fc == $lc) {
    return "{$fc}{$fr}";
  }
  return "{$fc}{$fr}:{$lc}{$lr}";
}