[andre84Participant]

In my grid, I only can CTRL+C on Internet explorer but not with chrome or firefox

I put the property at enablebrowserselection: true.

Can you take me the demo where I can CTRL+C with editable property at false?

Thanks

André

[andre84Participant]

Thanks this works.
For the others persons who have this problem :
$(“#MyGrid”).jqxGrid(‘exportdata’, ‘xls’, “Title”, true, null, false, null, “UTF-8”);

[andre84Participant]

I found the problem, I have a special characters because we ‘re french. I don’t know how solve it.
It’s possible to encode in utf-8(without bom) or a paramaeter when we export?

Thanks for your help

André

[andre84Participant]

We use the last jQWidgets version.
I use this method : $(“#jqxgrid”).jqxGrid(‘exportdata’, ‘xls’, ‘jqxGrid’);
it’s possible to force charset on export?

This is the xml generate
<?xml version=”1.0″?>
<?mso-application progid=”Excel.Sheet”?>
<Workbook xmlns=”urn:schemas-microsoft-com:office:spreadsheet”
xmlns:o=”urn:schemas-microsoft-com:office:office”
xmlns:x=”urn:schemas-microsoft-com:office:excel”
xmlns:ss=”urn:schemas-microsoft-com:office:spreadsheet”
xmlns:html=”http://www.w3.org/TR/REC-html40″>
<DocumentProperties xmlns=”urn:schemas-microsoft-com:office:office”>
<Version>12.00</Version>
</DocumentProperties>
<ExcelWorkbook xmlns=”urn:schemas-microsoft-com:office:excel”>
<WindowHeight>8130</WindowHeight>
<WindowWidth>15135</WindowWidth>
<WindowTopX>120</WindowTopX>
<WindowTopY>45</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID=”xls-style-1″ ss:Name=”xls-style-1″>
<Alignment ss:Vertical=”Bottom” ss:Horizontal=”Left”/>
<Borders>
<Border ss:Position=”Bottom” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Left” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Right” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Top” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
</Borders>
<Font ss:Color=”#545454″ ss:Bold=”1″ />
<Interior ss:Color=”#FFFFFF” ss:Pattern=”Solid”/>
</Style>
<Style ss:ID=”xls-style-2″ ss:Name=”xls-style-2″>
<Alignment ss:Vertical=”Bottom” ss:Horizontal=”Left”/>
<Borders>
<Border ss:Position=”Bottom” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Left” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Right” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Top” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
</Borders>
<Font ss:Color=”#545454″ />
<Interior ss:Color=”#FFFFFF” ss:Pattern=”Solid”/>
</Style>
<Style ss:ID=”xls-style-3″ ss:Name=”xls-style-3″>
<Alignment ss:Vertical=”Bottom” ss:Horizontal=”Left”/>
<Borders>
<Border ss:Position=”Bottom” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Left” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Right” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
<Border ss:Position=”Top” ss:LineStyle=”Continuous” ss:Weight=”1″ ss:Color=”#DDDDDD”/>
</Borders>
<Font ss:Color=”#545454″ />
<Interior ss:Color=”#F9F9F9″ ss:Pattern=”Solid”/>
</Style>
</Styles>
<Worksheet ss:Name=”Sheet1″>
<Table>
<Column ss:Width=”100″/>
<Column ss:Width=”100″/>
<Column ss:Width=”100″/>
<Column ss:Width=”100″/>
<Column ss:Width=”100″/>
<Column ss:Width=”100″/>
<Column ss:Width=”100″/>
<Row>
<Cell ss:StyleID=”xls-style-1″><Data ss:Type=”String”>Type</Data></Cell>
<Cell ss:StyleID=”xls-style-1″><Data ss:Type=”String”>Désignation</Data></Cell>
<Cell ss:StyleID=”xls-style-1″><Data ss:Type=”String”>N° Interne</Data></Cell>
<Cell ss:StyleID=”xls-style-1″><Data ss:Type=”String”>N° série</Data></Cell>
<Cell ss:StyleID=”xls-style-1″><Data ss:Type=”String”>Référence</Data></Cell>
<Cell ss:StyleID=”xls-style-1″><Data ss:Type=”String”>Constructeur</Data></Cell>
<Cell ss:StyleID=”xls-style-1″><Data ss:Type=”String”>Etat</Data></Cell>
</Row>
<Row>
<Cell ss:StyleID=”xls-style-2″><Data ss:Type=”String”>Incident</Data></Cell>
<Cell ss:StyleID=”xls-style-2″><Data ss:Type=”String”>Accès MS Outlook</Data></Cell>
<Cell ss:StyleID=”xls-style-2″><Data ss:Type=”String”>ttt – 053310</Data></Cell>
<Cell ss:StyleID=”xls-style-2″><Data ss:Type=”String”></Data></Cell>
<Cell ss:StyleID=”xls-style-2″><Data ss:Type=”String”></Data></Cell>
<Cell ss:StyleID=”xls-style-2″><Data ss:Type=”String”></Data></Cell>
<Cell ss:StyleID=”xls-style-2″><Data ss:Type=”String”>Fermé</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>

[andre84Participant]

Thanks, it’s work !! I do an error on my condition.

Best Regards,

André

[andre84Participant]

In your sample the grid have editable mode. In my way, I’m not in this case.
I use $(“#jqxgrid”).jqxGrid(‘updaterow’, rowIDs, newRows);.
When the row is updated, it doesn’t pass in cellclass

source ={
updaterow: function (rowid, rowdata, commit) {
// that function is called after each edit.
alert(“toto”);
// synchronize with the server – send update command
// call commit with parameter true if the synchronization with the server is successful
// and with parameter false if the synchronization failder.
var rowindex = $(“#” + that._id).jqxGrid(‘getrowboundindexbyid’, rowid);
that._oaEditedRowsId.push(rowindex);
commit(true);
}
},

var cellclass = function (row, datafield, value, rowdata) {
for (var i = 0; i < editedRows.length; i++) {
if (editedRows[i].index == row) {
return “editedRow”;
}
}
}

[andre84Participant]

Thanks a lot, it’s work !!!

[Author]

Posts