create a function that will increment the excel sheet reference using JavaScript.
I have the string values that contains the excel sheet formulas and i need to increment these reference using JavaScript. Here is an example of what i am trying to achieve
Example 1
const str1 = "$A$1+1"
and the result will be
["$A$1+1", "$A$2+1", "$A$3+1", "$A$3+1"]
example 2
const str2 = "$A$10+$B$9"
result
["$A$10+$B$9", "$A$11+$B$10", "$A$12+$B$11", "$A$13+$B$12"]