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.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/ -> Indirect.php (source)

[Source view]

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

(no description)

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

Defines 1 class

Indirect:: (5 methods):
  a1Format()
  validateAddress()
  INDIRECT()
  extractRequiredCells()
  handleRowColumnRanges()


Class: Indirect  - X-Ref

a1Format($a1fmt)   X-Ref
Determine whether cell address is in A1 (true) or R1C1 (false) format.

param: mixed $a1fmt Expect bool Helpers::CELLADDRESS_USE_A1 or CELLADDRESS_USE_R1C1,

validateAddress($cellAddress)   X-Ref
Convert cellAddress to string, verify not null string.

param: array|string $cellAddress

INDIRECT($cellAddress, $a1fmt, Cell $cell)   X-Ref
INDIRECT.

Returns the reference specified by a text string.
References are immediately evaluated to display their contents.

Excel Function:
=INDIRECT(cellAddress, bool) where the bool argument is optional

param: array|string $cellAddress $cellAddress The cell address of the current cell (containing this formula)
param: mixed $a1fmt Expect bool Helpers::CELLADDRESS_USE_A1 or CELLADDRESS_USE_R1C1,
param: Cell $cell The current cell (containing this formula)
return: array|string An array containing a cell or range of cells, or a string on error

extractRequiredCells(?Worksheet $worksheet, string $cellAddress)   X-Ref
Extract range values.

return: mixed Array of values in range if range contains more than one element.

handleRowColumnRanges(?Worksheet $worksheet, string $start, string $end)   X-Ref
No description