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/ -> RowColumnInformation.php (source)

[Source view]

Differences Between: [Versions 400 and 401]

(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])

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

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

Returns the number of columns in an array or reference.

Excel Function:
=COLUMNS(cellAddress)

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

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])

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

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