I am evaluating the Webix datatable/pivot; it will save a lot of development to use your off-the-shelf product but we’re not sure if it supports our needs.
We need to be able to lazy-load rows and columns as the scroller moves. Is this possible? We had a go by trying to implement event handlers for scrollX and scrollY but the argument is undefined to get the position details.
Datatable support lazy loading
http://docs.webix.com/desktop__plain_dynamic_loading.html
http://docs.webix.com/datatable__loading_data.html#loadingbigdatasetsdynamic
In case of Pivot, situation is a bit more complicated, to render Pivot we need to have all data on client side first, so all data must be loaded at once.
In both cases ( Datatable and Pivot ) only visible rows will be rendered. So even if you have 5000 rows, only visible rows ( 20-50 ) will be rendered at once.