Design Raw and Computed Spreadsheet Views

Spreadsheet Cell Model with Raw and Computed Representations Hard · Object-Oriented Design, Graphs · Rippling · Hint: Replacing a formula can add and remove dependency edges; a cached number cannot reveal old dependencies. Design an in‑memory spreadsheet engine that exposes two separate views for every cell: the exact raw text the user typed, and the current evaluated numeric result. The raw content may be a literal number or a formula that begins with "=". When a cell is…