]> git.cworth.org Git - turbot/commitdiff
Quote parameters to HYPERLINK
authorjustin melvin <jmelvinprime@gmail.com>
Sat, 28 Nov 2020 00:18:10 +0000 (16:18 -0800)
committerjustin melvin <jmelvinprime@gmail.com>
Sat, 28 Nov 2020 00:18:10 +0000 (16:18 -0800)
turbot/sheets.py

index 0b2cb5ed38d41e52d9c07b417d753c5ae725dc7e..047f793b0c22c805615b215a5f803d81dec56e65 100644 (file)
@@ -61,7 +61,7 @@ def sheets_create_for_puzzle(turb, puzzle):
         insertDataOption='INSERT_ROWS',
         body={
             'range': 'A1:A2',
-            'values': [['=HYPERLINK('+url_link+','+url_text+')'], ['=HYPERLINK('+channel_url_link+','+channel_url_text+')']]
+            'values': [['=HYPERLINK("'+url_link+'","'+url_text+'")'], ['=HYPERLINK("'+channel_url_link+'","'+channel_url_text+'")']]
         }).execute()
 
     # Copy some sheets from the Template spreadsheet