Object-Oriented Programming · Amazon · Hard
Build a simple spreadsheet whose grid spans the cells A1 up to Z100. It must offer three operations: set(cell, value): overwrite whatever cell currently holds with the integer constant value. sum(cell, references): make cell hold a summation formula. Each entry of references is either one cell (for example A1) or a rectangular block written as two corners (for example A1:B3). Every cell covered by a block is added in, and if the same cell is referenced more than once, it is…