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

[Source view]

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

(no description)

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

Defines 1 class

Offset:: (6 methods):
  OFFSET()
  extractRequiredCells()
  extractWorksheet()
  assessCellAddress()
  adjustEndCellColumnForWidth()
  adustEndCellRowForHeight()


Class: Offset  - X-Ref

OFFSET($cellAddress = null, $rows = 0, $columns = 0, $height = null, $width = null, ?Cell $cell = null)   X-Ref
OFFSET.

Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells.
The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and
the number of columns to be returned.

Excel Function:
=OFFSET(cellAddress, rows, cols, [height], [width])

param: null|string $cellAddress The reference from which you want to base the offset.
param: mixed $rows The number of rows, up or down, that you want the upper-left cell to refer to.
param: mixed $columns The number of columns, to the left or right, that you want the upper-left cell
param: mixed $height The height, in number of rows, that you want the returned reference to be.
param: mixed $width The width, in number of columns, that you want the returned reference to be.
return: array|int|string An array containing a cell or range of cells, or a string on error

extractRequiredCells(?Worksheet $worksheet, string $cellAddress)   X-Ref
No description

extractWorksheet($cellAddress, Cell $cell)   X-Ref
No description

assessCellAddress(string $cellAddress, Cell $cell)   X-Ref
No description

adjustEndCellColumnForWidth(string $endCellColumn, $width, int $startCellColumn, $columns)   X-Ref
No description

adustEndCellRowForHeight($height, int $startCellRow, $rows, $endCellRow)   X-Ref
No description