Index: lams_build/lib/lams/lams.jar =================================================================== RCS file: /usr/local/cvsroot/lams_build/lib/lams/lams.jar,v diff -u -r1.475 -r1.476 Binary files differ 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 -r1.8 --- lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java 14 Apr 2014 21:49:17 -0000 1.7 +++ lams_common/src/java/org/lamsfoundation/lams/util/ExcelUtil.java 15 Dec 2015 15:24:33 -0000 1.8 @@ -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 =================================================================== RCS file: /usr/local/cvsroot/lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java,v diff -u -r1.134 -r1.135 --- lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java 28 Aug 2015 06:05:33 -0000 1.134 +++ lams_tool_lamc/src/java/org/lamsfoundation/lams/tool/mc/service/McServicePOJO.java 15 Dec 2015 15:24:45 -0000 1.135 @@ -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 // =======================================