1) Given that you are using datatables the library for this plugin are there Multi-item editing (rows, columns, cells) options in Front-end this plugin? 2) and also CSV import or xlsx import option in fornt-end ? 3) and FixedColumns integration option Or can it be added in some way?
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
All this would have to be achieved with some custom work.
I don't have any workarounds for 1) and 2), but I can share with you a reply from one of our customers that managed to achieve a fixed column:
"I actually created a fixed header and column using translation of x and y (no absolute or fixed position used), very similar to the fixed header provided by weihs5 on this site, and here's one solution, take a look:
First of all, you gotta set the z-index for each component below:
And here's the scrollBlock() part, it is ugly though, but it works for me though. (noted: the numbers work for my theme, if it is not working correctly on yours, then try to adjust the number until it fits.)
function scrollBlock(){ var table = document.querySelector('table');
var top = table.getBoundingClientRect().top;
top = document.body.className.search('admin') > 0 ? top - 32 : top + 3; // this value can change
var left = table.getBoundingClientRect().left;
if(left >= 20){ // before scrolling left (before transforming)
if(top >= 0){ // before reaching header bar
jQuery("#table_1 thead th").css("transform", "translateY(0px)");
translate(jQuery("table th:nth-child(1)"), 0, 0);
translate(jQuery("table td:nth-child(1)"), 0, 0);
} else{ // after reaching header bar
jQuery("#table_1 thead th").css("transform", "translateY( " + (-top) + "px)");
translate(jQuery("table th:nth-child(1)"), 0, -top);
translate(jQuery("table td:nth-child(1)"), 0, 0);
} } else{ // after scrolling left
if(top >= 0){
jQuery("#table_1 thead th").css("transform", "translateY(0px)");
translate(jQuery("table th:nth-child(1)"), -left + 46, 0);
translate(jQuery("table td:nth-child(1)"), -left + 46, 0);
} else{
jQuery("#table_1 thead th").css("transform", "translateY( " + (-top) + "px)");
translate(jQuery("table th:nth-child(1)"), -left + 46, -top);
translate(jQuery("table td:nth-child(1)"), -left + 46, 0);
}
}
}
function translate(element, x, y) {
var translation = "translate(" + x + "px," + y + "px)"
element.css({
"transform": translation,
"-ms-transform": translation,
"-webkit-transform": translation,
"-o-transform": translation,
"-moz-transform": translation,
});
}
It is kind of messy, you definitely can't copy and paste and expect it to work for you. You need to spend some time to figure it out. Hope this helps everyone!"
Hi Team
1) Given that you are using datatables the library for this plugin are there Multi-item editing (rows, columns, cells) options in Front-end this plugin?
2) and also CSV import or xlsx import option in fornt-end ?
3) and FixedColumns integration option
Or can it be added in some way?
Multi-item editing (rows, columns, cells)
FixedColumns integration
CSV import
BR
Hello Sina.
Thank you for your interest in our plugin.
I am sorry to disappoint you, but unfortunately something like this is not possible with the plugin's built-in features.
All this would have to be achieved with some custom work.
I don't have any workarounds for 1) and 2), but I can share with you a reply from one of our customers that managed to achieve a fixed column:
"I actually created a fixed header and column using translation of x and y (no absolute or fixed position used), very similar to the fixed header provided by weihs5 on this site, and here's one solution, take a look:
First of all, you gotta set the z-index for each component below:
Then you gotta add listener on scroll like this:
If your table is set to be scrollable, then you might want to add this in as well:
And here's the scrollBlock() part, it is ugly though, but it works for me though. (noted: the numbers work for my theme, if it is not working correctly on yours, then try to adjust the number until it fits.)
It is kind of messy, you definitely can't copy and paste and expect it to work for you. You need to spend some time to figure it out. Hope this helps everyone!"
So, I hope at least that will help you out.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables