Slick grid column summation data not getting refresh while scroll

Question

Slick grid column summation data not getting refresh while scroll

Nikhil Badhe 1

Hi
I am using Slick.grid. Issue when i update column(A) and scroll page to check other column(F) value which is calculating using column A, Column F Summation value not getting changed. (We have written logic if value change in Column(A) using formula other column(F) value will be changed) When i refresh page value updated.

Thank You.

Amos Wu-MSFT 4,051 Reputation points

2020-12-04T01:33:28.477+00:00

Hi @Nikhil Badhe ,
What do you mean Slick grid column? If you are using a third-party plug-in, please share the full code and other details to help us reproduce your issue. Thank you.
Amos Wu-MSFT 4,051 Reputation points

2020-12-08T03:16:46.893+00:00

Hi @Nikhil Badhe ,
We need more information to reproduce your issue, please share with us.
Nikhil Badhe 1 Reputation point

2020-12-08T11:44:26.92+00:00

Those columns are visible for those column summation data showing Correct.
But while scrolling right side column data is not getting refresh while updating cell.
Below Code used to refresh Grid.
function invalidate() {
updateRowCount();
invalidateAllRows();
render();
}
function invalidateAllRows() {
if (currentEditor) {
makeActiveCellNormal();
}
for (var row in rowsCache) {
removeRowFromCache(row);}
}
function render() {
if (!initialized) { return; }
var visible = getVisibleRange();
var rendered = getRenderedRange();
cleanupRows(rendered);
if (lastRenderedScrollLeft != scrollLeft) {
cleanUpAndRenderCells(rendered);
}
renderRows(rendered);
postProcessFromRow = visible.top;
postProcessToRow = Math.min(getDataLengthIncludingAddNew() - 1, visible.bottom);
startPostProcessing();
lastRenderedScrollTop = scrollTop;
lastRenderedScrollLeft = scrollLeft;
h_render = null;
}
Amos Wu-MSFT 4,051 Reputation points

2020-12-09T07:43:12.383+00:00

If possible, please share the full code. You can upload the code as an attachment. If there is private information in the code, please delete it or use another word to replace it.
Amos Wu-MSFT 4,051 Reputation points

2020-12-16T07:48:13.343+00:00

The code you shared is not enough for us to reproduce your problem. If possible, please share the full code.