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
Problem related to decimal grouping when exporting from table to Excel
Problem related to decimal grouping when exporting from table to Excel
- Attachments
-
- DecimalGrouping.xlsx
- (34.86 KiB) Downloaded 158 times
-
- DB009ExcelExportDecimalGrouping.mrt
- (149.88 KiB) Downloaded 154 times
Re: Problem related to decimal grouping when exporting from table to Excel
Hello, Ralf.
We have reproduced the issue.
Our developers need some time to find a solution for you.
Thank you.
Ticket reference: #1003
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
Hello, Ralf.
We have made an improvement.
Please, check our next build.
It will be available this week.
Thank you.
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
This is working in Version 2019.4.1.
Re: Problem related to decimal grouping when exporting from table to Excel
Okay, great! Thank you for your reply. Closing this issue.
Have a nice day!
Have a nice day!