Tips & tricks
Cross-sheet cell reference
Section titled “Cross-sheet cell reference”To show sheet1!A1 inside sheet2 cell B3:
- Go to
B3onsheet2. - Enter:
="sheet1"!A1
Conditional background color (workaround)
Section titled “Conditional background color (workaround)”EtherCalc has no built-in conditional-formatting panel. You can fake fill colors with an HTML formula:
- Select the target cell (e.g.
B2). - Format → Text → HTML.
- Enter:
=if(A1="foo","<span style=""background-color:rgb(81,184,72);color:rgb(81,184,72)"">_______</span>","<span style=""background-color:rgb(226,86,43);color:rgb(226,86,43)"">_______</span>")The IF picks green or red underscore runs; matching pen and background colors make the cell look filled.
Export
Section titled “Export”Append a format extension to the room URL:
| Format | URL |
|---|---|
| CSV | https://calc.example.org/foo.csv or /_/:room/csv |
| XLSX | https://calc.example.org/foo.xlsx |
| HTML | https://calc.example.org/foo.html |
| ODS | /_/:room/ods |
Multi-sheet workbooks use the /=:room prefix — see API.md.
Read-only links
Section titled “Read-only links”When ETHERCALC_KEY is set, append ?auth=0 for view-only access. With a key configured, edit links carry an HMAC: ?auth=<hmac>.
Self-host path prefix
Section titled “Self-host path prefix”Running behind a subpath? Set ETHERCALC_BASEPATH (Docker) or BASEPATH (Worker). See Self-hosting.