Wiki Markup |
---|
{introducedin: 8.4} {description} {excerpt}Sets or returns whether the values labels field should be placed as a Row Label or Column Label{excerpt} {signature:C#} public boolean CalculatedFieldsOnRow{ get; set; } {signature}{signature:vb.net} Public Property CalculatedFieldsOnRow() As Boolean {signature} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws = wb.Worksheets[0]; ws.PivotTables[0].PivotTableSettings.ValuesLabelOnRow = true; {code} {code:vbnet|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx") Dim ws As Worksheet = wb.Worksheets(0) ws.PivotTables(0).PivotTableSettings.ValuesLabelOnRow = true; {code} {example} {remarks} ValuesLabelOnRow is {{false}} by default. When creating a pivot table, set this option before adding any fields to ensure the values label field is created where it is intended. If this option is changed on a pivot table that already has a values label field, that field will be moved to the new position. {remarks} |
Page History
Overview
Content Tools