Julian Halliwell

That looks correct. How about: `spreadsheet.dumpPathToClass( "org.apache.poi.openxml4j.opc.OPCPackage" );`?

To rule out a problem with the server mapped JavaLoader instance you mentioned earlier, you could explicitly point the library to the version bundled with it. 1) Create an application...

OK, no change then. As I say it was just to rule out a problem with the JavaLoader mapping. Thanks for posting the full stack trace. That shows where the...

@ivanionut It might be worth trying the latest release 2.14.0 which uses a new version of POI and no longer requires JavaLoader to [load it in Lucee](https://github.com/cfsimplicity/lucee-spreadsheet/wiki/Loading-the-POI-java-libraries).

Top of the stack trace from ACF: > coldfusion.runtime.java.MethodSelectionException: The open method was not found. at coldfusion.runtime.java.ObjectHandler.findMethodUsingCFMLRules(ObjectHandler.java:383) at coldfusion.runtime.StructBean.invoke(StructBean.java:524) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3316) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3224)

Doesn't work with Lucee either when loading via `javasettings`, i.e. direct from the class path. But **does** work in Lucee via JavaLoader or using the osgi bundle. Here's the Lucee...

The Lucee trace suggests a problem with logging. ESR uses SLF4J whereas POI uses log4J. Have tried using the [bridging jar](https://mvnrepository.com/artifact/org.apache.logging.log4j/log4j-slf4j-impl) but with no success. It does change the error...

+1. I'd find that useful. I'm personally happy with LESS but SASS is arguably the more popular pre-processor.

Hi, the [read()](https://github.com/cfsimplicity/spreadsheet-cfml/wiki/read) method will only return cell values. Data validations are not themselves cell values, they just limit what values can be entered. So in other words, if you...

Those are not drop-downs. They are images of drop-downs.