Okay
  Public Ticket #1838950
Group column - couple of issues
Closed

Comments

  • PrzemyslawGumulka started the conversation

    Hi,

    I have a couple of questions concerning 'Group column'. I haven't found the answer in FAQ or public tickets.

    1. How can I change the color of this column (actually, it becomes a row when set as group columns) without using CSS? I set the column color in the column settings, but it does not appear. I am using custom CSS, but it should be done easily with UI.

    2. When I export (to Excel, for example) table with one "group column", this column does not appear in the exported file. This is a HUGE issue and seems more like a bug. If I can't export this data, I just can't use "group column" feature.

    3. Another possible bug. I have one column set as "group column". Everything is fine on desktop (http://niechzyja.pl/dane-statystyczne-i-analizy/nadlesnictwa/). Now I switch to tablet mode. Suddenly my "group column" appears! Both as a "group column" and a regular one. It is easy to see on my sample site, because I set it as orange. I enclose screenshot. What is more, when I come back to desktop mode, it remains visible, even though it wasn't at the beginning. I have to refresh page to see it properly. I also tested a variant when I set "group column" as hidden on tablet. Then switching to tablet mode works properly, BUT when I go back to desktop mode the column appears. Very buggy. Tested on Chrome, current version, no plugins.

    4 (separate issue). I would strongly suggest adding an option "Hide on desktop". I know I can set tablet size to be that of desktop, but sometimes we might want to have separate settings.

  • PrzemyslawGumulka replied

    Another smaller issue - why is the gap between filter fields and the rest so huge? I enclose attachment.

  •  2,572
    Aleksandar replied

    Hello PrzemyslawGumulka.

    Thank You for Your purchase.

    Please note that row grouping feature is only available for non-server-side tables (relatively small tables linked to an existing source).

    1. Changing the color of a grouped row can't be changed in any other way than You already specified - custom CSS. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add this to our idea list and look into some possible solutions on plugin side in the future.

    2. Table Tools consists of a block of buttons that provides additional features for the tables: export to PDF, export to CSV, export to Excel, print view, toggle for column visibility for front-end users, etc. These functionalities are based on a 3rd party HTML5 library, and there are some limitations in this library:

    • For tables with server-side processing, only the visible rows will be exported to any format. If you want the entire table to be exported (or copied to a clipboard), you need to choose the “Show All” feature in the “show … entries” block, and then do the export.
    • Generated PDF, XLS, CSV are not customizable. Unfortunately, the library allows very little “fine-tuning” of the generated files, so font, size, and other properties cannot be changed.
    • Conditional formatting is not reflected in any of generated export files.
    • Other front-end extensions cannot be combined with Table Tools. If you have row grouping enabled for the table, or there are some customizations you did yourself, they won’t be reflected in the generated Excel, CSV or PDF document, nor in the clipboard.

    You can find more details on table tools on this link.

    3. I am sorry, but I couldn't see the issue You're describing. The table looks the same on desktop and mobile/tablet view (see attachments).

    4. Thank You for bringing this to our attention. We'll add this one also to our idea list, and look into implementing it in one of our future updates of the plugin.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • PrzemyslawGumulka replied

    Thank You for a prompt reply.

    Ad.2. If you are passing a "data object" to this external library, than it can be preparred before the export. In this case, a group column should be added as normal one and included in the export. If it can't be done, you can't justify using external tools to explain lacking crucial features. I can't export data without one column. If this external tool can't do it, it should be replaced with sth else.

    Ad.3. Problem is easily reproduced on my side. Please, open browser in a window (not full screen) and just keep making it narrower. At some point (which differs from table to table) group column appears as an additional (orange) column. When I refresh (f5) screen, it goes back to normal. If I don't refresh and go full screen, the orange column remains. I tested it in 3 different browsers.

  •  2,572
    Aleksandar replied

    Hello again PrzemyslawGumulka.

    As I said in the previous ticket - there must be some conflict with the theme or some other plugin, because these little tweaks shouldn't be there in the first place - the plugin is really easy to use, and we did focus on the design and the look and feel of the tables. It usually doesn't take this much custom CSS to make the table look normally.

    I've cleared the gap between the filters and the table tools by adding some custom CSS:

    .wpdt-c .wpDataTables:after {
        clear: none !important;
    }
    

    Also, going back to point #3 - I've reduced the mobile width under wpDataTables main Settings to "200" and now it doesn't display the "Dolnośląskie" column both as grouped and as the orange column (see attachment). That was the issue, it recognized the mobile device from 480px and above, and everything below it was disregarded. Since tablet settings are set to 20000, it will still have collapsible option on the desktop, so don't worry about that.

    Please take a look and let me know if it looks OK to You?

    As for printing the table when row grouping is enabled, I'll have to ask You to give me some time. I'll try to find a workaround for this, if at all possible.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • PrzemyslawGumulka replied

    Thank You. Most of the problems are easy to work around or just cosmetic. The biggest remaining problem is lack of export for the grouping column. This just means I can't use grouping.

  •  2,572
    Aleksandar replied

    Hello again PrzemyslawGumulka.

    I understand what You mean, but unfortunately at this time it is not possible to export tables with column grouping turned on. Since these functionalities are based on a 3rd party HTML5 library there is no customization that can be done on wpDataTables side to bypass the issue.

    I apologize for any inconvenience this may cause.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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