[TIME-191] Excel creates multiple rows from worklog comments in Project Pivot Report
Hi. The report generated for Excel from Project Pivot Report and Timesheet Report doesn't contain "<style>br {mso-data-placement:same-cell;}</style>" so that Excel will not split the Worklog comments into multiple cells based on the number of "<br>"s.
Where can I add this so that the report shows correctly in Excel?
For the Jira internal plugins this works fine and I found a .vm where the header of the generated html contains that style, but for Timesheet I couldn't find where to add it.
Some relevant discussions: issue #7598 "[JRA-7598]", issue #7554 "[JRA-7554]".
By adrian.fita/Adrian Fita on Tue, 1 Nov 2011 06:15:49 -0700
Comments (5)
-
reporter -
reporter Hi. Sorry, but those files don't contain the "<head>" of the report. I extracted the files from the plugin's jar and recursively grepped all of them and couldn't find any "head".
By adrian.fita on Mon, 14 Nov 2011 23:56:42 -0800
-
reporter Right, the only way is to add style right in the body, see timesheetportlet/timesheet-portlet.vm for example, it works in modern browsers, but I don't know if it works in excel :-\
By azhdanov on Wed, 16 Nov 2011 02:12:40 -0800
-
reporter Well, isn't there a way to add <head> to the templates so we can cleanly add the <style> needed for Excel? Maybe change the code a little?
By adrian.fita on Wed, 16 Nov 2011 02:14:53 -0800
-
reporter I don't know any.
By azhdanov on Wed, 16 Nov 2011 14:08:18 -0800
- Log in to comment
Hi, sorry for silence, please see *-report-excel.vm in templates/timesheetreport and templates/pivotreport. Please checkin the fix, or send me diffs to add the fix for future.
Thank you.
By azhdanov on Fri, 11 Nov 2011 14:22:58 -0800