Format issue with Data Export to Excel
- julian.wallasch
- Topic Author
- Offline
- Senior Member
-
Less
More
8 years 1 week ago #13656
by julian.wallasch
Format issue with Data Export to Excel was created 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
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.
- Peter.Jonson
-
- Offline
- Platinum Member
-
8 years 1 week ago #13657
by Peter.Jonson
Peter Jonson
ETL Developer
Replied by Peter.Jonson on topic Format issue with Data Export to Excel
We depend here on the third party and they are not very fast fixing their problems.
So this will take a while
So this will take a while
Peter Jonson
ETL Developer
Please Log in or Create an account to join the conversation.
8 years 1 week ago #13683
by admin
Mike
ETL Architect
Replied by admin on topic Format issue with Data Export to Excel
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.
- julian.wallasch
- Topic Author
- Offline
- Senior Member
-
8 years 1 week ago #13689
by julian.wallasch
Replied by julian.wallasch on topic Format issue with Data Export to Excel
It works.
Thank you.
Best Regards
Julian
Thank you.
Best Regards
Julian
Please Log in or Create an account to join the conversation.
- julian.wallasch
- Topic Author
- Offline
- Senior Member
-
7 years 9 months ago #14087
by julian.wallasch
Replied by julian.wallasch on topic Format issue with Data Export to Excel
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
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.
7 years 9 months ago #14088
by admin
Mike
ETL Architect
Replied by admin on topic Format issue with Data Export to Excel
Mike
ETL Architect
Please Log in or Create an account to join the conversation.