René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"Code","url":"https://leetcodejavascript.com/solutions/design-spreadsheet","name":"#3484 - Design Spreadsheet - LeetCode JavaScript Solutions","description":"A spreadsheet is a grid with 26 columns (labeled from 'A' to 'Z') and a given number of rows. Each cell in the spreadshe...","programmingLanguage":"JavaScript","codeRepository":"https://github.com/JoshCrozier/leetcode-javascript","codeSampleType":"JavaScript","text":"/**\n * @param {number} rows\n */\nvar Spreadsheet = function(rows) {\n this.cellValues = new Map();\n this.totalRows = rows;\n};\n\n/**\n * @param {string} cell\n * @param {number} value\n * @return {void}\n */\nSpreadsheet.prototype.setCell = function(cell, value) {\n this.cellValues.set(cell, value);\n};\n\n/**\n * @param {string} cell\n * @return {void}\n */\nSpreadsheet.prototype.resetCell = function(cell) {\n this.cellValues.delete(cell);\n};\n\n/**\n * @param {string} formula\n * @return {number}\n */\nSpreadsheet.prototype.getValue = function(formula) {\n const expression = formula.slice(1);\n const operands = expression.split('+');\n\n const leftValue = this.parseOperand(operands[0]);\n const rightValue = this.parseOperand(operands[1]);\n\n return leftValue + rightValue;\n};\n\n/**\n * @param {string} operand\n * @return {number}\n */\nSpreadsheet.prototype.parseOperand = function(operand) {\n if (/^\\d+$/.test(operand)) {\n return parseInt(operand);\n }\n return this.cellValues.get(operand) || 0;\n};","keywords":"LeetCode 3484, #3484 - Design Spreadsheet, Medium, JavaScript solution","learningResourceType":"Code","isAccessibleForFree":true,"educationalLevel":"intermediate","interactivityType":"mixed"}