Search moodle.org's
Developer Documentation

See Release Notes

  • Bug fixes for general core bugs in 3.10.x will end 8 November 2021 (12 months).
  • Bug fixes for security issues in 3.10.x will end 9 May 2022 (18 months).
  • PHP version: minimum PHP 7.2.0 Note: minimum PHP version has increased since Moodle 3.8. PHP 7.3.x and 7.4.x are supported too.

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

(no description)

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

Defines 1 class


Class: Cells  - X-Ref

__construct(Worksheet $parent, CacheInterface $cache)   X-Ref
Initialise this new cell collection.

param: Worksheet $parent The worksheet for this cell collection
param: CacheInterface $cache

getParent()   X-Ref
Return the parent worksheet for this cell collection.

return: Worksheet

has($pCoord)   X-Ref
Whether the collection holds a cell for the given coordinate.

param: string $pCoord Coordinate of the cell to check
return: bool

update(Cell $cell)   X-Ref
Add or update a cell in the collection.

param: Cell $cell Cell to update
return: Cell

delete($pCoord)   X-Ref
Delete a cell in cache identified by coordinate.

param: string $pCoord Coordinate of the cell to delete

getCoordinates()   X-Ref
Get a list of all cell coordinates currently held in the collection.

return: string[]

getSortedCoordinates()   X-Ref
Get a sorted list of all cell coordinates currently held in the collection by row and column.

return: string[]

getHighestRowAndColumn()   X-Ref
Get highest worksheet column and highest row that have cell records.

return: array Highest column name and highest row number

getCurrentCoordinate()   X-Ref
Return the cell coordinate of the currently active cell object.

return: string

getCurrentColumn()   X-Ref
Return the column coordinate of the currently active cell object.

return: string

getCurrentRow()   X-Ref
Return the row coordinate of the currently active cell object.

return: int

getHighestColumn($row = null)   X-Ref
Get highest worksheet column.

param: string $row Return the highest column for the specified row,
return: string Highest column name

getHighestRow($column = null)   X-Ref
Get highest worksheet row.

param: string $column Return the highest row for the specified column,
return: int Highest row number

getUniqueID()   X-Ref
Generate a unique ID for cache referencing.

return: string Unique Reference

cloneCellCollection(Worksheet $parent)   X-Ref
Clone the cell collection.

param: Worksheet $parent The new worksheet that we're copying to
return: self

removeRow($row)   X-Ref
Remove a row, deleting all cells in that row.

param: string $row Row number to remove

removeColumn($column)   X-Ref
Remove a column, deleting all cells in that column.

param: string $column Column ID to remove

storeCurrentCell()   X-Ref
Store cell data in cache for the current cell object if it's "dirty",
and the 'nullify' the current cell object.


add($pCoord, Cell $cell)   X-Ref
Add or update a cell identified by its coordinate into the collection.

param: string $pCoord Coordinate of the cell to update
param: Cell $cell Cell to update
return: \PhpOffice\PhpSpreadsheet\Cell\Cell

get($pCoord)   X-Ref
Get cell at a specific coordinate.

param: string $pCoord Coordinate of the cell
return: \PhpOffice\PhpSpreadsheet\Cell\Cell Cell that was found, or null if not found

unsetWorksheetCells()   X-Ref
Clear the cell collection and disconnect from our parent.


__destruct()   X-Ref
Destroy this cell collection.


getAllCacheKeys()   X-Ref
Returns all known cache keys.

return: \Generator|string[]