Posted 8 September 2017, 9:47 am EST
I am having a number of issues with the triggers for spread js, some of which I found in the forums as known issues with no status update for over a month.
Problem 1
When I have a cell with a formula in it and make a change to a cell, the cells which change as a result do not fire off the ValueChanged or CellChanged events. I know this has been reported previously here (and in a link referenced there as well)
http://wijmo.com/topic/formula-change-event/
but I have not seen an update and it still is an issue in the newest release.
Problem 2
Hitting the delete key while on a cell does not seem to fire any events. As per this link http://wijmo.com/topic/spreadjs-events/ I tried using the RangeChanged event but it does not fire this event either.
Problem 3
As a workaround for the above problem 2 I attempted to add a key map event to capture the pressing of the delete key and setting the value of the cell by calling setValue on the sheet. This even fires as expected, but the setValue method also does not seem to fire off any of the events including CellChanged, RangeChanged or ValueChanged.
I have included the important parts of the code below, as you can see i have tried all three event types and none of them appear to fire off as I would expect
[js]
var _bindEvents = function(sheet) {
// sheet.bind($.wijmo.wijspread.Events.CellChanged, function (event, cellInfo) {
sheet.bind($.wijmo.wijspread.Events.RangeChanged, function(event, cellInfo) {
// sheet.bind($.wijmo.wijspread.Events.ValueChanged, function(event, cellInfo) {
console.info(‘range changed’);
console.info(cellInfo);
self.updateValueIfFound(cellInfo);
});
sheet.addKeyMap($.wijmo.wijspread.Key.del, false, false, false, function () {
console.info(‘delete hit’);
var sh = self.spreadsheet().getActiveSheet();
sh.setValue(sheet.getActiveRowIndex(), sheet.getActiveColumnIndex(), ‘’);
});
};
self.bindEvents = function () { $.each(self.spreadsheet().sheets, function (index, sh) { _bindEvents(sh); }); };
[/js]
Any updates and/or work around options would be helpful. Thanks.
