Intersoft Community - WebGrid Enterprise - Efficient way to use Best Fit on all coulmns

Efficient way to use Best Fit on all coulmns

sjain — Mon, 01 Aug 2016 08:21:10 GMT

Hi Yudi,
Any update regarding request would be helpful !

regards
Sachin

Efficient way to use Best Fit on all coulmns

sjain — Tue, 05 Jul 2016 14:15:24 GMT

Hi Yudi,
             Thanks for reply. Unfortunately suggested solution does not fit in requirement. Client is OK with horizontal scroll bar because column position they can change with combination of hiding some columns. User requirement is to see cell data (not only header) full without new line. Since, cell data for desired pages are too much long so they wish to read it with some more column data.
   We found that "Best Fit" for column worked in this requirement. Our problem is that data is dynamic so columns name could not be hardcoded by javascript.
        We tried to apply "Best Fit" on every column by javascript after document.ready but it made page slow. Hope, you can suggest some workaround.
regards
Sachin

Efficient way to use Best Fit on all coulmns

yudi — Mon, 27 Jun 2016 08:01:23 GMT

You might want to try the multi-line column header approach. Please set following properties:

WebGrid > LayoutSettings > HeaderWrapDefault="True"
WebGrid > LayoutSettings > RowHeightDefault="-1px"

By doing so, you can have multi-line column header such as shown in the following:

Please let me know if this suits your scenario.
Note: simple sample is enclosed as attachment.

Efficient way to use Best Fit on all coulmns

sjain — Wed, 22 Jun 2016 14:27:21 GMT

Hi,

Some of our webgrid pages have large number of columns say more than 25. To show columns properly we made AutoFitColumns="false" ; so horizontal scroll bar appear and columns headers are readable now. Still for columns having large text say more than 35 charcters; text were not readable without resizing the column. Most of columns of such grids require resize.

We tried to use webgrid's inbuilt functionality "Best Fit" for all columns. We do it by below function which is based upon http://developer.intersoftsolutions.com/display/WebUI/Set+the+Column's+Best+Fit

$(document).ready(function () {
var grid = ISGetObject('WebGrid1');
for (i = 0; i < grid.RootTable.Columns.length; i++) {
(grid.RootTable.Columns.GetNamedItem(grid.RootTable.Columns[i].Name)).ResizeBestFit();
}
});

It makes those page 3-4 times slower and reason behind it that it is done after document is ready.

Is it any efficient way exist which can help us to meet the goal without making page slower?

thanks and regards

Sachin