Copy link to clipboard
Copied
Hi I created a report using spreadsheet function. I have a problem hiding rows since the the hidden="true" does not seem to work
example:
<cfscript>
sHidden=StructNew() ;
sHidden.hidden="true";
sHidden.fontsize="8";
</cfscript>
.....
<cfset spreadsheetAddRows(s, qline)>
<cfset nEnd=nLine+qline.recordcount>
<cfloop index="n" from="#nLine#" to="#nend-1#" >
<cfif not isdefined("form.summary")>
<cfset SpreadsheetFormatRow(s, sLineDetail, n)>
<cfelse>
<cfset SpreadsheetFormatRow(s, sHidden, n)>
</cfif>\
</cfloop>
No matter what I try the hidden format does not work. Fontsize in the shidden structure was added to test whether it was working ... and it is.
Also <cfset SpreadsheetFormatRow(s, {hidden=true}, n)> does not work.
Any ideas?
Have something to add?