desktop-vs
Defect ID DVS166: Column ordering issue while exporting tracker data into Excel

Print | Print with history | Copy | View history
ID Type Last date/time modified Date/time created Created by
DVS166 Defect 2010-03-15 23:49:57 PDT 2010-01-07 07:49:51 PST Pallavi Rastogi (pallavi_capgemini)

Top Duplicate check info

Summary Column ordering issue while exporting tracker data into Excel
Component Common
Operating system All
Platform All
Subcomponent desktop-ms

Top Additional descriptive info

Description The users are ordering the columns in the desktop expecting the order to be the same in the downloaded excel file. The order of the columns is however not the same and is completely random.

Is it possible to to specify the column order on exported files?
Version current
Severity Medium

Top Tracking info

Status Completed
Priority P3
Target release [VS] *undecided*
Target release [MS] ms2.1

Top User attributes

Assigned to
Username Name
baybora Baybora Aksoy
CC
Username Name
karthikeyan_ct (disabled) karthikeyan c thankappan
markphip Mark Phippard
prabhugs (disabled) Prabhu Gandhiraman Sarathy
rajeswari rajeswari kannan

Top Attachments (0)

Top Related links (0)

Top Related artifacts (0)

Top Comments (4)

2010-03-15 23:49:57 PDT | Added by: Prabhu Gandhiraman Sarathy

Box: http://cu003.cubit.sp.collab.net/   [admin/admin]
Version: 5.3.0.0.308
Windows desktop version: 2.0.12.0

Steps:
======

1. Added CTF site on windows desktop.
2. Created few artifacts. [Please include user defined flex fields and Reported in Release and Fixed in Release fields].
3. Create a tracker specific query and save it.
4. Add this query to favorites page.
5. Try to sort by artifact id /priority/planned for etc [i have checked for fields].

Then export to excel or CVS.

As a result all artifacts are arranged based on sorting.
Verified this issue.

2010-03-15 02:09:07 PDT | Added by: Prabhu Gandhiraman Sarathy

I will verify this issue once DVS185 got fixed.

2010-01-07 08:37:27 PST | Added by: Baybora Aksoy

I have fixed the code so that the customized column order is preserved on table export. This will be available in versions >2.0.8.

2010-01-07 08:29:10 PST | Added by: Baybora Aksoy

Automated Comment. Version control commit message.
Revision: 2099
http://desktop-vs.open.collab.net/source/browse/desktop-vs?view=rev&revision=2099&pathrev=2099

preserve customized column order on table export.

DVS166 - Column ordering issue while exporting tracker data into Excel


Modified
File: branches/desktop-ms/CollabNet.Desktop.EE/Favorites/QueryResultControl.cs

Direct link to DVS166 | Top