From dc43fb79c5f826d9f85a8078663c4047d7cb0622 Mon Sep 17 00:00:00 2001 From: justin melvin Date: Fri, 27 Nov 2020 16:18:10 -0800 Subject: [PATCH 1/1] Quote parameters to HYPERLINK --- turbot/sheets.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/turbot/sheets.py b/turbot/sheets.py index 0b2cb5e..047f793 100644 --- a/turbot/sheets.py +++ b/turbot/sheets.py @@ -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 -- 2.43.0