Answer the question
In order to leave comments, you need to log in
How to insert a string with a number into a google spreadsheet via api without formatting?
through google script, I parse the received data and insert it into the cells via appendRow()
, everything would be fine, but the string with a number with a dot like "12408518123.438439348" is cut off,
and it is cut off not only because of the formatting in the table itself to "23432314.3", but also itself a string if you look at its properties up to the form "14124124214.35345", that is, in any case, not the whole string is visible.
But if you add any letter to the string, then everything is inserted entirely and without formatting.
Question: How can I insert an uncut string with numbers without adding characters to it?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question