Need global setting to disallow hierachy expansion and (hopefully) hide expansion node in row header

Posted by: j2associates on 8 September 2017, 12:33 pm EST

  • Posted 8 September 2017, 12:33 pm EST

    Hello all,


    Is there a global setting to prevent child rows from being expanded and not even allowing the expand node to display in the row header? Thanks in advance for any ideas and/or suggestions!

  • Replied 8 September 2017, 12:33 pm EST

    j2 -

    There is not a global setting but you can use the SetRowExpandable method on the sheet level.
  • Replied 8 September 2017, 12:33 pm EST

    Thanks Bob! Is there a policy setting or such like that I can set at the SheetView level that says don't expand any rows? I have been updating at the row level but since I never want to expand in this particulara case I was hoping I could set a property higher up the food chain somewhere, so to speak.
  • Replied 8 September 2017, 12:33 pm EST

    j2 -

    Sorry, there is not.  You would have to loop through the rows and call the SetRowExpandable(x, False).
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels