#137 NPE when opening XLS

[crocchio]

I am just using the standard Spreadsheet component widget - testing things out to see if this will work in our application that we are prototyping. I get the following NPE when trying to open the XLS that is located here:

http://www.energystar.gov/index.cfm?c=assess_value.financial_tools - and it is the CASH FLOW OPPORTUNITY calculator (too big to attach here)

java.lang.NullPointerException
jxl.biff.drawing.ZssDrawing.<init>(ZssDrawing.java:61)
org.zkoss.zss.model.impl.ExcelImporter.importSheetImages(ExcelImporter.java:584)
org.zkoss.zss.model.impl.ExcelImporter.importEachSheet(ExcelImporter.java:194)
org.zkoss.zss.model.impl.ExcelImporter.importFromStream(ExcelImporter.java:114)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:592)
bsh.Reflect.invokeMethod(Unknown Source)
bsh.Reflect.invokeObjectMethod(Unknown Source)
bsh.Name.invokeMethod(Unknown Source)
bsh.BSHMethodInvocation.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHPrimaryExpression.eval(Unknown Source)
bsh.BSHVariableDeclarator.eval(Unknown Source)
bsh.BSHTypedVariableDeclaration.eval(Unknown Source)
bsh.Interpreter.eval(Unknown Source)
bsh.Interpreter.eval(Unknown Source)
org.zkoss.zk.scripting.bsh.BSHInterpreter.exec(BSHInterpreter.java:100)
org.zkoss.zk.scripting.util.GenericInterpreter.interpret(GenericInterpreter.java:292)
org.zkoss.zk.ui.impl.PageImpl.interpret(PageImpl.java:858)
org.zkoss.zk.ui.impl.UiEngineImpl.execNonComponent(UiEngineImpl.java:728)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:547)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:492)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild0(UiEngineImpl.java:612)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreateChild(UiEngineImpl.java:581)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreate0(UiEngineImpl.java:525)
org.zkoss.zk.ui.impl.UiEngineImpl.execCreate(UiEngineImpl.java:492)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage0(UiEngineImpl.java:374)
org.zkoss.zk.ui.impl.UiEngineImpl.execNewPage(UiEngineImpl.java:296)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.process(DHtmlLayoutServlet.java:230)
org.zkoss.zk.ui.http.DHtmlLayoutServlet.doGet(DHtmlLayoutServlet.java:167)
javax.servlet.http.HttpServlet.service(HttpServlet.java:627)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.27 logs.