We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #2790920
Problem with Data in Table
Closed

Comments

  • Edward Keeley started the conversation
    May 31, 2021 at 7:47pm

    Hi,

    I am having a very strange problem and am not sure what to do to correct it.  I have built a table with several columns and am using an Excel spreadsheet as the source file.  The column named "Rank" does not show the correct data on the table.  All other columns are correct.  At first I thought it was putting the data in the wrong positions but upon further investigation I found that the data is incorrect.  Any ideas on what might be causing this?  I have included a screenshot of the table and a copy of the source file.

  • [deleted] replied
    June 1, 2021 at 11:19am

    Hi Edward

    Thank you for reaching out to us.

    Formatting applied in the original file (font families, color, size, fill color, etc.) will not be copied over to the wpDataTable, but you can make whatever adjustment you may need in WpDataTables. We removed all formatting from the file and the table is created normally.

    If you need to show numbers as integer or float but still have the percentage sign please remove the percentage sign from the source file and also empty values as - and when you create table you can add cell prefix or suffix in column settings.

    7265972814.png

    Please find attached the reformatted file you can use to create your table.

  • Edward Keeley replied
    June 1, 2021 at 5:49pm

    Hi,

    Thank you for your help.  I did know to format the cells in WpDataTables.  The problem I had is when I removed the percentage formatting from my file it would not display correctly in WpDataTables.  For instance, if I have 83.90% on my file and remove the formatting it changes it to 0.8390.  If I then put in the percentage sign in the suffix for the column settings the number in the cell in WpDataTables is 0.8390%, not 83.90%.  However, I took the file you sent back to me and changed the cells that needed to be percentages back to percentages but left all other formatting out and it is working properly so it must have been some of the other formatting causing the problem.  But, for my future reference, is there a solution to the problem I indicated above with the example of the 83.90% number?

  • [deleted] replied
    June 2, 2021 at 10:42am

    Hi Edward

    If you typed in 83.90 that would be what is displayed in the table, but you had some custom format that displays floats as percentages and that is why the result was different.

    Do let us know if there is anything else we can assist you with.