Back to problems

Design a Spreadsheet with Formula Evaluation

Algorithm · Ramp · Medium

Construct a miniature spreadsheet engine that operates on a grid with columns named A through Z and rows numbered 1 through 100. Every cell can hold either a plain number or a simple arithmetic formula referencing up to two other cells. Implement the class Spreadsheet: Spreadsheet() Creates the spreadsheet with every cell initialized to 0.0. void setCell(String cell, String value) Assigns a value to the given cell (for example, "A1" or "Z100"). value is either a non‑negative…

Checking your access…