Lucee 6 - SpreadsheetAddRows() Error

[spraguey]

I'm getting the following error when I run SpreadsheetAddRows().

Message: 'double lucee.runtime.functions.math.Min.call(lucee.runtime.PageContext, double, double)'
Type: java.lang.NoSuchMethodError
Tag Context:| /org/cfpoi/spreadsheet/Spreadsheet.cfc [2952]

I extracted and opened spreadsheet.cfc, and I see the following on line 2952:
return Min( Local.width, (255*256) );

I'm not having much luck trying to find this error on Google.

[spraguey]

In case it helps, this is the block of code running it. This was working with Lucee 5. It errors on the 4th line.

<cfset spObj = spreadsheetNew(xmlFormat="true")>
<cfset spreadsheetAddRow(spObj, arguments.fieldlabels)>
<cfset spreadsheetFormatRow(spObj, {bold="true"}, 1)>
<cfset spreadsheetAddRows(spObj, arguments.query,2,1)>

[spraguey]

I was able to write some simple replacement code to get around this, but I can't figure out how to deploy it. Can anyone help? @Leftbower ?

I extracted spreadsheet.cfc from cfc-archive-cfspreadsheet.lar. I make the following change to replace the Min function call.

if (Local.width LTE (255*256)) {
	return Local.width;
} else {
	return (255*256);
}

I then re-compress cfc-archive-cfspreadsheet.lar with the changed file and restart Lucee.

I still get the exact same error on the same line number, and the debugging shows the same old Min() line that I replaced. Could it be something to do with the spreadsheet_cfc$cf.class in the archive? Or does cfspreadsheet.cfc also exist in another place besides the LAR file?

[Leftbower]

Yes, Lucee is picking up the original, compiled class file which doesn't have your changes. You need to replace that with the newlsy compiled class file that includes your updates.

[spraguey]

I guess that is the piece of the puzzle I am missing. I don’t know how to generate the class file.

[Leftbower]

You can do it from within the Lucee admin. Navigate to the Component section under Archives & Resources. There are a number of tools/settings in there (my apologies... it's been a long time since I've looked at this).

[spraguey]

If anyone else runs into this issue, here is a fixed LAR file you can use.
cfc-archive-cfspreadsheet.lar.zip

[zspitzer]

@Leftbower could you just make a new release without the class file?

https://dev.lucee.org/t/regression-in-lucee-6-1-1-118-for-cfspreadsheet-java-lang-nosuchmethoderror/14437/13