You can convert a formula string to the specified cell range using the formulaToRanges() method as shown in the code snippet shared below.
JavaScript |
Copy Code
|
---|---|
var spread = new GC.Spread.Sheets.Workbook(document.getElementById('ss'), { sheetCount: 1 }); // Creating cell range using formulaToRanges() method // Getting row/column indexes and rowCount/colCount of range in formula |