ReportSheet Functions

ReportSheet provides formula functions for retrieving values from hierarchical spilled cells, performing contextual calculations, and getting pagination information.

The following ReportSheet-specific functions are available:

Category	Function	Description
Hierarchical Cell	`R.V`	Returns values from a spilled cell based on the specified offsets or context cells.
	`R.A`	Specifies an absolute offset for retrieving a spilled cell value. This function is used as an argument of the `R.V` function.
	`R.R`	Specifies a relative offset for retrieving a spilled cell value. This function is used as an argument of the `R.V` function.
	`R.INDEX`	Returns the index of a spilled cell, optionally within the specified context.
	`R.RANK`	Returns the rank of a spilled cell based on the specified context, sort order, and ranking mode.
Contextual Analysis	`R.MOM`	Returns the month-over-month ratio of a cell value.
	`R.YOY`	Returns the year-over-year ratio of a cell value.
	`R.PROPORTION`	Returns the proportion of a cell value within the specified context.
	`R.CUMULATIVE`	Returns the cumulative value of a cell within the specified context.
Pagination	`R.CURRENTPAGE`	Returns the current page number of the report or the current Master-Detail group.
Pagination	`R.PAGECOUNT`	Returns the total number of pages in the report or the current Master-Detail group. The former name, `R.PAGESCOUNT`, is still supported for backward compatibility.