Index: lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/web/action/MonitoringAction.java =================================================================== diff -u -ref2417616a93e7d6f1eaee601fd78455a90564d6 -r39f271516e207178880a7359aeb79350af6f379e --- lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/web/action/MonitoringAction.java (.../MonitoringAction.java) (revision ef2417616a93e7d6f1eaee601fd78455a90564d6) +++ lams_tool_survey/src/java/org/lamsfoundation/lams/tool/survey/web/action/MonitoringAction.java (.../MonitoringAction.java) (revision 39f271516e207178880a7359aeb79350af6f379e) @@ -272,13 +272,13 @@ row = sheet.createRow(idx++); cell = row.createCell((short) 0); cell.setEncoding(HSSFCell.ENCODING_UTF_16); - cell.setCellValue(survey.getTitle()); + cell.setCellValue(removeHTMLTags(survey.getTitle())); // survey instruction row = sheet.createRow(idx++); cell = row.createCell((short) 0); cell.setEncoding(HSSFCell.ENCODING_UTF_16); - cell.setCellValue(survey.getInstructions()); + cell.setCellValue(removeHTMLTags(survey.getInstructions())); // display 2 empty row row = sheet.createRow(idx++); @@ -295,7 +295,7 @@ cell.setCellValue(resource.getMessage(MonitoringAction.MSG_LABEL_SESSION_NAME)); cell = row.createCell((short) 1); cell.setEncoding(HSSFCell.ENCODING_UTF_16); - cell.setCellValue(session.getSessionName()); + cell.setCellValue(removeHTMLTags(session.getSessionName())); // begin to display question and its answers Set>> questionEntries = map.entrySet(); @@ -317,7 +317,7 @@ cell.setCellValue(resource.getMessage(MonitoringAction.MSG_LABEL_QUESTION) + " " + questionIdx); cell = row.createCell((short) 1); cell.setEncoding(HSSFCell.ENCODING_UTF_16); - cell.setCellValue(question.getDescription()); + cell.setCellValue(removeHTMLTags(question.getDescription())); // display options content Set options = question.getOptions(); @@ -335,7 +335,7 @@ cell.setCellValue(SurveyConstants.OPTION_SHORT_HEADER + optionIdx); cell = row.createCell((short) 1); cell.setEncoding(HSSFCell.ENCODING_UTF_16); - cell.setCellValue(option.getDescription()); + cell.setCellValue(removeHTMLTags(option.getDescription())); } if (question.isAppendText() || question.getType() == SurveyConstants.QUESTION_TYPE_TEXT_ENTRY) { optionIdx++; @@ -397,7 +397,7 @@ cell = row.createCell((short) ++cellIdx); cell.setEncoding(HSSFCell.ENCODING_UTF_16); if (answer.getAnswer() != null) { - cell.setCellValue(answer.getAnswer().getAnswerText()); + cell.setCellValue(removeHTMLTags(answer.getAnswer().getAnswerText())); } } @@ -431,6 +431,16 @@ } return null; } + + /** + * Removes all the html tags from a string + * @param string + * @return + */ + private String removeHTMLTags(String string) + { + return string.replaceAll("\\<.*?>", "").replaceAll(" ", " "); + } // ************************************************************************************* // Private method