Error cells and JAX errors

[Daemach]

We've recently started seeing a random error: JAXP00010003: The length of entity “[xml]” is “100,001” that exceeds the “100,000” limit set by “jdk.xml.maxGeneralEntitySizeLimit”. I tried adding a JVM arg to resolve it, but I still see the error occasionally. Oddly, reimporting the spreadsheet often works. "-Djdk.xml.maxGeneralEntitySizeLimit=10000000"

The second error, Cannot get a STRING value from a ERROR cell, was caused by a #REF! error cell. In these cases, I would prefer it skip that cell rather than error, possibly with a setting somewhere to control that behavior.

[cfsimplicity]

What version is your JVM? Looks like an issue with Java 24. Did you try setting the system property to zero, which apparently removes any limit?

-Djdk.xml.maxGeneralEntitySizeLimit=0

Otherwise if you can post a repro case (i.e. a spreadsheet example file and cfml code that produces the exception) I'll see if there's anything I can do.

As for the second error: what version of spreadsheet-cfml are you using? From version 5.x formula evaluation errors should be silently ignored unless you explicitly allow them. (See issue #419)

Here's an example:

File containing a formula #REF! error: test.xlsx

spreadsheet = New spreadsheetCFML.Spreadsheet()
path = ExpandPath( "test.xlsx" )
result = spreadsheet.read( path, "query" )
dump( result )

[Daemach]

I am on 5.3.0, running Lucee 5.4 on OpenJDK 11. Boxlang probably installed Java 24, but I wouldn't think it would interfere with Lucee.

I've attached the problem file. The #REF! I deleted is on the second sheet, row 240. args in this case are path, password, headers, skiprows, sheetName.

return spreadsheet.setReturnCachedFormulaValues( true ).read( argumentcollection = args );

test.xlsx

[cfsimplicity]

Seems that cell with the reference error was not being evaluated as a formula, so it wasn't respecting the default setting to silently ignore errors.

I've committed a change so that cells with errors like this one will in future be treated the same as cells with formula errors.

[Daemach]

That’s great, thank you.

Re: the JAX error, does Java 11 use the same mechanism? It seems odd to me that I would get a Java 24 error with Lucee, or that Lucee would even work on Java 24. The error is random.

[cfsimplicity]

I don't know much about JAX I'm afraid, but I gather that Java 24 has set new lower limits on "entity expansion" (whatever that is), which means that exception is more common.

Might be worth trying this system property/value as I suggested:

-Djdk.xml.maxGeneralEntitySizeLimit=0

Otherwise I'm not sure there's much I can do about it with the library, although as I say if you can come up with a repro case I'm happy take a closer look.