R help - Nov 2014 - More RGoogleDocs - R1C1 reference style

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]]

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.

On November 21, 2014 11:30:38 AM PST, Jennifer Sabatier <plessthanpointohfive
at gmail.com> wrote:
>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.