Format is changed by excel export
- KlausJVoigt
- Topic Author
- Offline
- Senior Member
-
Less
More
11 years 1 week ago #5600
by KlausJVoigt
Format is changed by excel export was created by KlausJVoigt
Hi,
if i perform a export to excel (Export Grid or Export data into Excel) in version 5.1.0.0 the format of data is changed to numeric if the content look like a numeric value. So alpha value '001010' transformed to 1010.
The format of the source is ignored. This is different from earlier versions.
I need the correct formatting in exports urgently and hope a correction will be available soon.
Thanks in advance.
Klaus
if i perform a export to excel (Export Grid or Export data into Excel) in version 5.1.0.0 the format of data is changed to numeric if the content look like a numeric value. So alpha value '001010' transformed to 1010.
The format of the source is ignored. This is different from earlier versions.
I need the correct formatting in exports urgently and hope a correction will be available soon.
Thanks in advance.
Klaus
Please Log in or Create an account to join the conversation.
11 years 1 week ago #5601
by admin
Mike
ETL Architect
Replied by admin on topic Re: Format is changed by excel export
We would need to contact third party regarding this issue.
This will take a while.
Peter
This will take a while.
Peter
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
11 years 1 day ago #5621
by admin
Mike
ETL Architect
Replied by admin on topic Re: Format is changed by excel export
Can you try latest version please
Mike
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- KlausJVoigt
- Topic Author
- Offline
- Senior Member
-
11 years 1 day ago #5623
by KlausJVoigt
Replied by KlausJVoigt on topic Re: Format is changed by excel export
Hi,
i test version 5.1.0.1.
The content is not changed now. That is ok.
But the format of the Excel cells are not alike.
This is uncommon for an Excel export.
It would be appropriate to deal with the formatting of the cells uniformly.
Please have a look at the attachment to better understand my concern.
Klaus
i test version 5.1.0.1.
The content is not changed now. That is ok.
But the format of the Excel cells are not alike.
This is uncommon for an Excel export.
It would be appropriate to deal with the formatting of the cells uniformly.
Please have a look at the attachment to better understand my concern.
Klaus
Please Log in or Create an account to join the conversation.
11 years 21 hours ago #5625
by admin
Mike
ETL Architect
Replied by admin on topic Re: Format is changed by excel export
Can you try latest version please
Mike
Mike
Mike
ETL Architect
Please Log in or Create an account to join the conversation.
- KlausJVoigt
- Topic Author
- Offline
- Senior Member
-
10 years 11 months ago #5632
by KlausJVoigt
Replied by KlausJVoigt on topic Re: Format is changed by excel export
Hi Mike,
i test version 5.1.0.2
now the excel export works the way it should be.
Thank you for your support.
Klaus
i test version 5.1.0.2
now the excel export works the way it should be.

Thank you for your support.
Klaus
Please Log in or Create an account to join the conversation.