Highlighted

SpreadsheetFormatRow hidden format is not working

Community Beginner ,
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

101

Likes

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

SpreadsheetFormatRow hidden format is not working

Community Beginner ,
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

102

Likes

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
Jun 12, 2014 0

Have something to add?

Join the conversation