| T O P I C R E V I E W |
| csrite |
Posted - 01/05/2012 : 12:47:23
I'm having a problem with exporting data to Excel or CSV. I have a text column in my report with data in the format "1-11" as an example. If the number before the hyphen is something that could be a month, the data is being formatted as a date. If I have the text field "1-11", it exports as "11-Jan". If I have the text field "1-32", it exports as "Jan-32". If I have the text field "13-11", it exports correctly as "13-11". Is there a way I can get all values to export as text? |
| 5 L A T E S T R E P L I E S (Newest First) |
| admin |
Posted - 01/06/2012 : 22:28:29
Thanks.
To get a hot fix for Excel date exporting, please contact support@ReportPortal.com.
There is nothing that can be done about CVS exporting. Excel formats date data for all CSV files automatically. |
| csrite |
Posted - 01/06/2012 : 08:10:11
It is a SQL report, and it is cell data.
Switch PullDate PM_Type MGW_ID TrkQty NumMem
XXXYZ 1/5/2012 20:02 MGW 11-Jan 24 24
XXXYZ 1/5/2012 20:02 MGW Jan-32 24 24
XXXYZ 1/5/2012 20:02 MGW 13-10 24 24
The column in question is MGW_ID. When I run the report through the web interface, the values show correctly as "1-11", "1-32", and "13-10". When I export to Excel, some of the values get changed to dates. |
| admin |
Posted - 01/05/2012 : 19:54:16
Can you please be more specific? Is this for OLAP or SQL report? Is this for row header of for cell data? |
| csrite |
Posted - 01/05/2012 : 16:02:48
It isn't supposed to be a date. It's just supposed to be regular text. It shouldn't have any date formatting. |
| admin |
Posted - 01/05/2012 : 15:50:03
Does this problem go away when you apply the appropriate Date formatting to the data column?
http://spreadsheets.about.com/od/excelformatting/ss/number_format_5.htm |
Report Portal
