Skip to main content
Participating Frequently
June 12, 2014
Question

SpreadsheetFormatRow hidden format is not working

  • June 12, 2014
  • 0 replies
  • 192 views

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? 

This topic has been closed for replies.