I have an app that exports text to a spreadsheet, let the user edit it and
import it back. If a cell contains text that starts with a plus sign, the
cell turns into a formula in the spreadsheet with an equals sign prepended
to the text.
For example, the text "+5%" becomes "=+5%" in the spreadsheet. Similarly,
"+{0}" turns into a formula and appears only as "0". When importing back,
the equals sign is naturally still there.
This makes it impossible to show the text correctly and import it back
correctly. I can't prepend a single quote to the text as it's not
reasonable to expect the user to remember putting a single quote when
adding new text. Is there another way to prevent cells from turning into
formulas?
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
