Export to Excel Issue with Date field in DS 1.5 ?

[Former Member]

Hi DS Experts!

I face a problem in exporting a crosstab to excel in Design Studio 1.5 .

My cross tab looks like

I use a button in which I have used the following script

APPLICATION.export(ExportType.EXCEL_xlsx,CROSSTAB_1);

The exported Excel file looks like

the date colum shows value like 1/1/00

Does any one encountered this problem ?

Thanks in Advance for your replies .

[TammyPowlas · Accepted solution]

Hi Karthik - I could replicate this - this is definitely a bug.  Please open an incident/message with SAP Support on this.  Good catch.

Tammy

[Former Member]

Hi,

It is still not fixed in DS 1.6 SP01. Anybody knows the workaround or maybe if is it going to be fixed in upcoming releases?

Thanks,

Himanshu

[former_member278800]

Hi Karthik,

I've already opened an incident "Design Studio export to xlsx (440520/2015)". According to SAP developer this issue is fixed in V1.5 SP1.

Regards,

Zhijian

[Former Member]

Thanks for the update Zhijian Ni

[former_member182373]

Hi,

Anyone know if this is fixed in DS 1.6 ?

Im on 15.0.6 and it still doesn't work.

Thanks

Tony

[Former Member]

Hi Karthik

  I have a similar situation i  am currently using 1.5 version . export formatting was working fine in 1.4 version where as 1.5 the formatting has been changed

Output after exporting to excel

In design studio application