Is there an easy way to read the value of the cells rather than the formula? By the way I only get this problem in a spreadsheet that I have published but not in spreadsheets that are private. So for instance in a cell whose value was created by simply using the value from the cell immediately to the left in the Google spreadsheet I would prefer to get the value rather than =RC[-1]
When one exports with Google Spreadsheets as a csv then that does not happen.
I am using the following line of code in R y2009<-sheetAsMatrix(ts2$y2009,header=TRUE, as.data.frame=TRUE, trim=TRUE)