Python
'''
Today we’re going to build a basic spreadsheet application like Google sheets or Excel but much simpler. Our spreadsheet, let’s call it OpenSheet, will only support cells which hold either integers or formulas that sum two cells.
You are tasked with writing a program that handles this functionality for OpenSheet. You can make any decisions you want regarding how this program is organized, but there must be some sort of setter/getter methods that can be called by the application for any given cell. All inputs will be strings.
For setting you can expect two inputs: the cell location and the cell value.
Example of how your setter could look
set_cell("C1", "45")
set_cell("B1", "10")
set_cell("A1", "=C1+B1")
For getting you will be provided one input that is the cell location.
Example of how your getter could look
set_cell("C1", "45")
set_cell("B1", "10")
set_cell("A1", "=C1+B1")
get_cell("A1") # should return 55 in this case
Assumptions
In memory storage
All cell location inputs will be well formed (no need to validate in code)
All cell value inputs will be well formed (no need to validate in code)
Cells value inputs are either a summation of two other cells or an int
Empty cells are treated as zero when accessed