The Event User Model fake-workbook for formula evaluations needs to know about the sheet names

git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1611946 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 8 insertions, 1 deletions

diff --git a/src/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java b/src/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java
index c6036d6582..b0d0388a2c 100644
--- a/src/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java
+++ b/src/java/org/apache/poi/hssf/eventusermodel/EventWorkbookBuilder.java
@@ -138,7 +138,14 @@ public class EventWorkbookBuilder {
 		}
 
 		public HSSFWorkbook getStubHSSFWorkbook() {
-			return HSSFWorkbook.create(getStubWorkbook());
+		    // Create a base workbook
+		    HSSFWorkbook wb = HSSFWorkbook.create(getStubWorkbook());
+		    // Stub the sheets, so sheet name lookups work
+		    for (BoundSheetRecord bsr : boundSheetRecords) {
+		        wb.createSheet(bsr.getSheetname());
+		    }
+		    // Ready for Formula use!
+		    return wb;
 		}
 		public InternalWorkbook getStubWorkbook() {
 			return createStubWorkbook(