Format issue with Data Export to Excel

More
8 years 1 week ago #13656 by julian.wallasch
Hi,

I'm using version 5.3.1.13 of ATE.
I noticed an issue with Data Export to Excel: Numbers are formatted as text. So I can't use the sum function for them.
I can change the format to number in the Excel Document after the export. If I do so, the sum function works.
Is it possible, that numbers are formatted as numbers during export?

Best Regards

Julian

Please Log in or Create an account to join the conversation.

More
8 years 1 week ago #13657 by Peter.Jonson
We depend here on the third party and they are not very fast fixing their problems.
So this will take a while

Peter Jonson
ETL Developer

Please Log in or Create an account to join the conversation.

More
8 years 1 week ago #13683 by admin
Can you try latest version please

Mike
ETL Architect
The following user(s) said Thank You: julian.wallasch

Please Log in or Create an account to join the conversation.

More
8 years 1 week ago #13689 by julian.wallasch
It works.
Thank you.

Best Regards

Julian

Please Log in or Create an account to join the conversation.

More
7 years 9 months ago #14087 by julian.wallasch
Hi,

I'm using version 5.3.1.20 now.
The Export of tables works fine.
But a user noticed that the issue still exists for the Export of reports to Excel: Numbers are formatted as text.
Can you please fix this, too? Thank you.

Best Regards

Julian

Please Log in or Create an account to join the conversation.

More
7 years 9 months ago #14088 by admin
Please set kind to numeric and define format

Mike
ETL Architect
Attachments:

Please Log in or Create an account to join the conversation.