Index: lams_gradebook/web/gradebookCourseMonitor.jsp
===================================================================
diff -u -r9dcc3e2d26b504f92d919f53f0d45dd4093a82a2 -r5399cd4e0375727fe77dc38498848d465889e715
--- lams_gradebook/web/gradebookCourseMonitor.jsp	(.../gradebookCourseMonitor.jsp)	(revision 9dcc3e2d26b504f92d919f53f0d45dd4093a82a2)
+++ lams_gradebook/web/gradebookCourseMonitor.jsp	(.../gradebookCourseMonitor.jsp)	(revision 5399cd4e0375727fe77dc38498848d465889e715)
@@ -362,17 +362,33 @@
 				    for (var i=0; i<ids.length; i++) {
 				    	lessonIds += "&lessonID=" + ids[i];
 				    }
+				    //*LKC* added the following line
+				    var isEachLessonSeparateSheet = $('#export-selected-lessons-checkbox').is(":checked");
 					
 					var areaToBlock = "select-lessons-area";
 					var simplified = jQuery("#export-selected-simplified").prop('checked');
 					simplified = "simplified="+simplified;
-					var exportExcelUrl = "<lams:WebAppURL/>gradebookMonitoring/exportExcelSelectedLessons.do?<csrf:token/>&"+simplified+"&organisationID=${organisationID}" + lessonIds;
+					//*LKC* modified the following line
+					var exportExcelUrl = "<lams:WebAppURL/>gradebookMonitoring/exportExcelSelectedLessons.do?<csrf:token/>&"+simplified+"&organisationID=${organisationID}" + lessonIds + "&isEachLessonSeparateSheet=" + isEachLessonSeparateSheet;
 					blockExportButton(areaToBlock, exportExcelUrl, languageLabelWait);
 				}
 				
 				return false;
 			});
 			
+			$("#export-selected-simplified").click(function() {
+				if ( $("#export-selected-simplified").prop('checked') ){
+					$("#export-selected-lessons-checkbox").prop('checked',false);
+				}
+			});
+
+			$("#export-selected-lessons-checkbox").click(function() {
+				if ( $("#export-selected-lessons-checkbox").prop('checked') ){
+					$("#export-selected-simplified").prop('checked',false);
+				}
+			});
+
+
 	        //jqgrid autowidth (http://stackoverflow.com/a/1610197)
 	        $(window).bind('resize', function() {
 	            resizeJqgrid(jQuery(".ui-jqgrid-btable:visible"));
@@ -487,8 +503,10 @@
 		</div>
 
 		<div id="select-lessons-area" class="voffset5 form-inline">
+			<!--*LKC* customised buttons -->
 			<input class="btn btn-xs btn-default" type="button" value="<fmt:message key="label.button.export"/>" id="export-selected-lessons-button" />
 			<div class="checkbox input-sm loffset5"><label><input type="checkbox" id="export-selected-simplified">&nbsp;<fmt:message key="label.simplified.export"/></label></div>
+			<div class="checkbox input-sm loffset5"><label for="export-selected-lessons-checkbox"><input type="checkbox" id="export-selected-lessons-checkbox">&nbsp;Each lesson in a separate sheet</label></div>
 			<div><fmt:message key="gradebook.export.desc"/></div>
 		</div>