I’ve got a report that generates a spreadsheet using @Leftbower’s cfspreadsheet extension.
Recently, I upgraded Lucee, Tomcat and Java in preparation for a new server in our Production cluster. During tests, I came across this error:
lucee.runtime.exp.NativeException 'double lucee.runtime.functions.string.FindNoCase.call(lucee.runtime.PageContext, java.lang.String, java.lang.String)'
when running the command
<cfset SpreadsheetFormatRow(local.sheet, local.cell_formats.header, local.counter.row)>
I found a forum post on dev.lucee.org which details the error and a solution to handling it written by Michael Sprague. I’m reproducing it here for posterity and my own peace-of-mind.
- Stop Lucee
- Go to {lucee-install}/tomcat/lucee-server/context/archives/cfc/cfspreadsheet and rename cfc-archive-cfspreadsheet.lar to cfc-archive-cfspreadsheet.zip
- Unzip the file, making sure that the Org folder ends up in the cfspreadsheet folder.
- Start Lucee
- login into lucee Administrator Panel, go to Component then edit the cfspreadsheet entry
- Change the type to resource, and path: {lucee-install}\tomcat\lucee-server\context\archives\cfc\cfspreadsheet