Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..
154 views

Color in Progress Bar in Portlet won't Export to Excel

Jump to solution

We are using a Progress Bar for % Complete in a custom portlet that shows Red, Yellow, or Green.  The color shows just fine in the portlet, but when we try to export to Excel all we get is a blank tab/window.  In the Portlet Definition for the field:

Column Type: Progress Bar

Color Value: Color Source (radio button) with the Red, Yellow, Green field from the SQL statement

If I remove having the Red, Yellow, or Green color for the Progress Bar, the portlet exports to Excel with no problem.

Column Type: Progress Bar

Color Value: Color Source (radio button) with nothing selected

The Red, Yellow, and Green SQL statement works fine if the Column Type is Icon.

Is there anything special for specifying color for a Progress Bar?  We are running PPM version 9.32.0002. 

 

Here is the exception from the server log file:

An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=C9FDC50F-8565-650F-A084-626544537C46  
Generated Time=2016/12/08-12:56:13.488 EST
 at com.kintana.core.server.UncaughtExceptionDefaultHandler.uncaughtException(UncaughtExceptionDefaultHandler.java:25)
 at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1057)
 at java.lang.ThreadGroup.uncaughtException(ThreadGroup.java:1052)
 at java.lang.Thread.dispatchUncaughtException(Thread.java:1952)
Caused by: java.lang.NullPointerException
 at java.lang.Integer.decode(Integer.java:1161)
 at java.awt.Color.decode(Color.java:729)
 at com.hp.ppm.html2excel.JerichoUtils.parseColor(JerichoUtils.java:36)
 at com.hp.ppm.html2excel.JerichoUtils.parseFontColor(JerichoUtils.java:40)
 at com.hp.ppm.html2excel.StreamingTransformer$13.whenText(StreamingTransformer.java:514)
 at com.hp.ppm.html2excel.StreamingTransformer.transform(StreamingTransformer.java:66)
 at com.hp.ppm.html2excel.ExcelTransformerServlet$2.run(ExcelTransformerServlet.java:52)
 at java.lang.Thread.run(Thread.java:745)
ERROR server:Thread-153:(UncaughtExceptionDefaultHandler.java:25):2016/12/08-13:00:20.402 EST: An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=0E76B115-B317-DDB8-F1F4-D2C9AF5F8940  
Generated Time=2016/12/08-13:00:20.401 EST
An unknown error has occurred. For more information, please contact your PPM administrator and provide the following GUID number:
GUID=0E76B115-B317-DDB8-F1F4-D2C9AF5F8940  
Generated Time=2016/12/08-13:00:20.401 EST
nested detail:null

Thanks

0 Likes
1 Solution

Accepted Solutions
Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..

Re: Color in Progress Bar in Portlet won't Export to Excel

Jump to solution

Problem solved.!

The root cause of the problem was that one of the values was not a color.  We were having no color if a value was -1.  Once I changed the color to 'GRAY' (for example) so that every part of the case statement returned a color, it displayed properly and successfully exported to Excel.

Thanks

0 Likes
2 Replies
Frequent Contributor.. QUYNH_BUI_PPM Frequent Contributor..
Frequent Contributor..

Re: Color in Progress Bar in Portlet won't Export to Excel

Jump to solution

Hello,

Please try to update the Color Source as below:
This now allows the portlet to be exported to excel.

SELECT 'one' ID, 75 PERC, 'Green' COLOR FROM dual
UNION ALL
SELECT 'two' id, 80 perc, 'RED' color FROM dual
UNION ALL
SELECT 'three' id, 20 perc, 'Yellow' color FROM dual
UNION ALL
SELECT 'four' id, 50 perc, 'YELLOW' color FROM dual
UNION ALL
SELECT 'five' id, 10 perc, 'RED' color FROM dual
UNION ALL
SELECT'six' id, 45 perc, 'RED' color FROM dual WHERE 1=1

Thanks,

Best regards,

0 Likes
Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..

Re: Color in Progress Bar in Portlet won't Export to Excel

Jump to solution

Problem solved.!

The root cause of the problem was that one of the values was not a color.  We were having no color if a value was -1.  Once I changed the color to 'GRAY' (for example) so that every part of the case statement returned a color, it displayed properly and successfully exported to Excel.

Thanks

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.