Hello abilenejohn.

Thank You for Your purchase.

I apologize for the late response, we've had non-working days during the holidays, and our replies are sparse a bit. We thank You for understanding.

Could You please tell me how You created the table - which data source did You use? Also, if it is at all possible, could You send us that file, so that we can recreate the issue in our local environment? Since this ticket is public just make sure You check Private answer before sending us the file, so that nobody can see it except for us. We do not interfere with any data or anything else except for the plugin, and of course we do not provide login data to third party.

Best regards.

Hello again John.

I'd need permission to open the first document:

https://docs.google.com/spreadsheets/d/14CQnv4nRDIhHeK8QvDyBRuLUZ_qKqnaWzefF6LrdcMI/edit#gid=2032697815

I have sent a request for that.

Unfortunately, I can't create any tables from any of the links You sent me (probably because of admin privileges), so I can't reproduce the issue on our end.

What I can do, however, is to give You some pointers about Google Spreadsheets and wpDataTables.

What I saw from the page You sent is that You've managed to get rid of the decimal point. Great news. Also, the table goes beyond the screen, so my advice would be to turn on the Scrollable option in the table settings, or limit the table to page width.

Next thing that comes to mind is this: You can work with formulas in google spreadsheets, You just need to create a new sheet in the same document and use =IMPORTRANGE option to pull the data from the other sheet (where the formulas are), and use the URL from that second sheet, and it'll display the data properly. You can read more about that here.

As for formatting, since You're creating a chart from this table, those columns need to be set as either Integers or Float. I'm not sure why it changes the formatting, though.

The best way to go about this, would be if You could please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

What You're trying to achieve with charts could probably be done with callbacks. But, I'd like to go about this one step at a time - let's make the tables look and function the way they should, and we'll deal with the chart after that.

Best regards.

Hello again John.

First, the decimals can be saved if You don't need to calculate anything on those columns (MIN, MAX, AVG or SUM). You just need to change the column type from "integer" to "string" (see attachment).

In order to create a temporary admin user, You need to go to the Users/Add New on the dashboard. There You can add all the data needed and just post the credentials here with PRIVATE option enabled (see attachment 2).

My e-mail address is [email protected]

Best regards.

Hi John,

Sorry for late response, but we did not work due to national holidays.

Aleksandar is out of office so I will try to help you out.

Can you please provide us Administrator role and write the user name and password here, just please choose PRIVATE reply so nobody except us can see the credentials.

Best regards.

Hello John.

I'm glad You got it to work.

Thank You for letting us know.

Thank you for your suggestion. 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 to our idea list and look into some possible solutions on plugin side in the future.

Best regards.

Hello again John.

We're sorry to hear you do not want to use the tool after purchase.

Please find our refund policy here: http://wpdatatables.com/help/refund-policy/

Due to the digital 'non-returnable' nature of goods we only do refunds when the tool is malfunctioning or not working as described, with prior confirmation that support is unable to resolve the issue. As the revoked license does not make the product non-functional, and because there were lots of abuses, unfortunately we cannot provide the 'return-on-request' refund policy. So we do not refund mistaken purchases, or cases when buyers had their own expectations of features.

To avoid such situations we have a fully-featured 'sandbox' site where one can try plugin's features before purchase, a free version of the plugin which can help to get a better understanding of how the plugin is working, all the plugin's documentation is available to anyone before purchase, and we try to clear up all the limitations of different features, and we always answer all pre-purchase questions clearly and honestly so that potential buyers would have clear understanding of how the plugin works.

1) Did You check the server upload limit? There is a number of different things that influence your website’s speed, like hosting, using the most recent version of WordPress, Framework, etc. WordPress slow load can also partially be improved by reducing server requests. You can reduce server requests by doing this:

• Lower the number of posts shown on a page
• Only show post excerpts, no full posts on your archive pages (find the option under Settings > Reading)
• Split longer posts into pages
• If you get a lot of comments, break them up into several pages (Settings > Discussion)
• Reduce the number of images and other elements on your page
• Uninstall unnecessary plugins, especially slower ones (find them with this plugin)
• Deactivate plugins you are not using permanently
• Enable lazy loading to delay loading images until they are actually visible on the page
• Reduce external resources such as fonts if they aren’t necessary

2) Getting rid of a thousand separator works only for Integers, while Float can be customized as You already did in the main wpDataTables settings. What other formatting do You have in mind when You say there is too much trouble to format tables and charts?

3) Problem is that blank space doesn't have value and because of that it need some workarounds  to make sorting and filtering working. It can be done as custom solution with hook for float column type -  wpdatatables_filter_float_cell but it will break sorting and probably number range filter. 

You can open a refund request at https://codecanyon.net/refund_requests/new but please note that this is not something that refund can be given.

Thank you for understanding.