Index: lams_build/lib/lams/lams.jar =================================================================== diff -u -r46bcb6ea758a272250071d1a571d008c6745e593 -re08b873af178aec14f4a58df17f0f34a47931069 Binary files differ Index: lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java =================================================================== diff -u -rc29e529815c22e46dbf7711ddb9fcd62f9ec880d -re08b873af178aec14f4a58df17f0f34a47931069 --- 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 e08b873af178aec14f4a58df17f0f34a47931069) @@ -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 -rc93c1eaabb8c79d6f2bb3f31872e262e52e271af -re08b873af178aec14f4a58df17f0f34a47931069 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java (.../McServicePOJO.java) (revision c93c1eaabb8c79d6f2bb3f31872e262e52e271af) +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java (.../McServicePOJO.java) (revision e08b873af178aec14f4a58df17f0f34a47931069) @@ -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; @@ -921,8 +923,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 // =======================================