Message-ID: <CAOxgQ=WOE-+zaeDWBZdKMoU5WqtnAvcBGzNBEhDydFDrUZfE7w@mail.gmail.com>
Date: 2014-11-21T19:30:38Z
From: Jennifer Sabatier
Subject: 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]]