I have a couple of Google Spreadsheets I use to generate config files for things. The config file data ends up in a single cell, which is copied and pasted.
Problem is Google Sheets has this odd behavior where "
marks get doubled into ""
if there's a \n line break character, if it's a formula cell. If it's values, you can copy them right out of the cell editor without trouble.
for example a cell containing:
"foo"
"woo"
copies our of the cell editor as
"foo"
"woo"
but if a formula cell say ="""foo"""char(10)"""woo""" copies as
""foo""
""woo""
And if you try to copy it by editor, you get the formula. How to fix this?