quip / quip-api

Quip Automation REST API for editing documents, folders, and users
Apache License 2.0
297 stars 164 forks source link

Creating a spreadsheet with spreadsheet functions #117

Open ejsarge opened 1 year ago

ejsarge commented 1 year ago

Is there something extra required to be able to create a spreadsheet that uses spreadsheet functions?

A partial repro of my code:

project_points = ''.join(map(lambda r: f'<td>=$C{row_index}</td>', project_range))
                sheet_content_list.append(f'<tr>{project_points}</tr>')
sprint_summary_sheet = client.new_document(content=''.join(sheet_content_list), title=sheet_title, member_ids=["<redacted>"], type='spreadsheet')

Expected results: A spreadsheet where the formulas are used.

Actual results:

ERROR in the spreedsheet until I press enter on the cell.

fclinton commented 10 months ago

+1