Search moodle.org's
Developer Documentation

See Release Notes
Long Term Support Release

  • Bug fixes for general core bugs in 4.1.x will end 13 November 2023 (12 months).
  • Bug fixes for security issues in 4.1.x will end 10 November 2025 (36 months).
  • PHP version: minimum PHP 7.4.0 Note: minimum PHP version has increased since Moodle 4.0. PHP 8.0.x is supported too.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Cell/ -> AddressHelper.php (source)

[Source view]

Differences Between: [Versions 311 and 401] [Versions 400 and 401] [Versions 401 and 402] [Versions 401 and 403]

(no description)

File Size: 174 lines (7 kb)
Included or required:0 times
Referenced: 0 times
Includes or requires: 0 files

Defines 1 class

AddressHelper:: (5 methods):
  getRowAndColumnChars()
  convertToA1()
  convertSpreadsheetMLFormula()
  convertFormulaToA1()
  convertToR1C1()


Class: AddressHelper  - X-Ref

getRowAndColumnChars()   X-Ref
No description

convertToA1(string $address,int $currentRowNumber = 1,int $currentColumnNumber = 1,bool $useLocale = true)   X-Ref
Converts an R1C1 format cell address to an A1 format cell address.


convertSpreadsheetMLFormula(string $formula)   X-Ref
No description

convertFormulaToA1(string $formula,int $currentRowNumber = 1,int $currentColumnNumber = 1)   X-Ref
Converts a formula that uses R1C1/SpreadsheetXML format cell address to an A1 format cell address.


convertToR1C1(string $address,?int $currentRowNumber = null,?int $currentColumnNumber = null)   X-Ref
Converts an A1 format cell address to an R1C1 format cell address.
If $currentRowNumber or $currentColumnNumber are provided, then the R1C1 address will be formatted as a relative address.