public static function PHPExcel_Cell::absoluteCoordinate in Loft Data Grids 6.2

Same name and namespace in other branches

1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php \PHPExcel_Cell::absoluteCoordinate()

* Make string coordinate absolute * *

Parameters

string $pCoordinateString e.g. 'A1': * @return string Absolute coordinate e.g. '$A$1' * @throws PHPExcel_Exception

3 calls to PHPExcel_Cell::absoluteCoordinate()

PHPExcel_Cell::absoluteReference in vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php

* Make string row, column or cell coordinate absolute * *

PHPExcel_Writer_Excel2007_Workbook::_writeDefinedNameForAutofilter in vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel2007/Workbook.php

* Write Defined Name for autoFilter * *

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

* Writes all the DEFINEDNAME records (BIFF8). * So far this is only used for repeating rows/columns (print titles) and print areas

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell.php, line 631

Class

PHPExcel_Cell

PHPExcel_Cell

Code

public static function absoluteCoordinate($pCoordinateString = 'A1') {
  if (strpos($pCoordinateString, ':') === FALSE && strpos($pCoordinateString, ',') === FALSE) {

    // Split out any worksheet name from the coordinate
    $worksheet = '';
    $cellAddress = explode('!', $pCoordinateString);
    if (count($cellAddress) > 1) {
      list($worksheet, $pCoordinateString) = $cellAddress;
    }
    if ($worksheet > '') {
      $worksheet .= '!';
    }

    // Create absolute coordinate
    list($column, $row) = self::coordinateFromString($pCoordinateString);
    $column = ltrim($column, '$');
    $row = ltrim($row, '$');
    return $worksheet . '$' . $column . '$' . $row;
  }
  throw new PHPExcel_Exception('Cell coordinate string can not be a range of cells');
}