search

jspreadsheet / ce

Jspreadsheet is a lightweight vanilla javascript plugin to create amazing web-based interactive tables and spreadsheets compatible with other spreadsheet software.
https://bossanova.uk/jspreadsheet/v4
MIT License
6.66k stars 818 forks source link

Set Page Total dynamically #1673

Closed jmcintyr150 closed 2 months ago

jmcintyr150 commented 4 months ago

I need paging without loading all the data (1 Mil plus records). I want to set the number of pages manually, then when the user clicks next page, I can use the onchangepage event to get the next batch of records.

hodeware commented 2 months ago

The logic behind this is set spreadsheet with minDimensions to define the total of rows, them use onchange to trigger the updates of the rows in page. The only problem CE cannot support 1M rows. In that case PRO v11 can handle that.

See this example with 1 Billion cells https://jspreadsheet.com/demo