More RGoogleDocs - R1C1 reference style

You appear to be using a package that are not even on CRAN, much less base R, so you need to tell us that in your (missing) reproducible example. It is self-described as "primitive", so don't be surprised when it acts odd.

Note that your creation of an exposed Google account in your previous thread violates your terms of service with Google.. they provide perfectly straightforward mechanisms for sharing individual documents publicly without creating opportunities for abuse or risking your other data.

Please do read the footer of any message on this list:

PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html

which says, among other things, that you should be posting in plain text on this list.
Also note:

and provide commented, minimal, self-contained, reproducible code.

---------------------------------------------------------------------------
Jeff Newmiller                        The     .....       .....  Go Live...
DCN:<jdnewmil at dcn.davis.ca.us>        Basics: ##.#.       ##.#.  Live Go...
                                      Live:   OO#.. Dead: OO#..  Playing
Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
/Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
--------------------------------------------------------------------------- 
Sent from my phone. Please excuse my brevity.

Thank you all for helping grab data off Google Docs.

Now I have another problem.

When I pull the data all the formulas come into R as R1C1 reference
style,
while in Google Docs they're A1 reference style.

As a result, the formulas are strings in the cells, rather than values:


=AND((R[0]C[34]=1),(R[0]C[36]=3),(R[0]C[40]=3))

Now this isn't happening in the example I made up.  It's just happening
with the real data, which I can't even begin to share.

Is there a way to prevent this from happening?

Best,

Jen

[[alternative HTML version deleted]]

______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.