In webix spreadsheet, I can copy a formula in a cell with reference to other cells, and then I pasted the formula to a new cell, the system will change the cell reference automatically in the new cell. How can I do the same programmatically?
Hey @robertwong68, the way you could do this is by mimicking the current behaviour from within the inner logic of the widget. Basically, you have to write your own custom method to update the formulas.
Here is a working sample implementing a custom updateMath function: https://snippet.webix.com/kehovny3.