[R] More RGoogleDocs - R1C1 reference style

Jennifer Sabatier plessthanpointohfive at gmail.com
Fri Nov 21 20:30:38 CET 2014


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



More information about the R-help mailing list