Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.11.x will end 14 Nov 2022 (12 months plus 6 months extension).
  • Bug fixes for security issues in 3.11.x will end 13 Nov 2023 (18 months plus 12 months extension).
  • PHP version: minimum PHP 7.3.0 Note: minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is supported too.

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

(no description)

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

Defines 1 class

AddressHelper:: (3 methods):
  convertToA1()
  convertFormulaToA1()
  convertToR1C1()


Class: AddressHelper  - X-Ref

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


convertFormulaToA1(string $formula,int $currentRowNumber = 1,int $currentColumnNumber = 1)   X-Ref
Converts a formula that uses R1C1 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.