Quote parameters to HYPERLINK

[turbot] / turbot / sheets.py

diff --git a/turbot/sheets.py b/turbot/sheets.py
index fbe9e3d7839d2e52a64d43f471a444efa1869fe3..047f793b0c22c805615b215a5f803d81dec56e65 100644 (file)
--- a/turbot/sheets.py
+++ b/turbot/sheets.py
@@ -39,14 +39,18 @@ def sheets_create_for_puzzle(turb, puzzle):
     new_sheet = sheets_create(turb, puzzle['name'])
 
     # Insert some useful links into the sheet
+    url_link=''
     if 'url' in puzzle:
         url_text = "Original puzzle is at: {}".format(puzzle['url'])
+        url_link = puzzle['url']
     else:
         url_text = ''
 
+    channel_url_link = ''
     if 'channel_url' in puzzle:
         channel_url_text = "Discussion for this puzzle is at: {}".format(
             puzzle['channel_url'])
+        channel_url_link = puzzle['channel_url']
     else:
         channel_url_text = ''
 
@@ -57,7 +61,7 @@ def sheets_create_for_puzzle(turb, puzzle):
         insertDataOption='INSERT_ROWS',
         body={
             'range': 'A1:A2',
-            'values': [[url_text], [channel_url_text]]
+            'values': [['=HYPERLINK("'+url_link+'","'+url_text+'")'], ['=HYPERLINK("'+channel_url_link+'","'+channel_url_text+'")']]
         }).execute()
 
     # Copy some sheets from the Template spreadsheet