POIUtility.cfc Issue

[weezerboy]

Ive been using POIUtility.cfc on cf8 and its worked flawlessly. Now we have switched to cf23  and I am getting this error Element CELL.CELL_TYPE_NUMERIC is undefined in LOCAL. We are using the exact same spreadsheet. worked fine in cf08 but now doesnt work cf23. Any ideas?

[BKBK · Accepted solution]

It is likely that the error is caused by the SeachImplicitScopes fix introduced in ColdFusion 2023 Update 7. To verify this, proceed as follows:

1.  Add the flag -Dcoldfusion.searchimplicitscopes=true to the java.args property in /{CF_INSTANCE}/bin/jvm.comfig;
2.  Restart ColdFusion.

[weezerboy]

Thnak you. I'll try this

[BKBK]

Did that help?