Index: lams_build/lib/lams/lams.jar =================================================================== RCS file: /usr/local/cvsroot/lams_build/lib/lams/lams.jar,v diff -u -r1.420.2.99 -r1.420.2.100 Binary files differ Index: lams_common/src/java/org/lamsfoundation/lams/util/ExcelCell.java =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/util/ExcelCell.java,v diff -u -r1.3.2.2 -r1.3.2.3 --- lams_common/src/java/org/lamsfoundation/lams/util/ExcelCell.java 11 May 2016 07:07:25 -0000 1.3.2.2 +++ lams_common/src/java/org/lamsfoundation/lams/util/ExcelCell.java 18 Nov 2016 01:31:19 -0000 1.3.2.3 @@ -32,6 +32,7 @@ public final static int BORDER_STYLE_LEFT_THIN = 1; public final static int BORDER_STYLE_RIGHT_THICK = 2; + public final static int BORDER_STYLE_BOTTOM_THIN = 3; private Object cellValue; private Boolean isBold; Index: lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java =================================================================== RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java,v diff -u -r1.7.2.3 -r1.7.2.4 --- lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java 11 May 2016 07:07:25 -0000 1.7.2.3 +++ lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java 18 Nov 2016 01:31:19 -0000 1.7.2.4 @@ -57,6 +57,8 @@ private static CellStyle borderStyleRightThick; private static CellStyle borderStyleLeftThinBoldFont; private static CellStyle borderStyleRightThickBoldFont; + private static CellStyle borderStyleBottomThin; + private static CellStyle borderStyleBottomThinBoldFont; public final static String DEFAULT_FONT_NAME = "Calibri-Regular"; @@ -127,6 +129,12 @@ borderStyleRightThickBoldFont = workbook.createCellStyle(); borderStyleRightThickBoldFont.setBorderRight(CellStyle.BORDER_THICK); borderStyleRightThickBoldFont.setFont(boldFont); + borderStyleBottomThin = workbook.createCellStyle(); + borderStyleBottomThin.setBorderBottom(CellStyle.BORDER_THIN); + borderStyleBottomThin.setFont(defaultFont); + borderStyleBottomThinBoldFont = workbook.createCellStyle(); + borderStyleBottomThinBoldFont.setBorderBottom(CellStyle.BORDER_THIN); + borderStyleBottomThinBoldFont.setFont(boldFont); int i = 0; for (String sheetName : dataToExport.keySet()) { @@ -260,6 +268,13 @@ cell.setCellStyle(borderStyleRightThick); } break; + case ExcelCell.BORDER_STYLE_BOTTOM_THIN: + if (excelCell.isBold()) { + cell.setCellStyle(borderStyleBottomThinBoldFont); + } else { + cell.setCellStyle(borderStyleBottomThin); + } + break; default: break; }