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/Calculation/LookupRef/ -> Address.php (source)

[Source view]

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

(no description)

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

Defines 1 class

Address:: (4 methods):
  cell()
  sheetName()
  formatAsA1()
  formatAsR1C1()


Class: Address  - X-Ref

cell($row, $column, $relativity = 1, $referenceStyle = true, $sheetName = '')   X-Ref
ADDRESS.

Creates a cell address as text, given specified row and column numbers.

Excel Function:
=ADDRESS(row, column, [relativity], [referenceStyle], [sheetText])

param: mixed $row Row number (integer) to use in the cell reference
param: mixed $column Column number (integer) to use in the cell reference
param: mixed $relativity Integer flag indicating the type of reference to return
param: mixed $referenceStyle A logical (boolean) value that specifies the A1 or R1C1 reference style.
param: mixed $sheetName Optional Name of worksheet to use
return: array|string

sheetName(string $sheetName)   X-Ref
No description

formatAsA1(int $row, int $column, int $relativity, string $sheetName)   X-Ref
No description

formatAsR1C1(int $row, int $column, int $relativity, string $sheetName)   X-Ref
No description