As previously announced via banners and our newsletters, support is no longer available through this platform.

For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.

You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.

Paid customers: Please log in to your store account for support.

Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com

Okay
  Public Ticket #3012464
Export Excel
Closed

Comments

  • Panji Achmad started the conversation
    March 29, 2022 at 7:29am

    Hello There,

    i have some issue for exporting table to excel, when the data set to "integer" (with separator thousand) 3 digit/ thousand data lost. (e.g 300.000 in front end table become only 300 in excel)

    and also when data type "image" exporting data to excel become empty, i need that image also exported to excel. is it possible?

    thank you

  •  1,896
    Miloš replied
    April 1, 2022 at 7:08pm

    Hi, Panji Achmad

    Thanks for reaching out to us

    Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

    -

    • After further investigation, we found out that 3rd party software that is responsible for exporting tables in excel does not support the European number format. It only works if numbers contain both dot and comma in number. Here is the reference.

    This is why Export numbers with commas as decimal separators have issues in the Excel report. 

    • Please use the CSV export button or change column type to string if you have to use this number format.

    Alternatively, you could change the number format.

    We apologise for the inconvenience.

    -

    • Exporting images is not possible at the moment, but you are able to export them as HTML with the new “Include HTML” option.

    -

    Let me know if you have further questions. Thank you

    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