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

    SpreadsheetFormatRow hidden format is not working


      Hi I created a report using  spreadsheet function.  I have a problem hiding rows since the the hidden="true" does not seem to work





          sHidden=StructNew() ;





      <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)>


                <cfset SpreadsheetFormatRow(s, sHidden, n)>




      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?