Spreadsheet 1.0.0 : Out of Memory Error

alexw84 · March 31, 2015, 2:02pm

I have saved a document with libre office in microsoft excel 2007/2010/2013 xml format (.xlsx)

when i try to open the file i get an out of memory error:

 javax.servlet.ServletException: com.vaadin.server.ServiceException: java.lang.OutOfMemoryError: Java heap space
com.vaadin.server.VaadinServlet.service(VaadinServlet.java:352)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause

com.vaadin.server.ServiceException: java.lang.OutOfMemoryError: Java heap space
com.vaadin.server.VaadinService.handleExceptionDuringRequest(VaadinService.java:1463)
com.vaadin.server.VaadinService.handleRequest(VaadinService.java:1420)
com.vaadin.server.VaadinServlet.service(VaadinServlet.java:350)
javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
root cause

java.lang.OutOfMemoryError: Java heap space
org.apache.xmlbeans.impl.store.CharUtil.allocate(CharUtil.java:397)
org.apache.xmlbeans.impl.store.CharUtil.saveChars(CharUtil.java:506)
org.apache.xmlbeans.impl.store.Cur$CurLoadContext.text(Cur.java:2922)
org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3043)
org.apache.xmlbeans.impl.store.Cur$CurLoadContext.attr(Cur.java:3060)
org.apache.xmlbeans.impl.store.Locale$SaxHandler.startElement(Locale.java:3250)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.reportStartTag(Piccolo.java:1082)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseAttributesNS(PiccoloLexer.java:1822)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseOpenTagNS(PiccoloLexer.java:1521)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseTagNS(PiccoloLexer.java:1362)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXMLNS(PiccoloLexer.java:1293)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.parseXML(PiccoloLexer.java:1261)
org.apache.xmlbeans.impl.piccolo.xml.PiccoloLexer.yylex(PiccoloLexer.java:4808)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yylex(Piccolo.java:1290)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.yyparse(Piccolo.java:1400)
org.apache.xmlbeans.impl.piccolo.xml.Piccolo.parse(Piccolo.java:714)
org.apache.xmlbeans.impl.store.Locale$SaxLoader.load(Locale.java:3439)
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1270)
org.apache.xmlbeans.impl.store.Locale.parseToXmlObject(Locale.java:1257)
org.apache.xmlbeans.impl.schema.SchemaTypeLoaderBase.parse(SchemaTypeLoaderBase.java:345)
org.openxmlformats.schemas.spreadsheetml.x2006.main.WorksheetDocument$Factory.parse(Unknown Source)
org.apache.poi.xssf.usermodel.XSSFSheet.read(XSSFSheet.java:194)
org.apache.poi.xssf.usermodel.XSSFSheet.onDocumentRead(XSSFSheet.java:186)
org.apache.poi.xssf.usermodel.XSSFWorkbook.onDocumentRead(XSSFWorkbook.java:354)
org.apache.poi.POIXMLDocument.load(POIXMLDocument.java:166)
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:240)
org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:109)
com.vaadin.addon.spreadsheet.SpreadsheetFactory.reloadSpreadsheetComponent(SpreadsheetFactory.java:206)
com.vaadin.addon.spreadsheet.Spreadsheet.<init>(Spreadsheet.java:346)
de.foo.vaadin.component.ui.TestPage.<init>(TestPage.java:56)
de.foo.app.AppUI.init(DiasTerminalUI.java:564)
com.vaadin.ui.UI.doInit(UI.java:646)

Jonatan · June 25, 2015, 7:40am

Hi Alexander,

Sorry for the extremely late answer, I just now found this question… Could you give me some details about the file? What size is it, what kind of data and approx how many cells contain data?

Spreadsheet builds on Apache POI, which, unfortunately, uses a lot of memory for certain kinds of files. If possible, I would gladly accept the file to use in internal tests (email me at my first name at vaadin dot com).

Cheers,
/Jonatan