• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

SpreadsheetFormatRow hidden format is not working

Community Beginner ,
Jun 12, 2014 Jun 12, 2014

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? 

Views

141

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
no replies

Have something to add?

Join the conversation
Resources
Documentation