Design Spreadsheet

Description

Build a Spreadsheet class representing a grid with 26 columns (\'A\' through \'Z\') and a configurable number of rows. Cells hold integers from 0 to 10⁵.

Implement:

- Spreadsheet(int rows): Creates the spreadsheet with all cells initialized to 0.

- void setCell(String cell, int value): Assigns a value to the cell identified by column letter and 1-indexed row (e.g., "A1", "B10").

- void resetCell(String cell): Sets the specified cell back to 0.

- int getValue(String formula): Evaluates a formula "=X+Y" where X and Y are cell references or non-negative integers, returning their sum.

Unset cells are treated as 0 when referenced by getValue.

Code

class Spreadsheet:

    def __init__(self, rows: int):
        

    def setCell(self, cell: str, value: int) -> None:
        

    def resetCell(self, cell: str) -> None:
        

    def getValue(self, formula: str) -> int:
        


# Your Spreadsheet object will be instantiated and called as such:
# obj = Spreadsheet(rows)
# obj.setCell(cell,value)
# obj.resetCell(cell)
# param_3 = obj.getValue(formula)