Getting value of cell w/in onCellSave(args)

[Jacob Knight]

I have code where I use ranges to calculate min/median/max values in another table and also a total in another table w/in the spreadsheet:
i.e. this.XLEdit.updateCellValue({ rowIndex: rowIndexNum, colIndex: colIndexNum }, "=MIN(" + rangeToCalc + ")");
Above & similar lines actually trigger onCellSave(args) so I was passing args.value to local storage if it is an integer since all the calcs. aside from what I enter that run onCellSave(args) end up looking like "E6:F6" for example.
I then go to read the value in that cell like: var value = this.getAlphaRange(rowIndexNum, colIndexNum).value; but it keeps returning as undefined so I'm guessing I can't grab that value while still in onCellSave(args) until after the page loads? Is this accurate? If so do you have any suggestions for how to get those values of cells after inputting.

The scenario is we set min, max, median and then if the inputted number is > or < the value in a specific cell (which gets updated on each entry so it has to be in onCellSave(args) then the cell that was just entered will update it's color based on being less than, between two values, or greater than. Like:                     xlFormat.format({ "style": { "background-color": "#99c199", "text-align": "center" } }, this.getAlphaRange(args.rowIndex, args.colIndex));

[Shanmugaraja K]

Hi Jacob, 

 

Thanks for using Syncfusion products, 

 

We have checked your requirement, and we suggest you to pass the range to getRangeData method to get the corresponding values. Please refer the below code example, 

 

[JS] 

 

 

        $(function () { 

            $("#Spreadsheet").ejSpreadsheet({ 

                cellSave: "onCellSave" 

            }); 

        }); 

 

        function onCellSave(args) { 

            var val = args.value, rng; // e.g. val is =MIN(B2:B6) 

            if (val && val.startsWith("=")) { 

                rng = val.slice(val.indexOf("(") + 1, val.indexOf(")")); // rng is B2:B6. 

                data = this.getRangeData({ range: rng, property: "value" }); // you can get the data here. 

                console.log(data); 

            } 

        }; 

 

 

We have demonstrated the sample in JSPlayground, please refer the below sample link and documentation link, 

 

Sample: http://jsplayground.syncfusion.com/lfmvu2ri  

Documentation:  https://help.syncfusion.com/api/js/ejspreadsheet#methods:getrangedata  

 

Regards, 

Shanmugaraja K