Insert newline into a spreadsheet cell via python api

[Justin Onstine]

Hi. I am trying to write a string with one or more carriage returns (newline, linefeed, \n, whatever) into a spreadsheet using the python UpdateCell() function and in the spreadsheet it is being rendered as a space. I've done some fairly extensive searching around the web and tried simply using a '\n' or a '\r' or both in my string to no avail. Is there a way to do this programatically?

Thank you,
Justin

[Vic Fryzel]

Hey Justin,

Try the 
 XML entity instead of a \r\n.  Here's some example XML that I just tested that works:

<entry  xmlns="http://www.w3.org/2005/Atom" xmlns:gs="http://schemas.google.com/spreadsheets/2006" xmlns:batch="http://schemas.google.com/gdata/batch" xmlns:gd="http://schemas.google.com/g/2005" gd:etag="&quot;YGgDTlERSyt7Ig..&quot;">

<gs:cell row="1" col="1" inputValue="asdf&#10;

asdf&#10;

asdf"></gs:cell>

</entry>

Thanks,

-Vic

[Justin Onstine]

I'm sorry, I'm not very good at the xml thing and wouldn't know how to make that kind of call from within python. Maybe this is more a case of a not so bright programmer. :/

Using &#10; in my UpdateCell call just causes the string literal to be put in the cell.

Thanks for your help,
Justin

[Justin Onstine]

[Vic Fryzel]

Oh, sorry, it's because &#10; is being replaced by &amp;&#10;.  I'm actually not quite sure how to resolve this in the current gdata-python-client without a lot of tricks...  Let me ask some colleagues and get back to you.

-Vic

[Vic Fryzel]

After a bunch of discussion, we've decided not to fix this in gdata-python-client because of the ramifications it would have for numerous existing clients.

We will fix this problem in a future version of the API.  I'm really sorry about this :(

-Vic

[Justin Onstine]

I totally understand, thanks for giving it your attention!

[Vic Fryzel]

Thank you very much for understanding!

-Vic