Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

[SOLVED] Excel expo...
 
Notifications
Clear all

[SOLVED] Excel export

6 Posts
2 Users
0 Reactions
3,606 Views
(@optimist)
Posts: 17
Active Member
Topic starter
 
[#4841]

Hi,

While exporting any data (tickets, activities, testcases, requirement....) the report doesn't comes in proper tabular format. Though it is being converted to text form from CSV format.
Also, if I deselect the lengthy texts i.e. description and result from the export option, the data fetched is in proper format.

Let me know what we can do fix this.


 
Posted : 13 Dec 2017 13H48
(@babynus)
Posts: 14952
Member Admin
 

Can you please show or post examples ?


 
Posted : 13 Dec 2017 13H56
(@optimist)
Posts: 17
Active Member
Topic starter
 

Attached is the exported excel for reference.

Sheet 1 : Data exported
Sheet 2 : After converting data to text


 
Posted : 13 Dec 2017 14H18
(@optimist)
Posts: 17
Active Member
Topic starter
 

PFA


 
Posted : 13 Dec 2017 14H19
(@babynus)
Posts: 14952
Member Admin
 

It is because CVS serparator character is not correct.
It is set to ";".
Change it to "," in global parameters...


 
Posted : 13 Dec 2017 16H08
(@optimist)
Posts: 17
Active Member
Topic starter
 

Yeah! you were right. Thanks a lot.


 
Posted : 13 Dec 2017 16H22
Share:

Scroll to Top