search

cfsimplicity / spreadsheet-cfml

Standalone library for working with spreadsheets and CSV in CFML
MIT License
126 stars 35 forks source link

Error with Lucee 5.3.5.92 on Commandbox 5 #195

Open phipps73 opened 4 years ago

phipps73 commented 4 years ago

When trying to create a spreadsheet I am seeing the following error:

Could not initialize class org.apache.poi.ooxml.util.DocumentHelper when running the following:

loc.spreadsheet = New spreadsheetLib.Spreadsheet(); loc.workbook = loc.spreadsheet.workbookFromQuery( data=loc.qReportData, xmlFormat=true );

Is there a jar missing in Lucee 5.3.5.92 or something in Commandbox?

cfsimplicity commented 4 years ago

Hi Dave. I have reported problems running the library on Lucee 5.3.5.x and it's likely this is what you're seeing.

As I put in that ticket's comments though, the issues appear to go away with a fix deployed in 5.3.6.33.

The strange thing is that having just spun up another 5.3.5.92 Commandbox (5) server, I'm no longer seeing any issues with that version! The tests all pass.

Sorry, but I'm not sure what to make of it at the moment...

phipps73 commented 4 years ago

Thanks, I'll try some different versions of Lucee. I'm limited to what I can use at the moment. In the meantime I have dropped down to just using a csv file but will need to come back to an excel format at some point. At this stage I am seeing it when running Lucee on Commandbox. Not sure about when I deploy to the beanstalk.

cfsimplicity commented 4 years ago

In production we're currently using Lucee 5.3.4.85 (on Tomcat) which has proved very stable despite being a SNAPSHOT. I've not had any problems running the library on it.