Okay
  Public Ticket #1883587
print/excel/pdf missing counts and color formatting
Closed

Comments

  • Daniel Wayne Kirkwood started the conversation

    I have a screen display that looks good but when using the TABLE TOOLS, the output into PDF/PRINT/EXCEL are all missing things like the SUM generated at end of columns and conditional background color based on content. Is there anyway to get the output to look like what is on the screen?

  •  2,572
    Aleksandar replied

    Hi again, Daniel.

    I am sorry to disappoint you, but unfortunately table tools are based on a 3rd party HTML5 library, and there are some limitations in that library which we cannot change:

    • 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.
    • When you export tables with the wpDataTables plugin, please note that you can export values, but not formulas. WpDataTables doesn’t support exporting formulas, so a Formula column will be exported only with values; and any calculations of Average, MIN, MAX, and Total will not be exported at all.
    • Exporting images is not possible at the moment.
    • You can’t export columns that are hidden – they will not be visible in any exporting or printing tool.

    You can read more about all table tools in our documentation, but unfortunately there's nothing we can do to help you with this question.

    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