TableTools / ColumnFilter when "select_all" not selecting only "visible" lines
TableTools / ColumnFilter when "select_all" not selecting only "visible" lines
Pcarrega
Posts: 2Questions: 0Answers: 0
Hello,
I'm new in datatables and i'm trying to use TableTools with columnFilter.
When i do a filter with columnFilter, the "copy/cvs/pdf" button export the all "Table" and not only the visible lines.
I've tried different options without success and i have "sRowSelect" to "Multi" and "bSelectedOnly" to "true".
And when i select the lines one by one, it work's ?!
Something funny :
- In a filtered tab :
* If i click "select_all" and "copy", the all table is copied
* If i click "selec_none" and "copy", only the filtered lines are copied !!
Can someone help me ?
Here is my code :
[code]
var oTableTools = {
"sSwfPath": "swf/copy_csv_xls_pdf.swf'",
"sRowSelect": "multi",
"aButtons": [
{
"sExtends": "select_all",
"sButtonClass": "",
"sToolTip": "Sélectionne toutes les lignes du tableau"
},
{
"sExtends": "select_none",
"sButtonClass": "",
"sToolTip": "Sélectionne toutes les lignes du tableau"
},
{
"sExtends": "copy",
"sButtonClass": "bouton",
"sToolTip": "Copie tout le tableau ou les lignes sélectionnées dans le presse papier",
"mColumns": [ 0, 1 ],
"bSelectedOnly": true
},
{
"sExtends": "csv",
"sCharSet": "utf16le",
"sButtonClass": "bouton",
"mColumns": [ 0, 1 ],
"bSelectedOnly": true,
"sFieldSeperator": ";",
"sToolTip": "Séparateur ';' ",
},
{
"sExtends": "pdf",
"sButtonClass": "bouton",
"mColumns": [ 0, 1 ],
"bSelectedOnly": true
},
{
"sExtends": "print",
"sButtonClass":"bouton",
"sToolTip": "Aperçu impression",
"bShowAll": true
}
]};
[/code]
I'm new in datatables and i'm trying to use TableTools with columnFilter.
When i do a filter with columnFilter, the "copy/cvs/pdf" button export the all "Table" and not only the visible lines.
I've tried different options without success and i have "sRowSelect" to "Multi" and "bSelectedOnly" to "true".
And when i select the lines one by one, it work's ?!
Something funny :
- In a filtered tab :
* If i click "select_all" and "copy", the all table is copied
* If i click "selec_none" and "copy", only the filtered lines are copied !!
Can someone help me ?
Here is my code :
[code]
var oTableTools = {
"sSwfPath": "swf/copy_csv_xls_pdf.swf'",
"sRowSelect": "multi",
"aButtons": [
{
"sExtends": "select_all",
"sButtonClass": "",
"sToolTip": "Sélectionne toutes les lignes du tableau"
},
{
"sExtends": "select_none",
"sButtonClass": "",
"sToolTip": "Sélectionne toutes les lignes du tableau"
},
{
"sExtends": "copy",
"sButtonClass": "bouton",
"sToolTip": "Copie tout le tableau ou les lignes sélectionnées dans le presse papier",
"mColumns": [ 0, 1 ],
"bSelectedOnly": true
},
{
"sExtends": "csv",
"sCharSet": "utf16le",
"sButtonClass": "bouton",
"mColumns": [ 0, 1 ],
"bSelectedOnly": true,
"sFieldSeperator": ";",
"sToolTip": "Séparateur ';' ",
},
{
"sExtends": "pdf",
"sButtonClass": "bouton",
"mColumns": [ 0, 1 ],
"bSelectedOnly": true
},
{
"sExtends": "print",
"sButtonClass":"bouton",
"sToolTip": "Aperçu impression",
"bShowAll": true
}
]};
[/code]
This discussion has been closed.
Replies
Here is the hawser http://datatables.net/forums/discussion/15039/table-tools-select_all-seems-to-ignore-filter-criteria/p1