Spreadsheet cell (source code)

= Spreadsheet cell

An addressed entry of a <spreadsheet>, such as `A1`. Here it stores either a literal numerical <input> or a <spreadsheet formula>; its current value is distinct from the stored formula. A <cached cell value> records a previously computed value, not an instruction to compute it again.

In a <spreadsheet tabular model>, `D2` can store `=C2*(1+$F$1)` while displaying `9`. The <spreadsheet cell reference> `D2` identifies the location, the <spreadsheet formula> describes the calculation, and `9` is the value obtained from the present <inputs>. Keeping those three ideas distinct makes copying and checking a model much easier.