Rebooting to support parsing of spreadsheet formulas and cell references as they appear in unevaluated expressions. This work is still in progress but a CRAN update is required now to update a test for testthat v1.0.x.
Package is beginning to implement classes and methods related to cell location and reference from 'Spreadsheet Implementation Technology' by Peter Sestoft, MIT Press, 2014.
New classes:
cell_addr
: one or more absolute cell addressesra_ref
: single absolute, relative, or mixed cell referenceThe two components of a cell_limits
object now correspond NOT to row and column limits, but rather to the upper left and lower right cells of the rectangle. See #6. It was too confusing to have different conventions for the object and its print method.
If the maximum row or column is specified, but the minimum is not, then we automatically set the associated minimum to 1, instead of leaving as NA
.
The header
argument of anchored()
has been renamed to col_names
, for greater consistency with readr
, readxl
, and googlesheets
.
Added a NULL
method for as.cell_limits
generic so that as.cell_limits(NULL)
returns default, degenerate cell limits, i.e. the min and max for rows and columns are uniformly NA
.
A cell_limits
object now inherits from "list".
Any scripts or data that you put into this service are public.
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.