HTML tags when exporting to Excel

[Ricardo Cifres]

I have installed the Last Comment pluguin and works fine, but, when exporting to Excel, it shows the <p></p> HTML tags surrounding the comment.

Is it possible to suppress those tags?

[William Crighton [CCC] · Accepted solution]

would anyone like to close this thread now? this problem has been resolved since early march.

Thanks

-wc

[William Crighton [CCC]]

Thanks for coming back and marking the question answered - this one was a pain to get resolved, took time and we pissed off a few people but in the end the Addon is much more solid and well managed. -wc

[William Crighton [CCC]]

It would depend on what version of the plugin you are using. The later versions have the option to render the last comment excerpt using the plain text renderer which strips out the HTML tags.

We have a request to enhance the plugin such that it always uses the plain text renderer when ...er... rendering itself for excel exports. You can vote on the issue here: https://capitalplugins.atlassian.net/browse/LCCF-27

Thanks,

-wc

Capital City Consultants

[William Crighton [CCC]]

Ok - we will have a release out this week that provides the ability to specify the renderer when exporting to excel. Selecting 'Plain Text' for the export will remove all HTML tags from the last comment field (as long as they weren't explicitly added when the comment was made - i.e. if you enter <b> my comment </b> as a comment then the tags won't get removed)

-wc

[William Crighton [CCC]]

well, the new code worked fine but the old code just didn't like it much and the whole thing causes your JIRA server to be unable to create new issues....so, we've gone back to our Quality department and done a bit of rearrangement which should result in a working version out next week.

[William Crighton [CCC]]

A few days ago we release CCC Last Comment v3.0.0 which is stable with version JIRA 6+ and provides the requested functionality.

[Christian Czaia [Decadis AG]]

Hey, I guess not. I had the same issue and ended up writing VBA scripts doing the job in Excel... http://stackoverflow.com/questions/4649693/excel-macro-to-convert-html-entities-to-text

[Arpit Doshi]

Hi, 

we are using a similar free plugin which is available and facing same issue.

https://marketplace.atlassian.com/plugins/np.com.ck.jira.plugins.rcomment#tabs-support

Anyway to resolve this issue.

Thanks !!