Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

JRS spits out HTML codes in Excel export

Questions
Tags
Users
Badges
Max K
(15●3) Mar 20 '24, 8:43 p.m.

Hi, just wondering if someone has come across this minor but annoying issue and can suggest a solution - when a JRS report (on requirements) is exported to Excel, the output spreadsheet contains HTML codes like &quot; &amp; &lt; instead of the actual symbols like " & <


The report itself shows these symbols correctly, but in the spreadsheet they are replaced with codes. The issue relates to a custom text attribute.

Any suggestions would be appreciated.

0 votes

Comments
Fariz Saracevic
FORUM MODERATOR / JAZZ DEVELOPER Mar 21 '24, 3:27 a.m.

Hi Max,


Please open IBM support case to review your data about the above findings.

1 answer
508 views
0 votes

Accepted answer

Permanent link
Davyd Norris
(3.0k●2●17) Mar 21 '24, 6:10 p.m.
Given this is in a custom text attribute, I'd be interested to see if this still happened after you edited it.

Can you pick one of the records and make a note of it, then edit the text attribute and delete and re-add the ampersand (or whatever character is exporting weirdly) and save, and then see if that record exports correctly? My thinking is that maybe the HTML version was inserted via import or copy/paste, and your browser is masking the fact by rendering it on the screen as just an ampersand when you look at it in the UI or Report Builder.

Custom text attributes are just plain text but Primary Text is Rich Text - DNG knows to convert the contents of Primary Text when exporting, but would likely not check an attribute that's meant to be plain text
Max K selected this answer as the correct answer

0 votes

Comments
Max K
Mar 27 '24, 6:44 p.m.

Thanks Davyd, this sounds like a good suggestion. Unfortunately I currently don't have access to the environment to try as I asked the question based on the screenshots I was provided. I am getting the client to organise access for me now and will try this when I can. But I think it's either your scenario or an IBM issue as suggested by Fariz.

Davyd Norris
Mar 27 '24, 9:28 p.m.

I actually had this exact situation the other day where a text field contained a long hyphen and it came out as a code in the Excel sheet, so it is possible this may be the problem

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Ask a question
Guidelines
FAQ
Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 360
× 112
× 74
× 64
× 16
× 1

Question asked: Mar 20 '24, 8:43 p.m.

Question was seen: 508 times

Last updated: Mar 27 '24, 9:28 p.m.

Confirmation Cancel Confirm