0 Replies Latest reply on Jun 12, 2014 10:47 AM by pcesana

    SpreadsheetFormatRow hidden format is not working

    pcesana

      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?