search

rsheets / cellranger

Helper functions to work with spreadsheets and the "A1:D10" style of cell range specification
Other
50 stars 6 forks source link

Expose parsed ref string #22

Open jennybc opened 8 years ago

jennybc commented 8 years ago

This is going to be handy elsewhere:

Make sure I can get Sheet1 from reasonable representations of Sheet1!$B$2:$B$11.

jennybc commented 8 years ago

Upon further thought, I think I need to make parse_ref_string() nicer and export it:

https://github.com/rsheets/cellranger/blob/652fa2dbba6b8f5a7ed58ee1254223f3febedfd3/R/A1-R1C1-regex-utils.R#L89-L105

Re: the cell ref specifically, parsed output should include ref and probably ul and lr. Examples:

ref = $B$2, ul and lr are either both $B$2 or both NA

ref = $B$2:$B$11, ul = $B$2, lr = $B$11