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

Control conditional formatting in an Excel worksheet's cell from Publishing (RPE)

Questions
Tags
Users
Badges
Bob 3
(153●20●70) Mar 14 '22, 4:47 p.m.

Is it possible to control conditional formatting in an Excel worksheet's cell from Publishing?

Using version 7.0.2.

My goal is to apply conditional formatting that fills the cell with color (from the left) according to the % value in the cell. For a value of 100%, the cell would be completely filled from the left, whereas for a value of 50%, the cell would be halfway filled from the left. This functionality is available in the native Excel UI, but does not seem to be controllable from Publishing.

Thanks!

0 votes

2 answers
1,029 views
0 votes

Accepted answer

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

 Though conditional formatting is supported in RPE, data bars (specific to Excel, which you are looking for) cannot be created through RPE. You can open the generated Excel output and manually select the column and choose Conditional Formatting->Data Bars->Solid Fill/Gradient Fill. If you are using RPE/PUB 7.0.3, you can achieve the same using a post processing Excel macro.

Bob 3 selected this answer as the correct answer

1 vote

One other answer

Permanent link
Fariz Saracevic
FORUM MODERATOR / JAZZ DEVELOPER (919●6●13) Mar 14 '22, 5:49 p.m.

Hi Bob,


This would be possible with PUB MS Excel support coming in 7.0.3. For now, you can try is using PUB 7.0.3 M6 milestone https://jazz.net/downloads/elo-publishing/milestones/7.0.3M6?p=news.

Regards,

1 vote

Comments
Bob 3
Mar 16 '22, 6:15 p.m.

Thank you for your continued advancement of the Publishing product, Fariz. And thank you for letting me know about milestone 6 where I can test these features! 

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,019

Question asked: Mar 14 '22, 4:47 p.m.

Question was seen: 1,029 times

Last updated: Mar 16 '22, 6:15 p.m.

Confirmation Cancel Confirm