Batch operations

Combine many changes into one operation that recalculates once at the end, by callback or by suspending and resuming evaluation.

Read the docs

3 stepsWatch it once, then it is yours: click into the grid at any point to take over.

Run the thousand edits both ways and compare the times; run them again to measure again.

Skip past the grid

Skip back before the grid

Engine

1const at = (row) => ({ sheet: 0, col: 0, row });
2
3// One by one: 1,000 recalculations
4for (const [row, units] of edits)
5  hf.setCellContents(at(row), units);
6// Not run yet
7
8// In a batch: one recalculation, at the end
9hf.batch(() => {
10  for (const [row, units] of edits)
11    hf.setCellContents(at(row), units);
12});
13// Not run yet

Run the edits, and each way is timed here, in your browser.

Each run changes all 1,000 lines.

Make every data point count. Turn millions of them into actionable wisdom.

Let’s make it easier.
Smoother. Faster. All Handsontable.