jQuery UI Widgets › Forums › Grid › SetColumnProperty Width Not Working
Tagged: jquery grid cell width
This topic contains 4 replies, has 2 voices, and was last updated by bozpet 11 years, 7 months ago.
Viewing 5 posts - 1 through 5 (of 5 total)
-
Author
-
I tried many other properties like “align” and it works, but setting the width is not working…
$(“#objetives”).jqxGrid(‘beginupdate’);
$(“#objetives”).jqxGrid(‘setcolumnproperty’, ‘mValor’, ‘width’, ‘10%’);
$(“#objetives”).jqxGrid(‘setcolumnproperty’, ‘dtDataInicio’, ‘width’, ‘10%’);
$(“#objetives”).jqxGrid(‘endupdate’);Grid Properties:
width: ‘100%’,
height: ‘200px’,
source: dataAdapterObjectives,
theme: theme,
columnsresize: true,
showstatusbar: true,
editable: true,
editmode: ‘selectedcell’,
selectionmode: ‘singlecell’,Any sugestion??
Best Regards
hi bozpet,
You can find a sample below:
<!DOCTYPE html><html lang="en"><head> <title id='Description'>This example shows how to create a Grid from Array data.</title> <link rel="stylesheet" href="../../jqwidgets/styles/jqx.base.css" type="text/css" /> <script type="text/javascript" src="../../scripts/jquery-1.10.2.min.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxcore.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxdata.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxbuttons.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxscrollbar.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxmenu.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxgrid.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxgrid.selection.js"></script> <script type="text/javascript" src="../../jqwidgets/jqxgrid.columnsresize.js"></script> <script type="text/javascript" src="../../scripts/demos.js"></script> <script type="text/javascript"> $(document).ready(function () { // prepare the data var data = new Array(); var firstNames = [ "Andrew", "Nancy", "Shelley", "Regina", "Yoshi", "Antoni", "Mayumi", "Ian", "Peter", "Lars", "Petra", "Martin", "Sven", "Elio", "Beate", "Cheryl", "Michael", "Guylene" ]; var lastNames = [ "Fuller", "Davolio", "Burke", "Murphy", "Nagase", "Saavedra", "Ohno", "Devling", "Wilson", "Peterson", "Winkler", "Bein", "Petersen", "Rossi", "Vileid", "Saylor", "Bjorn", "Nodier" ]; var productNames = [ "Black Tea", "Green Tea", "Caffe Espresso", "Doubleshot Espresso", "Caffe Latte", "White Chocolate Mocha", "Cramel Latte", "Caffe Americano", "Cappuccino", "Espresso Truffle", "Espresso con Panna", "Peppermint Mocha Twist" ]; var priceValues = [ "2.25", "1.5", "3.0", "3.3", "4.5", "3.6", "3.8", "2.5", "5.0", "1.75", "3.25", "4.0" ]; for (var i = 0; i < 200; i++) { var row = {}; var productindex = Math.floor(Math.random() * productNames.length); var price = parseFloat(priceValues[productindex]); var quantity = 1 + Math.round(Math.random() * 10); row["firstname"] = firstNames[Math.floor(Math.random() * firstNames.length)]; row["lastname"] = lastNames[Math.floor(Math.random() * lastNames.length)]; row["productname"] = productNames[productindex]; row["price"] = price; row["quantity"] = quantity; row["total"] = price * quantity; data[i] = row; } var source = { localdata: data, datatype: "array", datafields: [ { name: 'firstname', type: 'string' }, { name: 'lastname', type: 'string' }, { name: 'productname', type: 'string' }, { name: 'quantity', type: 'number' }, { name: 'price', type: 'number' }, { name: 'total', type: 'number' } ] }; var dataAdapter = new $.jqx.dataAdapter(source); $("#jqxgrid").jqxGrid( { width: '100%', source: dataAdapter, columnsresize: true, columns: [ { text: 'Name', dataField: 'firstname', width: 100 }, { text: 'Last Name', dataField: 'lastname', width: 100 }, { text: 'Product', editable: false, dataField: 'productname', width: 180 }, { text: 'Quantity', dataField: 'quantity', width: 80, cellsalign: 'right' }, { text: 'Unit Price', dataField: 'price', width: 90, cellsalign: 'right', cellsformat: 'c2' }, { text: 'Total', dataField: 'total', cellsalign: 'right', minwidth: 100, cellsformat: 'c2' } ] }); $("#button").click(function () { $("#jqxgrid").jqxGrid('beginupdate'); $("#jqxgrid").jqxGrid('setcolumnproperty', 'firstname', 'width', '30%'); $("#jqxgrid").jqxGrid('setcolumnproperty', 'lastname', 'width', '30%'); $("#jqxgrid").jqxGrid('endupdate'); $("#jqxgrid").jqxGrid('invalidate'); }); }); </script></head><body class='default'> <div id='jqxWidget'> <div id="jqxgrid"> </div> <button id="button">Set Column Widths</button> </div></body></html>
There’s an additional “invalidate” method call.
Best Regards,
Peter StoevjQWidgets Team
http://www.jqwidgets.com/I tried the invalidate and its the same… dont work..
$("#objetives").jqxGrid('beginupdate'); $("#objetives").jqxGrid('setcolumnproperty', 'mValor', 'width', 10); $("#objetives").jqxGrid('setcolumnproperty', 'mValorPorDefeito', 'width', '10px'); $("#objetives").jqxGrid('setcolumnproperty', 'dtDataInicio', 'width', '10%'); $("#objetives").jqxGrid('endupdate'); $("#objetives").jqxGrid('invalidate');
Three different ways to set the width but always the same result… If i set the align og the cell it works, but the width dont work.
Hi bozpet,
I am not sure what is the issue on your side, but the sample I sent you works on my side. If you wish, you may share a full sample with your scenario, too.
Best Regards,
Peter StoevjQWidgets Team
http://www.jqwidgets.com$("#objetives").jqxGrid( { width: '100%', // autoheight: true, height: '200px', source: dataAdapterObjectives, theme: theme, columnsresize: true, showstatusbar: true, editable: true, editmode: 'selectedcell', selectionmode: 'singlecell', handlekeyboardnavigation: function(event) { var key = event.charCode ? event.charCode : event.keyCode ? event.keyCode : 0; if (key == 46) { var cell = $('#objetives').jqxGrid('getselectedcell'); if(cell.datafield == 'mValor'){ $("#objetives").jqxGrid('getrowdata', $("#objetives").jqxGrid('getselectedcell').rowindex).mValor=''; $('#objetives').jqxGrid('refreshdata'); $("#objetives").jqxGrid('updaterow',$("#objetives").jqxGrid('getselectedcell').rowindex, $("#objetives").jqxGrid('getrowdata', $("#objetives").jqxGrid('getselectedcell').rowindex)); } else if(cell.datafield == 'mValorPorDefeito'){ $("#objetives").jqxGrid('getrowdata', $("#objetives").jqxGrid('getselectedcell').rowindex).mValorPorDefeito=''; $('#objetives').jqxGrid('refreshdata'); $("#objetives").jqxGrid('updaterow',$("#objetives").jqxGrid('getselectedcell').rowindex, $("#objetives").jqxGrid('getrowdata', $("#objetives").jqxGrid('getselectedcell').rowindex)); } return true; } }, columns: [ { text: 'biIndicadorObjectivo', datafield: 'biIndicadorObjectivo',"hidden": "true" }, { text: 'iApeIndicador', datafield: 'iApeIndicador',hidden: true }, { text: 'Fecha Inicio', datafield: 'dtDataInicio', columntype: 'datetimeinput', cellsformat: 'd/M/yyyy', createeditor: function (row, column, editor) { editor.jqxDateTimeInput({ culture: 'en-CA' }); }, width:_Width }, /* { text: 'Período', datafield: 'siPeriodo', displayfield: 'NomePeriodo', columntype: 'dropdownlist', createeditor: function (row, value, editor) { editor.jqxDropDownList({ source: periodTypesAdapter, displayMember: 'vcDescricao', valueMember: 'siPeriodo' }); }, width:'10%' },*/ { text: 'Valor', datafield: 'mValor', align: 'right', cellsalign: 'right', cellsformat: '<%Get_ValueType();%>', columntype: 'numberinput', createeditor: function (row, cellvalue, editor) { editor.jqxNumberInput(); //{ digits: 3 } }, width:_Width }, { text: 'Valor por Defecto', datafield: 'mValorPorDefeito', align: 'right', cellsalign: 'right', cellsformat: '<%Get_ValueType();%>', columntype: 'numberinput', createeditor: function (row, cellvalue, editor) { editor.jqxNumberInput(); //{ digits: 3 } }, width:_Width }, { text: 'cCodArtigo', datafield: 'cCodArtigo', width:'20%', "hidden": "true" }, { text: 'Articulo', datafield: 'vcNomeArtigo', width:'25%', cellbeginedit: function (row) {return false;}, "hidden": _ShowArticle}, { text: '',cellbeginedit: function (row) {return false;}, datafield: 'OpenArt', cellsrenderer: cellRendererArticle, width: '50', "hidden": _ShowArticle}, { text: 'cTipoTerceiro', datafield: 'cTipoTerceiro', width:'20%', "hidden": "true" }, { text: 'cCodTerceiro', datafield: 'cCodTerceiro', width:'20%', "hidden": "true" }, { text: 'Entidade', datafield: 'vcNomeEntidade', width:'25%', cellbeginedit: function (row) {return false;}, "hidden": _ShowEntity}, { text: '',cellbeginedit: function (row) {return false;}, datafield: 'OpenEnt', cellsrenderer: cellRendererEntity, width: '50', "hidden": _ShowEntity}, ], renderstatusbar: function (statusbar) { var container = $("<div style='overflow: hidden; position: relative; margin: 5px;'></div>"); var addButton = $("<div style='float: left; margin-left: 5px;'><span style='margin-left: 4px; position: relative; top: -3px;'>Añadir </span></div>"); var deleteButton = $("<div style='float: left; margin-left: 5px;'><span style='margin-left: 4px; position: relative; top: -3px;'>Borrar</span></div>"); // var updateButton = $("<div style='float: left; margin-left: 5px;'><span style='margin-left: 4px; position: relative; top: -3px;'>Atualizar</span></div>"); container.append(addButton); container.append(deleteButton); statusbar.append(container); addButton.jqxButton({ theme: theme, width: 60, height: 15 }); deleteButton.jqxButton({ theme: theme, width: 65, height: 15 }); // updateButton.jqxButton({ theme: theme, width: 65, height: 20 }); // add new row. addButton.click(function (event) { var rowscount = $("#objetives").jqxGrid('getdatainformation').rowscount; var selectedrowindex = $("#objetives").jqxGrid('getselectedcell').rowindex; $("#objetives").jqxGrid('endrowedit',selectedrowindex, false); var datarow = generaterowObjective(rowscount-1); $("#objetives").jqxGrid('addrow', null, datarow); }); // delete selected row. deleteButton.click(function (event) { var selectedrowindex = $("#objetives").jqxGrid('getselectedcell').rowindex; var rowscount = $("#objetives").jqxGrid('getdatainformation').rowscount; if (selectedrowindex >= 0 && selectedrowindex < rowscount) { var id = $("#objetives").jqxGrid('getrowid', selectedrowindex); $("#objetives").jqxGrid('deleterow', id); } }); statusbar.append(container); }, }); }
Here is the complete code…. some columns hide and show depending of another variable, when i change the variable i run this function:
function showHideColumns(dimension) { if(dimension == "1" ||dimension == "") { $("#objetives").jqxGrid('hidecolumn', 'vcNomeArtigo'); $("#objetives").jqxGrid('hidecolumn', 'OpenArt'); $("#objetives").jqxGrid('hidecolumn', 'vcNomeEntidade'); $("#objetives").jqxGrid('hidecolumn', 'OpenEnt'); }else if(dimension == "2") { $("#objetives").jqxGrid('showcolumn', 'vcNomeArtigo'); $("#objetives").jqxGrid('showcolumn', 'OpenArt'); $("#objetives").jqxGrid('hidecolumn', 'vcNomeEntidade'); $("#objetives").jqxGrid('hidecolumn', 'OpenEnt'); }else if(dimension == "4") { $("#objetives").jqxGrid('hidecolumn', 'vcNomeArtigo'); $("#objetives").jqxGrid('hidecolumn', 'OpenArt'); $("#objetives").jqxGrid('showcolumn', 'vcNomeEntidade'); $("#objetives").jqxGrid('showcolumn', 'OpenEnt'); }else if(dimension == "3") { $("#objetives").jqxGrid('showcolumn', 'vcNomeArtigo'); $("#objetives").jqxGrid('showcolumn', 'OpenArt'); $("#objetives").jqxGrid('showcolumn', 'vcNomeEntidade'); $("#objetives").jqxGrid('showcolumn', 'OpenEnt'); $("#objetives").jqxGrid('beginupdate'); $("#objetives").jqxGrid('setcolumnproperty', 'mValor', 'width', 10); $("#objetives").jqxGrid('setcolumnproperty', 'mValorPorDefeito', 'width', '10px'); $("#objetives").jqxGrid('setcolumnproperty', 'dtDataInicio', 'width', '10%'); $("#objetives").jqxGrid('endupdate'); $("#objetives").jqxGrid('invalidate'); } } -
AuthorPosts
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic.