Cells and data formats about sheetrock

[chriszarate]

Hi Daniel,

The spreadsheet isn't public, so I can't access it. (In the new Sheets, click "Share," then click "Advanced," then change the "Private" to "Anyone with the link" or "Public on the Web."

Chris

[kvizzt]

Hi Chris,
Thanks for reading this and taking your time, I have change the public settings according to your request.
I have completely missed that setting and that actually helped me with another "bug" (couldn't get it to work on my phone) Thanks.

[kvizzt]

Anyone else found a solution or point me to a direction?

[chriszarate]

Sheetrock passes along the number because it expects that you may want to use it math operations. The data from Google (sometimes) provides the formatted value, but currently there isn't an option to use it. I'll work on that. In the meantime, your options are:

1. Convert the cells to text.
2. If you're up for it, write your dataHandler function to use the f property of the cell data (instead of v).

[kvizzt]

Thank you so much for the answer and taking your time.

1. I not totally sure what you mean with "convert the cells to text" — I tried using the formatting: true/false option but no luck. But that might not be what you meant?
2. Seems a bit advanced for a novice/designer with limited coding/js skills :).

Looks like I've to wait for google or find another simple solution.

[chriszarate]

After extensive testing, it doesn't seem like Google's API just doesn't consistently support formatted text in a way that can be relied upon. I've now noted this in the documentation.