Page 1 of 1

Problem related to decimal grouping when exporting from table to Excel

Posted: Thu Sep 26, 2019 12:19 pm
by Ralf40670
Hello,

when data is exported from a table object to an Excel workbook,
decimal grouping signs get exported as part of the values.

In example:
Decimal grouping character is: .

Value displayed in table is 12.300,44.
Value exported to Excel should be 12300,44.
Value exported to Excel is actually 12.300,44.

The decimal grouping symbol must not be exported to Excel,
because it prevents Excel from using the value correctly in formulas.

I have attached a MRT file which demonstrates that behavior.
The attached Excel file shows how values are exported to Excel and how
they should be exported.

Regards
Ralf

Re: Problem related to decimal grouping when exporting from table to Excel

Posted: Fri Sep 27, 2019 6:38 am
by HighAley
Hello, Ralf.

We have reproduced the issue.
Our developers need some time to find a solution for you.

Thank you.

Ticket reference: #1003

Re: Problem related to decimal grouping when exporting from table to Excel

Posted: Tue Oct 01, 2019 10:06 am
by HighAley
Hello, Ralf.

We have made an improvement.
Please, check our next build.
It will be available this week.

Thank you.

Re: Problem related to decimal grouping when exporting from table to Excel

Posted: Wed Nov 13, 2019 1:27 pm
by Ralf40670
This is working in Version 2019.4.1.

Re: Problem related to decimal grouping when exporting from table to Excel

Posted: Thu Nov 14, 2019 6:41 am
by Andrew
Okay, great! Thank you for your reply. Closing this issue.

Have a nice day!