Hi Andrea,

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.

-

As I mention on your other/original ticket, it seems they are both about the same issue, the exported report from the table data source is not as you expect/intend it, if I understood?

If that is the case, let's please focus on this ticket and we can close the old one, if you agree.

I am not sure if we fully understand all the details of your use-case, what you are trying to achieve compared to how the report result happens.

We will need to see more details, how are these entries looking when they come from the Form itself;

- How is our table rendering them, are the SUM calculations working in the Table itself - they are just not exported correctly on the Report?

-

So if you can please show me more screenshots, a couple of screenshots how does this data look, what is the field type in the Form itself;

How is our Plugin rendering it, is it a String or numeric type in the Table's column;

Is it correctly calculating the SUM in the table

- and if you can confirm which column to focus on, it seems it is the "Total" column, the SUM row giving zero in that row?

Then when you show us more details, we can remote in and check your setup from our end to try and debug the issue.

Please provide me a WP-admin (administrator) user for your website 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 parties. 

You can write credentials here just check PRIVATE Reply so nobody can see them except us.

And please confirm the Report ID.

Thank you.

Hi Andrea,

It seems we might have an issue when using the European Number Format with comma as the decimal separator.

We don't have any issue with the US Number Format like that.

Here are more details :

1. For example, if I change your Number Format in the Plugin settings to US Format, with the dot as decimal separator, in that case, the exported Report is correctly doing your SUM Excel formula on the cells :

This is how my LibreOfficeCalc shows when i right click to check what is the current Number Format set on your "TOTALI"/SUM row in the Excel template :

The English (United States) is the default Number Format for all Excel numeric cells, as far as I can see, looking from the LibreOfficeCalc program.

And you can visually see these SUM cells have a dot for the decimal separator, on your Excel template for the Report.

2. Now, if I try to manually somehow 'force' this Excel template to change its Number Format on all numeric cells, including these SUM calculated cells, and revert your Plugin Number Format to European;

it visually shows that it changes it, but the calculations are not working in that case.

Here is a screenshot of how I set up the format on these numeric cells of a copy from your Excel Template :

But, in this case, the calculations are not working.

I am not sure if this could be a bug from our Report Builder and wpDataTables, or if this could be an issue from the JQuery DataTables library that our Plugin is based upon ( because we do have an issue on Excel export via Table Tools for European Number Format);

I will send this to our QA Team, they will do more tests, but for the time being, for some reason, the European Number Format is not properly doing the SUM calculations in the exported Excel from our Report Builder.

I can't promise an ETA when we will isolate and fix this issue; but as soon as we get some news on it, I will let you know.

Can you maybe try switching to the US Number Format ( dot as decimal separator) as a temporary solution, or do you have to use the European Format (comma decimal separator)?

Thank you.

Hello again,

Just a follow up to this issue.

I am happy to report, we actually have a better, built-in solution to avoid using the Excel formulas, you can instead use our Report Builder's native functionality to add a total to your column(s).

As we pointed out in this Documentation about Excel templates, all you have to do is simply insert this in any cell where you wish to render the total/sum of your column : ${mycolumn.total}.

Here are my example test screenshots with more details.

For example, let's say I have a table with a 'sum' column looking like this :

And my Excel template will be like this :

Here is how the Report will look exported :

As you can see, with our own built-in functionality of the "total", the Report Builder will take into account all the Float values including the ones having a thousand separator.

I can confirm this works for both Float Number Formats, the EU ( comma decimal separator) and US ( dot decimal separator) without any issues.

Here is a screenshot with EU Float Number Format and how it works :

Our Support does not cover any issue with Excel Formulas and our Plugin does not work with Excel Formulas in general;

but this should be a solution, to simply switch to using our own built-in Report Builder 'total calculation' feature.

Let me know how it goes and if you have any questions.

Thank you.