Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.3.x will end 7 October 2024 (12 months).
  • Bug fixes for security issues in 4.3.x will end 21 April 2025 (18 months).
  • PHP version: minimum PHP 8.0.0 Note: minimum PHP version has increased since Moodle 4.1. PHP 8.2.x is supported too.

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

(no description)

File Size: 177 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.