private function PHPExcel_Writer_Excel5_Worksheet::_writeBIFF8CellRangeAddressFixed in Loft Data Grids 6.2

Same name and namespace in other branches

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

* Write a cell range address in BIFF8 * always fixed range * See section 2.5.14 in OpenOffice.org's Documentation of the Microsoft Excel File Format * *

Parameters

string $range E.g. 'A1' or 'A1:B6': * @return string Binary data

2 calls to PHPExcel_Writer_Excel5_Worksheet::_writeBIFF8CellRangeAddressFixed()

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

* Store the DATAVALIDATIONS and DATAVALIDATION records.

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

* Write BIFF record RANGEPROTECTION * * Openoffice.org's Documentaion of the Microsoft Excel File Format uses term RANGEPROTECTION for these records * Microsoft Office Excel 97-2007 Binary File Format Specification uses term FEAT for these…

File

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

Class

PHPExcel_Writer_Excel5_Worksheet

PHPExcel_Writer_Excel5_Worksheet

Code

private function _writeBIFF8CellRangeAddressFixed($range = 'A1') {
  $explodes = explode(':', $range);

  // extract first cell, e.g. 'A1'
  $firstCell = $explodes[0];

  // extract last cell, e.g. 'B6'
  if (count($explodes) == 1) {
    $lastCell = $firstCell;
  }
  else {
    $lastCell = $explodes[1];
  }
  $firstCellCoordinates = PHPExcel_Cell::coordinateFromString($firstCell);

  // e.g. array(0, 1)
  $lastCellCoordinates = PHPExcel_Cell::coordinateFromString($lastCell);

  // e.g. array(1, 6)
  return pack('vvvv', $firstCellCoordinates[1] - 1, $lastCellCoordinates[1] - 1, PHPExcel_Cell::columnIndexFromString($firstCellCoordinates[0]) - 1, PHPExcel_Cell::columnIndexFromString($lastCellCoordinates[0]) - 1);
}