I have a small dataset in Excel (9 rows) and I created a table. When I did so using the constructor, there was a blank row inserted, presumably to make up the missing number since the table showed 10 records at a time. How do I get rid of this blank row? BTW, it didn't happen when I made the table with Add Table from Datasource.
Can I get two line column headings, so my columns with small numbers don't have to be so big?
Can I control the width of columns?
Can I import Excel files with multiple tabs?
Can I do multi-level sorting, i.e., first by column 2, then by column 4, then by column 1?
Can I have conditional formatting in cells based on >, >=, etc.
If I want sorting, the table is always sorted by column 1. I'd like the table to display as is, but still support user sorting.
Can I eliminate/hide the search box and the paginate info on the bottom right?
Thank-you very much for your excellent product, I just got it and hope to do great things with it.
-When you are using Excel like manual tables the last column can not be deleted or hidden, this is on the Excel side and that is how the table is working, so we are not able to remove it.
2. Can I get two line column headings, so my columns with small numbers don't have to be so big?
-Can you please send me some screenshot or link so I can take a look and give you my suggestion.
3. Can I control the width of columns?
- In Additional settings for table, if you check Limit table layout option you will notice in Optionalcolumnsetup for each column , the Width field will be visible ( attachment 1)
4. Can I do multi-level sorting, i.e., first by column 2, then by column 4, then by column 1?
- Sorry but i did not quite understand what are you trying to achieve, can you please describe me more.
5. Can I have conditional formatting in cells based on >, >=, etc.
- You can take a look at our documentation about Conditional formating where you can find some useful hints how to define rules for column when creating table. Hope this helps.
6. If I want sorting, the table is always sorted by column 1. I'd like the table to display as is, but still support user sorting.
- Unfortunately something like this is not possible with build in functionalities of the plugin, and it requires some code customization. We can offer you our paid customization service where you can hire one of our developers to implement this feature for you.
7 Can I eliminate/hide the search box and the paginate info on the bottom right?
- You can put this code in Custom CSS field in wpdatatables settings page to hide the search field and pagination below the table.
I have a small dataset in Excel (9 rows) and I created a table. When I did so using the constructor, there was a blank row inserted, presumably to make up the missing number since the table showed 10 records at a time. How do I get rid of this blank row? BTW, it didn't happen when I made the table with Add Table from Datasource.
Can I get two line column headings, so my columns with small numbers don't have to be so big?
Can I control the width of columns?
Can I import Excel files with multiple tabs?
Can I do multi-level sorting, i.e., first by column 2, then by column 4, then by column 1?
Can I have conditional formatting in cells based on >, >=, etc.
If I want sorting, the table is always sorted by column 1. I'd like the table to display as is, but still support user sorting.
Can I eliminate/hide the search box and the paginate info on the bottom right?
Thank-you very much for your excellent product, I just got it and hope to do great things with it.
John Biddle
Hi John Biddle.
Thank you for your purchase.
1. How do I get rid of this blank row?
-When you are using Excel like manual tables the last column can not be deleted or hidden, this is on the Excel side and that is how the table is working, so we are not able to remove it.
2. Can I get two line column headings, so my columns with small numbers don't have to be so big?
-Can you please send me some screenshot or link so I can take a look and give you my suggestion.
3. Can I control the width of columns?
- In Additional settings for table, if you check Limit table layout option you will notice in Optional column setup for each column , the Width field will be visible ( attachment 1)
4. Can I do multi-level sorting, i.e., first by column 2, then by column 4, then by column 1?
- Sorry but i did not quite understand what are you trying to achieve, can you please describe me more.
5. Can I have conditional formatting in cells based on >, >=, etc.
- You can take a look at our documentation about Conditional formating where you can find some useful hints how to define rules for column when creating table. Hope this helps.
6. If I want sorting, the table is always sorted by column 1. I'd like the table to display as is, but still support user sorting.
- Unfortunately something like this is not possible with build in functionalities of the plugin, and it requires some code customization. We can offer you our paid customization service where you can hire one of our developers to implement this feature for you.
7 Can I eliminate/hide the search box and the paginate info on the bottom right?
- You can put this code in Custom CSS field in wpdatatables settings page to hide the search field and pagination below the table.
div.dataTables_paginate { display: none !important; } div.dataTables_filter { display: none !important; }Best regards.
Kind Regards,
Miloš Jovanović
[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