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

Wrap text within Excel cell in exported Excel workbook via Publishing (RPE)

Questions
Tags
Users
Badges
Bob 3
(153●21●70) Mar 14 '22, 5:06 p.m.

Is it possible to tell Excel to wrap the text within a cell in an exported Excel workbook via Publishing?

When I publish lengthy text to Excel cells, the data is published, but often is visually truncated by the width of the column in which the cell resides. 
Running version 7.0.2.
Thanks!

0 votes

2 answers
1,220 views
0 votes

2 answers

Permanent link
Subramanya Prasad Pilar
(4.6k●1●6) Mar 15 '22, 3:20 a.m.

 Did you try setting "Wrap text" property for Excel output?

1 vote

Permanent link
Bob 3
(153●21●70) Mar 15 '22, 5:09 p.m.

Prasad, thank you for pointing out the global "wrap text" property for Excel output formats! This sets every cell to wrap text. 

What I was looking for was the ability to specify for a particular cell or range of cells that they should wrap text.
Is that possible?

0 votes

Comments
Subramanya Prasad Pilar
Mar 16 '22, 1:16 a.m.

 No, you cannot do that through RPE as it is specific to Excel output. Currently there is no property to wrap text which can be applied at template element level.

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
× 12,025

Question asked: Mar 14 '22, 5:06 p.m.

Question was seen: 1,220 times

Last updated: Mar 16 '22, 1:16 a.m.

Confirmation Cancel Confirm