We implemented a number of limitations to avoid a user accidentally clogging the system.
We will be reviewing these limits periodically. Please do let us know if the limitations are a major inconvenience for your uses of dashdash.
- Cell contents: 2k characters for formulas, 200kB for computed values and literals.
- Functions limits: any function can use up to 1M characters as intermediary sized of processing, as long as the result to be stored as the cell value doesn’t take more than the cell limit values.
- Web requests from
POST()can fetch up to 1000kB, as long as the result to be stored as the cell value doesn’t take more than the cell limit (200kB). This is useful if you’re parsing a large request.
- View size: limit of 20k rows and 104 columns.
Other Warnings and Limitations
- We update views only after all the dependents of a call have calculated. That means that if you asked your app to do something complex and slow, like a
REPEAT()that creates a
FILL()with multiple rows that have
GET(), then you will potentially have to wait many many seconds to see updated values.
- Avoid creating a
FILL()with many thousands of rows. They can and will slow down your application a lot, as we have to propagate that across our redundant cloud infrastructure.
REPEAT()responsibly. If you need several actions to repeat, first create one simple repeat like
=REPEAT(1,1)and then point other cells to that one, like
=IF(A1>0, <action>). This is much more efficient.
- Many APIs require you to identify yourself with some form of credentials or another. Currently, with
POST()you can access any service that has one of the following identification mechanisms: 1. Access without credentials. 2. Access by providing a token in the URL. 3. HTTP Basic Auth, as in the clearbit case. 4. Bearer token sent over HTTP headers. Similar to 3. We don’t currently support authorisation with OAuth or OAuth2 or any methods that require delegation. Because it is a multi-step process, its more complex to implement right. Stay tuned! You can learn about the methods already supported here.
- Be aware that dashdash currently supports Chrome as a web browser. So if you use other browsers like Safari or Mozilla, your interface might be a bit flawed.
- Also note that you will still miss some parts of the full spreadsheet experience. As an example, currently you cannot undo actions with Ctrl+Z or select cells out of a formula by using arrow keys. We will release this in time!