Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0
Description

Excerpt

When grouping rows, SummaryRows determines where the summary rows for the groups are located. By default the summary rows are located below the groupings.

{signature}
{example}{code:csharp|title=C#}

          //--- Get SummaryRows
          Worksheet.SummaryRowsLocation location = ws.SummaryRows;

          //--- Set SummaryRows
          ws.SummaryRows = Worksheet.SummaryLocation.Above;
        
{code}
{code:vb.net
|title=vb.net
}

          '--- Get SummaryRows
          Dim location As Worksheet.SummaryRowsLocation = ws.SummaryRows

          '--- Set SummaryRows
          ws.SummaryRows = Worksheet.SummaryLocation.Above
        {code}

{example}
Signature
C#C#
Wiki Markup
{description}
{excerpt}When grouping rows, [SummaryRows|Worksheet.SummaryRows] determines where the summary rows for the groups are located. By default the summary rows are located below the groupings.{excerpt}
{signature:C#}
 public SummaryRowsLocation SummaryRows{ get; set; }
Signature
{signature}{signature:vb.net
vb.net
}
Public Property SummaryRows() As SummaryRowsLocation
Example
Code Block
csharpcsharp
titleC#
Code Block
vb.nettitle