Even i am searching for the answer for the above question, Please somebody, if they know the solution , share it.
Thanks in advance.
It's really shocking to see that nobody has replied for a very important question that was posted way back in MARCH.
I'd answer if I could, but I can't.
These forums are "peer support". In reality, that means Infragistics staff may or may not respond to your post. The fact that nobody has replied usually indicates that the rest of us are equally clueless. (At least I am; I'm following your post because I'm interested, but ...)
If you need "official" support, they have a page where you can create a user support "incident", free of charge, at: http://devcenter.infragistics.com/Protected/SubmitSupportIssue.aspx
For best results, attach a working example of your problem, based on the Northwind database. That will usually get you a reply within a week.
The reply sometimes is "We have determined that this is a bug and we have reported it to the development team." In which case, the next hotfix may or may not include a fix to your problem.
The following function could be used to autosize all cells in all columns for the UltraWebGrid. The oerall Column width will auto set itself to the most characters, whether its a Column Header or a Cell
function InitWidth(gridName) { // Retrieve the grid based on its ID. var oGrid = igtbl_getGridById(gridName);
// Get the Bands collection var oBands = oGrid.Bands;
// Get the columns collection for Band 0 var oBand = oBands[0]; var oColumns = oBand.Columns;
// The column count is equal to the length of the Columns array. var count = oColumns.length; // Create Column Array. var colArray = new Array(); // Set each Column Header width. for (var i = 0; i < count; i++) { colArray[i] = document.getElementById(oColumns[i].Id).firstChild.offsetWidth; }
var oRows = oGrid.Rows; var index = oColumns.Index;
// Loop thru each row in the grid to set the column to the largest cell width. for (var i = 0; i < oRows.length; i++) { for (var n = 0; n < count; n++) { var cell = oRows.getRow(i).getCell(n); if (colArray[n] < cell.Element.firstChild.offsetWidth) { colArray[n] = cell.Element.firstChild.offsetWidth; } } }
// Loop thru each Column in the grid to set the Column width to the largest width. for (var i = 0; i < count; i++) { oColumns[i].setWidth(colArray[i] + 5); }}
You can call this function in:
InitWidth(gridName);
}
thanks for the post.. it helped me when there is no group by selection
// Column Size Arrayvar colArray;function InitWidth(gridName) { // Retrieve the grid based on its ID. var oGrid = igtbl_getGridById(gridName);
// The column count is equal to the // length of the Columns array. var count = oColumns.length;
// Initialise Column Size Array on the first call. if (colArray == null) { colArray = new Array(); for (var i = 0; i < count; i++) { colArray[i] = 0; } }
// Set each Column Header width. var oColHeaders; for (var i = 0; i < count; i++) { // Don't check columns that aren't displayed if (!oColumns[i].ServerOnly && !oColumns[i].Hidden) { // This loop is needed since each Column Header // have the same Id in every group. We need to // check them all because only opened groups will // have a value in "offsetWidth". oColHeaders = oGrid.MainGrid.getElementsByTagName('th'); for (var j = 0; j < oColHeaders.length; j++) { if (oColHeaders[j].getAttribute('id') == oColumns[i].Id) { var colWidth = oColHeaders[j].firstChild.offsetWidth; if (colArray[i] < colWidth) { colArray[i] = colWidth; } if (colWidth > 0) { // We found a displayed header, no need to check them all. break; } } } } }
// Get the width from the data rows ParseNonGroupingRows(oGrid.Rows, oColumns, colArray);
//if grid widths > colArray's count ChangeColumnsWidthToFix(oColumns,oGrid.MainGrid.clientWidth-50,colArray); /* var colWidthCount=0; var enableColumns=0; var avgWidth=5; var maxWidth=200; for (var i = 0; i < count; i++) { // Don't check columns that aren't displayed if (!oColumns[i].ServerOnly && !oColumns[i].Hidden) { colWidthCount+=colArray[i];enableColumns++; } } if(colWidthCount<oGrid.MainGrid.clientWidth) { avgWidth=Math.round((oGrid.MainGrid.clientWidth- colWidthCount)/enableColumns); } // Loop through each Column in the grid to set // the Column width to the largest width found. for (var i = 0; i < count; i++) { // Don't set the width for columns that weren't available if (colArray[i] > 0) { // Note: the 10 pixels padding here might need to be // adjusted depending on the layout and styles of the grid. oColumns[i].((colWidthArry[i]+avgWidth)>maxWidth?maxWidth:(colWidthArry[i]+avgWidth)); } } }*/
function ChangeColumnsWidthToFix(colList,gridWidth,colWidthArry){ //debugger; var enableColumns=0; var avgWidth=5; var maxWidth=200; var colWidthCount=0; var gerColWidthCount=0; var lstWidth=""; for (var i = 0; i < colList.length; i++) { // Don't check columns that aren't displayed if (!colList[i].ServerOnly && !colList[i].Hidden) { enableColumns++; colWidthCount+=colArray[i]; if(colArray[i]>maxWidth) lstWidth+=(lstWidth==""?i:","+i); else gerColWidthCount+=colArray[i]; } } if(colWidthCount<gridWidth) { avgWidth=Math.round((gridWidth- colWidthCount)/enableColumns); } else { if(lstWidth!="") { var strA=lstWidth.split(','); var w=gridWidth-gerColWidthCount; if(w<0 || (colWidthCount-gerColWidthCount-strA.length*maxWidth)<0) { for(var e=0;e<strA.length;e++) colWidthArry[parseInt(strA[e])]=maxWidth; } else { var nw=Math.round(w/strA.length); for(var e=0;e<strA.length;e++) colWidthArry[parseInt(strA[e])]=nw; } } } // Loop through each Column in the grid to set // the Column width to the largest width found. for (var i = 0; i < colList.length; i++) { // Don't set the width for columns that weren't available if (colWidthArry[i] > 0) { // Note: the 10 pixels padding here might need to be // adjusted depending on the layout and styles of the grid. colList[i].setWidth(colWidthArry[i]+avgWidth); } } }
// This function go through each level of grouping rows // in order to get to the data rowsfunction ParseNonGroupingRows(rowList, colList, colWidthArray) { if (rowList.getRow(0).GroupByRow) { // Check if the first row is a GroupBy row for (var i = 0; i < rowList.length; i++) { // If so, call the function recursively for each // GroupBy row in the list, passing out it's // (child) Rows collection to the function. ParseNonGroupingRows(rowList.getRow(i).Rows, colList, colWidthArray); } } else { // The first row is a data row, parse all the rows // in the collection to get their cells width. GetRowsCellWidth(rowList, colList, colWidthArray); }}
// This function do the actual job of getting the columns // width from each cellfunction GetRowsCellWidth(rowList, colList, colWidthArray) { for (var i = 0; i < rowList.length; i++) { for (var n = 0; n < colList.length; n++) { // Don't check columns that aren't displayed if (!colList[n].ServerOnly && !colList[n].Hidden) { var cell = rowList.getRow(i).getCell(n); if (colWidthArray[n] < cell.Element.firstChild.offsetWidth) { colWidthArray[n] = cell.Element.firstChild.offsetWidth; } } } }}
// Call the function in the grid's eventsfunction InitializeLayout(gridName){ InitWidth(gridName);}
function AfterRowExpanded(gridName){ InitWidth(gridName);}
//if grid widths > colArray's count , var colWidthCount=0; var enableColumns=0; var avgWidth=5; for (var i = 0; i < count; i++) { // Don't check columns that aren't displayed if (!oColumns[i].ServerOnly && !oColumns[i].Hidden) { colWidthCount+=colArray[i];enableColumns++; } } if(colWidthCount<oGrid.MainGrid.clientWidth) { avgWidth=Math.round((oGrid.MainGrid.clientWidth- colWidthCount)/enableColumns); } // Loop through each Column in the grid to set // the Column width to the largest width found. for (var i = 0; i < count; i++) { // Don't set the width for columns that weren't available if (colArray[i] > 0) { // Note: the 10 pixels padding here might need to be // adjusted depending on the layout and styles of the grid. oColumns[i].setWidth((colArray[i] + avgWidth)); } }}
Instead of looping through all the cells in a column just use the PerformAutoResize on the specific column
Hi Mike,
Nice code sample. Unfortunately, it will only works on the first grid's band and if the grid doesn't have GroupBy rows nor ServerOnly columns. Getting it to work on multiple Bands isn't that hard. Getting it to work with GroupBy rows is somewhat harder...
I've been playing around with your code (quite) a bit and I've been able to get it to work with more complicated grids. I just wanted to post my take on this and I'd like to know if there is anything that could be improved.
Here's my code:
// Column Size Array var colArray; function InitWidth(gridName) { // Retrieve the grid based on its ID. var oGrid = igtbl_getGridById(gridName); // Get the Bands collection var oBands = oGrid.Bands; // Get the columns collection for Band 0 var oBand = oBands[0]; var oColumns = oBand.Columns; // The column count is equal to the // length of the Columns array. var count = oColumns.length; // Initialise Column Size Array on the first call. if (colArray == null) {; colArray = new Array(); for (var i = 0; i < count; i++) { colArray[i] = 0; } } // Set each Column Header width. var oColHeaders for (var i = 0; i < count; i++) { // Don't check columns that aren't displayed if (!oColumns[i].ServerOnly && !oColumns[i].Hidden) { // This loop is needed since each Column Header // have the same Id in every group. We need to // check them all because only opened groups will // have a value in "offsetWidth". oColHeaders = oGrid.MainGrid.getElementsByTagName('th') for (var j = 0; j < oColHeaders.length; j++) { if (oColHeaders[j].getAttribute('id') == oColumns[i].Id) { var colWidth = oColHeaders[j].firstChild.offsetWidth if (colArray[i] < colWidth) { colArray[i] = colWidth; } if (colWidth > 0) { // We found a displayed header, no need to check them all. break; } } } } } // Get the width from the data rows ParseNonGroupingRows(oGrid.Rows, oColumns, colArray); // Loop through each Column in the grid to set // the Column width to the largest width found. for (var i = 0; i < count; i++) { // Don't set the width for columns that weren't available if (colArray[i] > 0) { // Note: the 10 pixels padding here might need to be // adjusted depending on the layout and styles of the grid. oColumns[i].setWidth(colArray[i] + 10); } } } // This function go through each level of grouping rows // in order to get to the data rows function ParseNonGroupingRows(rowList, colList, colWidthArray) { if (rowList.getRow(0).GroupByRow) { // Check if the first row is a GroupBy row for (var i = 0; i < rowList.length; i++) { // If so, call the function recursively for each // GroupBy row in the list, passing out it's // (child) Rows collection to the function. ParseNonGroupingRows(rowList.getRow(i).Rows, colList, colWidthArray) } } else { // The first row is a data row, parse all the rows // in the collection to get their cells width. GetRowsCellWidth(rowList, colList, colWidthArray); } } // This function do the actual job of getting the columns // width from each cell function GetRowsCellWidth(rowList, colList, colWidthArray) { for (var i = 0; i < rowList.length; i++) { for (var n = 0; n < colList.length; n++) { // Don't check columns that aren't displayed if (!colList[n].ServerOnly && !colList[n].Hidden) { var cell = rowList.getRow(i).getCell(n); if (colWidthArray[n] < cell.Element.firstChild.offsetWidth) { colWidthArray[n] = cell.Element.firstChild.offsetWidth; } } } } } // Call the function in the grid's events function myGrid_InitializeLayoutHandler(gridName){ InitWidth(gridName); } function myGrid_AfterRowExpandedHandler(gridName){ InitWidth(gridName); }
Some points of interest:
All in all, this has been a fun experiment with the UltraWebGrid CSOM. God bless my JavaScript debugger for being able to inspect how all these objects where interacting!
Hope this can help someone else.
By the way, it would be very nice to add an actual AutosizeColumns() function somewhere in the CSOM or even better a property on the Band object in server side.
Regards,
Eric Brousseau,Software developper