Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Developer Export feature giving strange

Ora-affSep 14 2013 — edited Sep 15 2013

I run a query  on SQL Developer which returns me 1715 rows. Then I export it into XLS format and open the file in OpenOffice Spreadsheett. In the SQL Developer, I see the following rows as:

D21211572NEW08/29/2013 07.45.21.060000000CLOSED08/29/2013 10.42.43.700000000
D21211572REOPENED08/30/2013 07.09.36.768000000CLOSED08/30/2013 10.57.51.138000000
D21211572REOPENED09/03/2013 05.41.22.568000000CLOSED09/03/2013 07.49.47.051000000
D21211572REOPENED09/03/2013 11.46.05.104000000CLOSED09/06/2013 19.26.06.618000000

Howver the same ticket D21211572 looks strange in the spreadsheet:

D21211572NEW08/29/2013 07.45.21.060000000CLOSED08/29/2013 10.42.43.700000000
D21211572NEW08/30/2013 07.09.36.768000000CLOSED08/30/2013 10.57.51.138000000
D21211572NEW09/03/2013 05.41.22.568000000CLOSED09/03/2013 07.49.47.051000000
D21211572NEW09/03/2013 11.46.05.104000000CLOSED09/06/2013 19.26.06.618000000

REOPENED is replaced with NEW in the spreadsheet. 

I am using Oracle XE 11g.

The  SQL Developer version is :

Java(TM) Platform1.6.0_35
Oracle IDE3.2.20.09.87
Versioning Support3.2.20.09.87

My Query is:

select  ticket_id, ticket_status, created_date, closed_status, closed_date

from(

select  ticket_id, ticket_status, created_date, lead(ticket_status) over (partition by ticket_id order by created_date) as closed_status, lead(created_date) over (partition by ticket_id order by created_date) as closed_date

from cc_ticket_status_history h

WHERE ticket_status in ('NEW', 'REOPENED', 'CLOSED')

) b

where ticket_status != 'CLOSED' and closed_status = 'CLOSED';

Not Sure what is wrong here??

Comments

thatJeffSmith-Oracle

If you export the same data/query to another format like CSV, is the data integrity maintained there? Just trying to localize this to JUST XLS exports or a bigger problem in general.

Ora-aff

I just checked and found that the report is exported correctly in the XLS and CSV, it is only when I convert .xls into OpenOffice Spreadsheet, the data integrity is lost.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 13 2013
Added on Sep 14 2013
2 comments
175 views