cell_addr class

The cell_addr class is used to hold the absolute row and column location for one or more cells. An object of class cell_addr is a list with two components of equal length, named row and col, consisting of integers greater than or equal to one or NA. This is in contrast to the ra_ref class, which holds a representation of a single absolute, relative, or mixed cell reference from, e.g., a formula.

cell_addr(row, col)

Arguments

row

integer. Must be the same length as col or of length one, which will be recycled to the length of col.

col

integer. Same deal as for row.

Value

a cell_addr object

Reference

Spreadsheet Implementation Technology: Basics and Extensions Peter Sestoft MIT Press 2014

Examples

cell_addr(4, 3)
#> <cell_addr: 1 cells>
#> # A tibble: 1 × 2
#>     row   col
#>   <int> <int>
#> 1     4     3
#> 
(ca <- cell_addr(1:4, 3))
#> <cell_addr: 4 cells>
#> # A tibble: 4 × 2
#>     row   col
#>   <int> <int>
#> 1     1     3
#> 2     2     3
#> 3     3     3
#> 4     4     3
#> 
ca[2:3]
#> <cell_addr: 2 cells>
#> # A tibble: 2 × 2
#>     row   col
#>   <int> <int>
#> 1     2     3
#> 2     3     3
#> 
ca[[4]]
#> <cell_addr: 1 cells>
#> # A tibble: 1 × 2
#>     row   col
#>   <int> <int>
#> 1     4     3
#> 
length(ca)
#> [1] 4