Empty rows and extra scrolling issues

[vsundaralingamMember]

I have a jqxgrid with page size options 50, 100 & 500 and default page size is set to 50. When number of rows in the grid is < 50 say 24 then the grid shows the scrollbar to scroll for 50 records and also it shows around 10 empty rows after 24 records.

Here is the code:
$("#Store-Table-Container").jqxGrid({
width: '99%',
height: '100%',
source: dataAdapter,
sortable: false,
pagesizeoptions: ['50', '100', '500'],
pagesize: 50,
pageable: true,
columns: [
{ text: 'Store Num', datafield: 'StoreNum', width: 80 },
{ text: 'Store', datafield: 'Store', width: 200 },
{ text: 'Address', datafield: 'Address', width: 200 },
{ text: 'City', datafield: 'City', width: 120 },
{ text: 'State', datafield: 'State', width: 42 },
{ text: 'Zip', datafield: 'ZipCode', width: 60 },
{ text: '$ Sales LY', datafield: 'DollarSalesLY', width: 100, cellsformat: 'c' },
{ text: '$ Sales TY', datafield: 'DollarSalesTY', width: 100, cellsformat: 'c' },
{ text: 'Unit Sales LY', datafield: 'UnitSalesLY', width: 100, cellsformat: 'n' },
{ text: 'Unit Sales TY', datafield: 'UnitSalesTY', width: 100, cellsformat: 'n' }
]
});

[Peter StoevKeymaster]

Hi vsundaralingam,

The behavior that you describe is by design. Setting the page size to 50 means that there are 50 rows available for scrolling which could be empty or with data. If you set the Grid’s autoheight property to true and don’t set its height to ‘100%’, then the Grid’s height will depend only on the number of displayed rows and its size will be changed automatically depending on the visible rows in the current view.

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts