Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 4.0.x will end 8 May 2023 (12 months).
  • Bug fixes for security issues in 4.0.x will end 13 November 2023 (18 months).
  • PHP version: minimum PHP 7.3.0 Note: the minimum PHP version has increased since Moodle 3.10. PHP 7.4.x is also supported.
/lib/phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Calculation/LookupRef/ -> RowColumnInformation.php (source)

[Source view]

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

(no description)

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

Defines 1 class

RowColumnInformation:: (7 methods):
  cellAddressNullOrWhitespace()
  cellColumn()
  COLUMN()
  COLUMNS()
  cellRow()
  ROW()
  ROWS()


Class: RowColumnInformation  - X-Ref

cellAddressNullOrWhitespace($cellAddress)   X-Ref
Test if cellAddress is null or whitespace string.

param: null|array|string $cellAddress A reference to a range of cells

cellColumn(?Cell $cell)   X-Ref
No description

COLUMN($cellAddress = null, ?Cell $cell = null)   X-Ref
COLUMN.

Returns the column number of the given cell reference
If the cell reference is a range of cells, COLUMN returns the column numbers of each column
in the reference as a horizontal array.
If cell reference is omitted, and the function is being called through the calculation engine,
then it is assumed to be the reference of the cell in which the COLUMN function appears;
otherwise this function returns 1.

Excel Function:
=COLUMN([cellAddress])

return: int|int[]
param: null|array|string $cellAddress A reference to a range of cells for which you want the column numbers

COLUMNS($cellAddress = null)   X-Ref
COLUMNS.

Returns the number of columns in an array or reference.

Excel Function:
=COLUMNS(cellAddress)

return: int|string The number of columns in cellAddress, or a string if arguments are invalid
param: null|array|string $cellAddress An array or array formula, or a reference to a range of cells

cellRow(?Cell $cell)   X-Ref
No description

ROW($cellAddress = null, ?Cell $cell = null)   X-Ref
ROW.

Returns the row number of the given cell reference
If the cell reference is a range of cells, ROW returns the row numbers of each row in the reference
as a vertical array.
If cell reference is omitted, and the function is being called through the calculation engine,
then it is assumed to be the reference of the cell in which the ROW function appears;
otherwise this function returns 1.

Excel Function:
=ROW([cellAddress])

return: int|mixed[]|string
param: null|array|string $cellAddress A reference to a range of cells for which you want the row numbers

ROWS($cellAddress = null)   X-Ref
No description