ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 SQL Report Export to xlsx - Date Formatted as Text

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
lfessler Posted - 04/04/2018 : 07:37:31
Version:
ReportPortal 5.0, Build 198


Issue:
I create a SQL report that contains a date field and I use the Options/Columns/Formatting to set it to a date format. I then export the report to Excel xlsx, but when I open the file in Excel the date column shows as a 'custom' type and can't easily be converted to a date field without touching each cell in the column.

I also recreated the issue on your demo server. It's saved in the admin 'My Reports' folder as 'SQL Date Export Test'.

Is it possible to have date-formatted columns export to xlsx as dates?

Thanks!
4   L A T E S T    R E P L I E S    (Newest First)
lfessler Posted - 04/10/2018 : 06:13:01
Yes, that did it! Thanks!
admin Posted - 04/09/2018 : 21:57:01
Please try this fix (also deployed on the demo server):

1. Download and zunip: http://www.reportportal.com/download/rp_198_sql_Excel_Date1.zip
2. Backup old files and copy unzipped to:
"C:\inetpub\wwwroot\ReportPortal\bin\ReportPortal.dll"
"C:\inetpub\wwwroot\ReportPortal\Excel2007\xl\styles.xml
lfessler Posted - 04/09/2018 : 14:54:08
It's strange. After the fix, the Excel file shows that it's of type 'Date', but it still does not treat the field as Date unless you double-click into each cell (or hit F2) and then press enter. After that you can see the text alignment of the cell move from the left (general cell type) over to right-aligned like a proper date. Any other ideas?
admin Posted - 04/05/2018 : 20:43:51
Please try this fix (also deployed on the demo server):

1. Download and zunip: http://www.reportportal.com/download/rp_198_sql_Excel_Date.zip
2. Backup old files and copy unzipped to:
"C:\inetpub\wwwroot\ReportPortal\bin\ReportPortal.dll"
"C:\inetpub\wwwroot\ReportPortal\Excel2007\xl\styles.xml"



ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page