web functions
fetch and parse data from outside the sheet.
| function | signature | what it does | tests |
|---|---|---|---|
| DECODEURL | DECODEURL(text) | decodes URL-encoded text | 1 |
| ENCODEURL | ENCODEURL(text) | encodes text for use in URLs using percent encoding | 2 |
| FILTERXML | FILTERXML(xml, xpath) | selects values from an xml STRING with an xpath | — |
| IMPORTRANGE | IMPORTRANGE(workbook, range_string) | imports a range from another deepcalc workbook, addressed as {namespace}/{name} — e.g. worldbank/gdp. Resolution is journaled, never live-silent: refreshing the workbook's Sources materializes the target values as ordinary ops, so every upstream change arrives as a reviewable diff. Each source can track the latest version or be pinned to a specific one (the Sources panel). Before the first refresh the cell shows #NAME?. The inline form ={ns}/{name}!worksheet!A1:B10 is equivalent. | — |
| QUERY | QUERY(data, query, [headers]) | runs SQL-like query on data range | 1 |