error CFR CF 2016 to CF 2018

Just fyi, 2018 doesnt like a couple of other things either with excel reports.  After much trial and error i can usually rebuild the reports by checking the folowing:

1.  Like previously mentioned; no group bands

2  no overlapping cells(sometimes its not apparent even from looking at the properties that this is the issue as they all seem snug but copy all in the band into a new report and you will see the issue most of the time, maybe some form of caching?)

3. no "stretch with overflow" on the bands or the fields in excel

4.  The height of the report should be greater than the amount of rows that will be produced(i believe it is the cause of this problem:Invalid cell range, having lastRow < firstRow )  I am going to reach out for that patch mentioned now:)

Hi scottm56010691

The only thing I could do to generate the excel was:

create the cfr as html create the html and then read it to generate the excel

<cfreport format="html" template= "DocumentosSinAplicarResCP.cfr" query="rsReporte" 
filename = "mireporte22.html" encryption = "128-bit" overwrite = "yes" >
</cfreport>
<cf_cfrexcel filename="mireporte22" filexls="DocSinAplicar">
<cfabort>


----cfrexcel.cfm
<cfparam name="Attributes.filename" type="string">				<!--- Mensaje de Error cuando es proceso de Interfaz --->
<cfparam name="Attributes.filexls" 	 type="string" default="">	<!--- showerror cuando NO es proceso de Interfaz --->
<cfset lvarFile = Attributes.filename>
<cfset lvarXls = Attributes.filexls>

	<cfscript>
		setEncoding("form","UTF-8");
		setEncoding("url","UTF-8");
		myFile = fileRead(expandPath("./#lvarFile#.html"));
	</cfscript>

	<cfprocessingDirective pageencoding="utf-8">
	<cfset setEncoding("form","utf-8")>
		<cfsavecontent variable="strTHeadExcel">
			<cfoutput>#myFile#</cfoutput>
		</cfsavecontent>
	<cfcontent type="application/vnd.ms-excel; charset=windows-1252" reset="yes">
	<cfheader name="Content-Disposition" value="filename=#lvarXls#.xls">
	<cfoutput> #strTHeadExcel# </cfoutput>

Maybe you can improve it or find another possible solution.