Holiday Notice – Support Unavailable on April 18 and April 21
We just wanted to let you know that our support team will be offline on Friday, April 18th (Good Friday) and Monday, April 21st (Easter Monday) due to the holidays.
We'll be back on Tuesday, ready to assist you!
In the meantime, if you need any help, feel free to:
-
Use the support widget in the bottom right corner on our websites (Amelia and wpDataTables) — our latest AI-powered assistant is there 24/7 to help with basic and intermediate questions,
-
Browse our detailed documentation (Amelia, wpDataTables)
-
Explore helpful articles,
-
Or check out our YouTube channels for video guides!
Amelia YouTube Channel
wpDataTables YouTube Channel
Thank you for your understanding, and we wish you a wonderful holiday weekend!
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.
Best regards.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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