Differences Between: [Versions 400 and 401] [Versions 400 and 402] [Versions 400 and 403]
(no description)
File Size: | 97 lines (3 kb) |
Included or required: | 0 times |
Referenced: | 0 times |
Includes or requires: | 0 files |
Indirect:: (4 methods):
a1Format()
validateAddress()
INDIRECT()
extractRequiredCells()
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 return: array|string An array containing a cell or range of cells, or a string on error 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) |
extractRequiredCells(?Worksheet $worksheet, string $cellAddress) X-Ref |
Extract range values. return: mixed Array of values in range if range contains more than one element. |