I needed a simple no-frills spreadsheet-like page for a client project.
So I built the following and decided to publish it so that others can use it as they want.
You must open it in Coda to see it properly.
Each ‘cell’ is a formula, labeled
A 1 thru
I 20 (sorry but coda puts a space between the letter and the number).
Thus, when you click on a cell, you edit the formula. Move up one line to the
0 and replace it.
You then replace it with a number or an entire formula. The formula can refer to other Tables & Columns in the same doc.
In the formula you refer to other cells using the
A 1 …
I 20 labels.
I could only fit 9 columns across with a 9-digit result. But you can change that.
N at the bottom of the page defines the width of all the cells.
And you can add more rows if you need them by copy/pasting the last row.
Each cell uses the
LeftPad() and the
Left() functions to keep a constant cell width for all results.