Index: lams_build/lib/lams/lams.jar =================================================================== diff -u -r41bb651a1488681fd9ca663ead283b47defdc408 -rbab1a8a3e84314de4488aaedc063b39f806ce2c5 Binary files differ Index: lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java =================================================================== diff -u -rc29e529815c22e46dbf7711ddb9fcd62f9ec880d -rbab1a8a3e84314de4488aaedc063b39f806ce2c5 --- lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java (.../ExcelUtil.java) (revision c29e529815c22e46dbf7711ddb9fcd62f9ec880d) +++ lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java (.../ExcelUtil.java) (revision bab1a8a3e84314de4488aaedc063b39f806ce2c5) @@ -58,7 +58,7 @@ private static CellStyle borderStyleLeftThinBoldFont; private static CellStyle borderStyleRightThickBoldFont; - private final static String DEFAULT_FONT_NAME = "Calibri-Regular"; + public final static String DEFAULT_FONT_NAME = "Calibri-Regular"; /** * Create .xlsx file out of provided data and then write out it to an OutputStream. Index: lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java =================================================================== diff -u -r0aae4208886026f429f05b458b79c14f8d7030d4 -rbab1a8a3e84314de4488aaedc063b39f806ce2c5 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java (.../McServicePOJO.java) (revision 0aae4208886026f429f05b458b79c14f8d7030d4) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java (.../McServicePOJO.java) (revision bab1a8a3e84314de4488aaedc063b39f806ce2c5) @@ -50,6 +50,7 @@ import org.apache.poi.hssf.usermodel.HSSFSheet; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.CellStyle; +import org.apache.poi.ss.usermodel.Font; import org.apache.poi.ss.usermodel.IndexedColors; import org.apache.tomcat.util.json.JSONArray; import org.apache.tomcat.util.json.JSONException; @@ -101,6 +102,7 @@ import org.lamsfoundation.lams.usermanagement.User; import org.lamsfoundation.lams.usermanagement.dto.UserDTO; import org.lamsfoundation.lams.usermanagement.service.IUserManagementService; +import org.lamsfoundation.lams.util.ExcelUtil; import org.lamsfoundation.lams.util.JsonUtil; import org.lamsfoundation.lams.util.MessageService; import org.lamsfoundation.lams.util.WebUtil; @@ -924,8 +926,12 @@ // create an empty excel file HSSFWorkbook wb = new HSSFWorkbook(); HSSFCellStyle greenColor = wb.createCellStyle(); - greenColor.setFillForegroundColor(IndexedColors.GREEN.getIndex()); + greenColor.setFillForegroundColor(IndexedColors.LIME.getIndex()); greenColor.setFillPattern(CellStyle.SOLID_FOREGROUND); + Font whiteFont = wb.createFont(); + whiteFont.setColor(IndexedColors.WHITE.getIndex()); + whiteFont.setFontName(ExcelUtil.DEFAULT_FONT_NAME); + greenColor.setFont(whiteFont); // ======================================================= Report by question IRA page // =======================================