Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
95
Creating nested outline levels
posted

I'm trying to create nested outline levels.  What's the trick?

 

 

 

 

  • 44743
    Verified Answer
    posted

    Rows or columns which should be grouped together on an outline level should have their OutlineLevel set to 1. If you would like to nest outline levels, set the OutlineLevel or rows to higher numbers:

    Workbook workbook = new Workbook();
    Worksheet worksheet = workbook.Worksheets.Add( "Sheet1" );

    worksheet.Rows[ 4 ].OutlineLevel = 1;
    worksheet.Rows[ 5 ].OutlineLevel = 1;
    worksheet.Rows[ 6 ].OutlineLevel = 2;
    worksheet.Rows[ 7 ].OutlineLevel = 2;
    worksheet.Rows[ 8 ].OutlineLevel = 1;