diff options
Diffstat (limited to 'addons/google_spreadsheet/google_spreadsheet.py')
| -rw-r--r-- | addons/google_spreadsheet/google_spreadsheet.py | 17 |
1 files changed, 9 insertions, 8 deletions
diff --git a/addons/google_spreadsheet/google_spreadsheet.py b/addons/google_spreadsheet/google_spreadsheet.py index a724e3c425e..81ec536b6f2 100644 --- a/addons/google_spreadsheet/google_spreadsheet.py +++ b/addons/google_spreadsheet/google_spreadsheet.py @@ -18,6 +18,7 @@ # ############################################################################## +import cgi import simplejson import logging from lxml import etree @@ -67,24 +68,24 @@ class config(osv.osv): request = '''<feed xmlns="http://www.w3.org/2005/Atom" xmlns:batch="http://schemas.google.com/gdata/batch" xmlns:gs="http://schemas.google.com/spreadsheets/2006"> - <id>https://spreadsheets.google.com/feeds/cells/%s/od6/private/full</id> + <id>https://spreadsheets.google.com/feeds/cells/{key}/od6/private/full</id> <entry> <batch:id>A1</batch:id> <batch:operation type="update"/> - <id>https://spreadsheets.google.com/feeds/cells/%s/od6/private/full/R1C1</id> + <id>https://spreadsheets.google.com/feeds/cells/{key}/od6/private/full/R1C1</id> <link rel="edit" type="application/atom+xml" - href="https://spreadsheets.google.com/feeds/cells/%s/od6/private/full/R1C1"/> - <gs:cell row="1" col="1" inputValue="%s"/> + href="https://spreadsheets.google.com/feeds/cells/{key}/od6/private/full/R1C1"/> + <gs:cell row="1" col="1" inputValue="{formula}"/> </entry> <entry> <batch:id>A2</batch:id> <batch:operation type="update"/> - <id>https://spreadsheets.google.com/feeds/cells/%s/od6/private/full/R60C15</id> + <id>https://spreadsheets.google.com/feeds/cells/{key}/od6/private/full/R60C15</id> <link rel="edit" type="application/atom+xml" - href="https://spreadsheets.google.com/feeds/cells/%s/od6/private/full/R60C15"/> - <gs:cell row="60" col="15" inputValue="%s"/> + href="https://spreadsheets.google.com/feeds/cells/{key}/od6/private/full/R60C15"/> + <gs:cell row="60" col="15" inputValue="{config}"/> </entry> -</feed>''' % (spreadsheet_key, spreadsheet_key, spreadsheet_key, formula.replace('"', '"'), spreadsheet_key, spreadsheet_key, config_formula.replace('"', '"')) +</feed>''' .format(key=spreadsheet_key, formula=cgi.escape(formula, quote=True), config=cgi.escape(config_formula, quote=True)) try: req = urllib2.Request( |