1import java.util.HashMap;
2import java.util.Map;
3
4class Spreadsheet {
5    // Map to store cell values where key is the cell identifier like "A1", and value is the integer stored in that cell.
6    private Map<String, Integer> cellMap = new HashMap<>();
7
8    // Constructor to initialize the Spreadsheet with a given number of rows.
9    // 'rows' parameter is not used as there is no direct implementation of row-specific logic.
10    public Spreadsheet(int rows) {
11    }
12
13    // Method to set a value for a specific cell in the spreadsheet.
14    public void setCell(String cell, int value) {
15        cellMap.put(cell, value); // Add or update the cell with the given integer value.
16    }
17
18    // Method to reset a cell, essentially removing its stored value.
19    public void resetCell(String cell) {
20        cellMap.remove(cell); // Remove the cell from the map.
21    }
22
23    // Method to get the result by evaluating a formula.
24    // The formula is expected to be in the format "=A1+B2+12", which requires adding numbers and/or cell values.
25    public int getValue(String formula) {
26        int result = 0;
27
28        // Split the formula by '+' and evaluate each part.
29        for (String cell : formula.substring(1).split("\\+")) {
30            // Check if the part is a direct number or a reference to a cell.
31            if (Character.isDigit(cell.charAt(0))) {
32                result += Integer.parseInt(cell); // Convert number to an integer and add to result.
33            } else {
34                result += cellMap.getOrDefault(cell, 0); // Add the value of the referenced cell or 0 if it doesn't exist.
35            }
36        }
37
38        return result; // Return the computed result.
39    }
40}
41
42/**
43 * Example usage of the Spreadsheet class:
44 * 
45 * Spreadsheet obj = new Spreadsheet(rows);
46 * obj.setCell("A1", 5);
47 * obj.resetCell("A1");
48 * int sum = obj.getValue("=A1+5+B2");
49 */
50

1#include <unordered_map>
2#include <string>
3#include <sstream>
4#include <cctype>
5
6class Spreadsheet {
7private:
8    // Map to hold cell values. Keys are cell identifiers (e.g., "A1"), values are integers.
9    std::unordered_map<std::string, int> cellData;
10
11public:
12    // Constructor to initialize Spreadsheet with a given number of rows.
13    // Currently, it doesn't utilize the 'rows' parameter.
14    Spreadsheet(int rows) {}
15
16    // Method to set the value of a specific cell.
17    void setCell(std::string cell, int value) {
18        cellData[cell] = value;
19    }
20
21    // Method to reset the value of a specific cell, effectively removing it from the map.
22    void resetCell(std::string cell) {
23        cellData.erase(cell);
24    }
25
26    // Method to compute the result of a formula.
27    // The formula is expected to be prefixed with "=" and may contain references to cells or direct integer values.
28    int getValue(std::string formula) {
29        int result = 0; // Initialize result to accumulate values.
30        std::stringstream ss(formula.substr(1)); // Remove the '=' prefix from the formula.
31        std::string cell;
32
33        // Parse the formula and process each part separated by '+'.
34        while (getline(ss, cell, '+')) {
35            if (std::isdigit(cell[0])) {
36                // If the part is a number, convert and add it to the result.
37                result += std::stoi(cell);
38            } else {
39                // If the part is a cell reference, fetch the value if it exists.
40                result += cellData.count(cell) ? cellData[cell] : 0;
41            }
42        }
43        return result; // Return the computed result.
44    }
45};
46
47/**
48 * Your Spreadsheet object will be instantiated and called as such:
49 * Spreadsheet* obj = new Spreadsheet(rows);
50 * obj->setCell(cell, value);
51 * obj->resetCell(cell);
52 * int param_3 = obj->getValue(formula);
53 */
54

1// A Map to store cell names as keys and their respective values as numbers.
2const spreadsheetData: Map<string, number> = new Map<string, number>();
3
4/**
5 * Sets the value of a specific cell.
6 * @param cell - The cell identifier, a string.
7 * @param value - The value to set in the cell, a number.
8 */
9function setCell(cell: string, value: number): void {
10    spreadsheetData.set(cell, value);
11}
12
13/**
14 * Resets (deletes) a specific cell from the spreadsheet.
15 * @param cell - The cell identifier to delete, a string.
16 */
17function resetCell(cell: string): void {
18    spreadsheetData.delete(cell);
19}
20
21/**
22 * Calculates the value of a formula.
23 * @param formula - A formula string which usually starts with '=' and includes cell names and numbers to add.
24 * @returns The computed value based on the formula.
25 */
26function getValue(formula: string): number {
27    let total = 0;
28    // Remove the '=' sign and split the formula by the '+' operator to get each term.
29    const cells = formula.slice(1).split('+');
30  
31    // Iterate over each cell or value in the formula and compute the total.
32    for (const cell of cells) {
33        // Check if the cell is a number or a reference to another cell.
34        total += isNaN(Number(cell)) ? spreadsheetData.get(cell) || 0 : Number(cell);
35    }
36  
37    return total;
38}
39
40/**
41 * Example of usage:
42 * setCell('A1', 5);
43 * setCell('A2', 10);
44 * const result = getValue('=A1+A2+3'); // result will be 18
45 * resetCell('A1');
46 */
47