Index: lams_build/lib/lams/lams.jar =================================================================== diff -u -rbb0a38ce3c757b6d0c296cfc055d40565a20227d -r75d371089c49a0ebc7dd90f64cb4746079c0b951 Binary files differ Index: lams_common/src/java/org/lamsfoundation/lams/util/ExcelCell.java =================================================================== diff -u -r51fb2a37254f24bb2a805d4ffd54482c779f43fa -r75d371089c49a0ebc7dd90f64cb4746079c0b951 --- lams_common/src/java/org/lamsfoundation/lams/util/ExcelCell.java (.../ExcelCell.java) (revision 51fb2a37254f24bb2a805d4ffd54482c779f43fa) +++ lams_common/src/java/org/lamsfoundation/lams/util/ExcelCell.java (.../ExcelCell.java) (revision 75d371089c49a0ebc7dd90f64cb4746079c0b951) @@ -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 =================================================================== diff -u -r51fb2a37254f24bb2a805d4ffd54482c779f43fa -r75d371089c49a0ebc7dd90f64cb4746079c0b951 --- lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java (.../ExcelUtil.java) (revision 51fb2a37254f24bb2a805d4ffd54482c779f43fa) +++ lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java (.../ExcelUtil.java) (revision 75d371089c49a0ebc7dd90f64cb4746079c0b951) @@ -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; }