by Ernie » Tue Nov 16, 2010 6:10 pm
I just had a user mention the same thing with iWorks for iPad. Goooge Docs had this problem, and later "fixed" it (I call it a "fix" because it now works with my upload process). Since it doesn't seem to support putting quotes around these new lines in your cells, you'll need a workaround. I suggest creating a formula to convert these new lines into my special new-line character, then upload these new columns. For example, if you use columns A/B for your list, put the formulas in columns D/E and upload columns D/E (with the reformated text). The formula for cell D1 is:
=SUBSTITUTE(A1,CHAR(10),"|")
Semi-colons won't mess up anything, but a single double quote on a side will. If you use double-quotes, just make sure you pair them up (have a closing double-quote).
Let me know if this doesn't help.
I just had a user mention the same thing with iWorks for iPad. Goooge Docs had this problem, and later "fixed" it (I call it a "fix" because it now works with my upload process). Since it doesn't seem to support putting quotes around these new lines in your cells, you'll need a workaround. I suggest creating a formula to convert these new lines into my special new-line character, then upload these new columns. For example, if you use columns A/B for your list, put the formulas in columns D/E and upload columns D/E (with the reformated text). The formula for cell D1 is:
=SUBSTITUTE(A1,CHAR(10),"|")
Semi-colons won't mess up anything, but a single double quote on a side will. If you use double-quotes, just make sure you pair them up (have a closing double-quote).
Let me know if this doesn't help.