Search moodle.org's
Developer Documentation
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.
Differences Between: [Versions 400 and 401] [Versions 401 and 402] [Versions 401 and 403]
(no description)
| File Size: | 129 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()
| 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 |
