Okay
  Public Ticket #1458199
How can I make collapsed fields visible on print/CSV/etc.?
Closed

Comments

  • Jaimie started the conversation

    Hello,


    I have set up a  table with 9 (front-end visible) fields; I have all but 3 of them set to collapse for tablet/mobile in order to display nicely in-browser. (I also set tablet width to 2000px so desktops trigger the tablet view as well.)


    Is there a way that I can get the download views (print, CSV, Excel, PDF) to display all 9 visible fields for all the rows?


    For example, currently if you download the CSV file of the table, it will download only the data in the 3 non-collapsed tables--in this case, it will download the data for the "Company", "Status" and date "Added" fields. I would like all of the fields visible on front-end ("Company", "Status", "Added", "First Name", "Last Name", etc...) and their data to show up when someone downloads the CSV file, for example.


    Thank you in advanced!

  •  1,708
    Miloš replied

    HI Jaimie,
    Thank you for your purchase.

    Sorry to disappoint you but unfortunately exporting functionality is based on 3rd party HTML5 library. There are some limitations in this library.

    For example for tables with server-side processing enabled, PDF, CSV, Excel will contain only the visible rows.

    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [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

  • Jaimie replied

    Hi Bogdan,

    Thanks for the quick reply. In that case, do you know of a way I can perhaps style my tables so that I can have all 9 fields displayed on desktop so they can print/download the data from all 9 fields while not cutting off data in the browser view?

    What I mean is...the reason I set the other 6 fields to collapse is because some of the data in certain fields (particularly the "Email" field) kept getting cut off, so it made the table hard to look at and view certain data. I have the columns set to wrap, but because some single words in each column were too long to wrap, everything was getting cut off. Is there a way I could set the columns to vertically scroll if the data goes over, say, 2 lines? Or a way I can enable a "click to expand"? Or, mathematically, do you have any suggestions on what I could set the column widths to in order to keep certain data from getting cut off from the browser view?

    If you look at the link that I attached in this ticket, I've updated it to include an extra table that demonstrates what I am talking about. As you can see, the email is always cut off because all emails are (and always probably will be) longer than the width of that column. I've tried manipulating the column widths to make the "Email" field large enough to display most email addresses, but then it makes the other fields too short and does the same thing.

    I realize that there's not much that can be done with so many fields, but any advice on how to improve the look and function of my tables would be appreciated! Let me know if you need a better idea of how these tables will be used.

  •  1,708
    Miloš replied

    HI Jaimie,

    Just to be clear can you please tell me do you want all of this columns to be visible at the desktop so there will be no option to hide one of them.



    Best regards.

    Kind Regards, 

    Miloš Jovanović
    [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