[TIME-285] Time Sheet Report excel extract does not work
Issue #285
invalid
When using the excel link i do not get an excelfile but a jpsa file called ConfigureReport!excelView.jspa.
The file contains html:
<html>
<head>
<title>Timesheet Report</title>
<meta name="decorator" content="none" />
<meta http-equiv="Content-Type" Content="application/vnd.ms-excel; charset=UTF-8" />
</head>
<body>
<table class=tableBorder border="1" cellpadding="0" cellspacing="0" width="100%"><tr><td>
<table border="1" cellpadding="3" cellspacing="1" width="100%">
<tr class=rowHeader>
<td class="colHeaderLink" width="1%"><b>Reported?</b></td>
<td class="colHeaderLink" width="1%"><b>Type</b></td>
<td class="colHeaderLink" width="1%"><b>Key</b></td>
<td class="colHeaderLink" width="50%"><b>Title</b></td>
<td align="center" width="1%"><b>Date</b></td>
<td align="center" width="1%"><b>Username</b></td>
<td align="center" width="1%"><b>Time Spent (h)</b></td>
<td align="center" width="50%"><b>Comment</b></td>
</tr>
</table>
</td></tr></table>
</body>
</html>
By cbk/Carsten Beck-Astrup on Tue, 25 Sep 2012 03:25:51 -0700
Comments (5)
-
reporter
-
reporter
What Im trying to say is, that the report shown in the attachment is not what I get in excel (see new attachment) either when opening it directly or saving and then open.
By cbk on Tue, 9 Oct 2012 06:11:15 -0700
-
reporter
Resolving it, as excel export works actually. Please open new request if the same format as html view is required.
By azhdanov on Fri, 19 Oct 2012 13:49:41 -0700
-
reporter
After upgrading to 2.3.7.1 it now works with correct hours in the excel report (equal to the hours in the html report)
By cbk on Wed, 24 Oct 2012 00:43:51 -0700
-
reporter
Hi Valerii,
I can't change anything in this concern, though you may also open it in Libre Calc.
Thank you.
- Log in to comment
This is how it works. You need not to save it, but immediately Open when you click 'Excel' link on the report. Then MS excel is able to recognize data. From other hand if you save it, try to open the file, it should work too. Note, there's nothing I can do with it.
By azhdanov on Sun, 7 Oct 2012 14:18:43 -0700