1 files changed, 20 insertions, 17 deletions
diff --git a/ecomp-sdk/epsdk-analytics/src/main/java/org/onap/portalsdk/analytics/model/ReportHandler.java b/ecomp-sdk/epsdk-analytics/src/main/java/org/onap/portalsdk/analytics/model/ReportHandler.java
index d8dd9304..b8f3284c 100644
--- a/ecomp-sdk/epsdk-analytics/src/main/java/org/onap/portalsdk/analytics/model/ReportHandler.java
+++ b/ecomp-sdk/epsdk-analytics/src/main/java/org/onap/portalsdk/analytics/model/ReportHandler.java
@@ -214,30 +214,30 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
 
         XSSFCellStyle styleRed = wb.createCellStyle();
         styleRed.cloneStyleFrom(styleDefault);
-        styleRed.setFillForegroundColor((short) HSSFColor.RED.index);
+        styleRed.setFillForegroundColor((short) HSSFColor.HSSFColorPredefined.RED.getIndex());
         styleRed.setFillPattern(fillPattern.SOLID_FOREGROUND);
         XSSFFont fontRed = wb.createFont();
-        fontRed.setColor((short) HSSFColor.WHITE.index);
+        fontRed.setColor((short) HSSFColor.HSSFColorPredefined.WHITE.getIndex());
         fontRed.setFontHeight((short) (FONT_SIZE / 0.05));
         fontRed.setFontName(FONT_TAHOMA);
         styleRed.setFont(fontRed);
 
         XSSFCellStyle styleYellow = wb.createCellStyle();
         styleYellow.cloneStyleFrom(styleDefault);
-        styleYellow.setFillForegroundColor((short) HSSFColor.YELLOW.index);
+        styleYellow.setFillForegroundColor((short) HSSFColor.HSSFColorPredefined.YELLOW.getIndex());
         styleYellow.setFillPattern(fillPattern.SOLID_FOREGROUND);
         XSSFFont fontYellow = wb.createFont();
-        fontYellow.setColor((short) HSSFColor.BLACK.index);
+        fontYellow.setColor((short) HSSFColor.HSSFColorPredefined.BLACK.getIndex());
         fontYellow.setFontHeight((short) (FONT_SIZE / 0.05));
         fontYellow.setFontName(FONT_TAHOMA);
         styleYellow.setFont(fontYellow);
 
         XSSFCellStyle styleGreen = wb.createCellStyle();
         styleGreen.cloneStyleFrom(styleDefault);
-        styleGreen.setFillForegroundColor((short) HSSFColor.GREEN.index);
+        styleGreen.setFillForegroundColor((short) HSSFColor.HSSFColorPredefined.GREEN.getIndex());
         styleGreen.setFillPattern(fillPattern.SOLID_FOREGROUND);
         XSSFFont fontGreen = wb.createFont();
-        fontGreen.setColor((short) HSSFColor.WHITE.index);
+        fontGreen.setColor((short) HSSFColor.HSSFColorPredefined.WHITE.getIndex());
         fontGreen.setFontHeight((short) (FONT_SIZE / 0.05));
         fontGreen.setFontName(FONT_TAHOMA);
         styleGreen.setFont(fontGreen);
@@ -332,7 +332,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         short s1 = 0;
         short s2 = (short) 1;
         XSSFCellStyle styleName = wb.createCellStyle();
-        styleName.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
+        styleName.setFillForegroundColor(HSSFColor.HSSFColorPredefined.GREY_25_PERCENT.getIndex());
         styleName.setAlignment(HorizontalAlignment.CENTER);
         styleName.setBorderBottom(BorderStyle.THIN);
         styleName.setBorderTop(BorderStyle.THIN);
@@ -342,7 +342,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         XSSFFont font = wb.createFont();
         font.setFontHeight((short) (FONT_SIZE / 0.05));
         font.setFontName(FONT_TAHOMA);
-        font.setColor(HSSFColor.BLACK.index);
+        font.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
         font.setBold(true);
         styleName.setFont(font);
 
@@ -368,7 +368,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         XSSFFont fontDescr = wb.createFont();
         fontDescr.setFontHeight((short) (FONT_SIZE / 0.05)); // 14
         fontDescr.setFontName(FONT_TAHOMA);
-        fontDescr.setColor(HSSFColor.BLACK.index);
+        fontDescr.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
         fontDescr.setBold(true);
         styleDescription.setFont(font);
         XSSFCell cellDescr = null;
@@ -521,7 +521,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         XSSFCellStyle styleDate = wb.createCellStyle();
         HtmlStripper strip = new HtmlStripper();
         XSSFCellStyle styleDataHeader = wb.createCellStyle();
-        styleDataHeader.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
+        styleDataHeader.setFillForegroundColor(HSSFColor.HSSFColorPredefined.GREY_25_PERCENT.getIndex());
         styleDataHeader.setFillPattern(fillPattern.SOLID_FOREGROUND);
         styleDataHeader.setAlignment(HorizontalAlignment.CENTER);
         styleDataHeader.setBorderBottom(BorderStyle.THIN);
@@ -532,7 +532,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         font.setFontHeight((short) (FONT_SIZE / 0.05));
         font.setFontName(FONT_TAHOMA);
         font.setBold(true);
-        font.setColor(HSSFColor.BLACK.index);
+        font.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
         styleDataHeader.setFont(font);
         boolean firstPass = true;
         ArrayList cellWidth = new ArrayList();
@@ -2100,7 +2100,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         XSSFFont font = wb.createFont();
         font.setFontHeight((short) (FONT_HEADER_TITLE_SIZE / 0.05)); // 14
         font.setFontName(FONT_TAHOMA);
-        font.setColor(HSSFColor.BLACK.index);
+        font.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
         styleHeader.setFont(font);
 
         XSSFCell cell = row.createCell((short) 0);
@@ -2118,7 +2118,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
             XSSFFont fontDescr = wb.createFont();
             fontDescr.setFontHeight((short) FONT_HEADER_DESCR_SIZE);
             fontDescr.setFontName(FONT_TAHOMA);
-            fontDescr.setColor(HSSFColor.BLACK.index);
+            fontDescr.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
             styleDescription.setFont(fontDescr);
             XSSFCell cellDescr = row.createCell((short) 0);
             cellDescr.setCellValue(reportDescr);
@@ -2135,7 +2135,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
             XSSFFont fontDescr = wb.createFont();
             fontDescr.setFontHeight((short) (FONT_SIZE / 0.05)); // 14
             fontDescr.setFontName(FONT_TAHOMA);
-            fontDescr.setColor(HSSFColor.BLACK.index);
+            fontDescr.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
             fontDescr.setBold(true);
             styleDescription.setFont(fontDescr);
             XSSFCell cellDescr = row.createCell((short) 0);
@@ -2416,7 +2416,10 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
                 paintExcelParams(wb, rowNum, col, paramsList, rr.getFormFieldComments(request), sheet, reportTitle,
                         reportDescr);
             } // if
+            
             rowNum = sheet.getLastRowNum();
+            if(rowNum<0)
+            	rowNum = 0;
 
             final String formattedReportName = new HtmlStripper().stripSpecialCharacters(rr.getReportName());
             final String formattedDate = new SimpleDateFormat("MMddyyyyHHmm").format(new Date());
@@ -5088,7 +5091,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         HtmlStripper strip = new HtmlStripper();
         // Name Style
         HSSFCellStyle styleName = wb.createCellStyle();
-        styleName.setFillForegroundColor(HSSFColor.GREY_25_PERCENT.index);
+        styleName.setFillForegroundColor(HSSFColor.HSSFColorPredefined.GREY_25_PERCENT.getIndex());
         styleName.setAlignment(HorizontalAlignment.CENTER);
         styleName.setBorderBottom(BorderStyle.THIN);
         styleName.setBorderTop(BorderStyle.THIN);
@@ -5098,7 +5101,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         HSSFFont font = wb.createFont();
         font.setFontHeight((short) (FONT_SIZE / 0.05));
         font.setFontName(FONT_TAHOMA);
-        font.setColor(HSSFColor.BLACK.index);
+        font.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
         font.setBold(font.getBold());
         styleName.setFont(font);
         // Data Style
@@ -5131,7 +5134,7 @@ public class ReportHandler extends org.onap.portalsdk.analytics.RaptorObject {
         HSSFFont fontDescr = wb.createFont();
         fontDescr.setFontHeight((short) (FONT_HEADER_DESCR_SIZE / 0.05));
         fontDescr.setFontName(FONT_TAHOMA);
-        fontDescr.setColor(HSSFColor.BLACK.index);
+        fontDescr.setColor(HSSFColor.HSSFColorPredefined.BLACK.getIndex());
         fontDescr.setBold(true);
         styleDescription.setFont(font);
         XSSFCell cellDescr = null;