PivotTable.EnableFieldList. Incorrect property name and description

Aspose.Cells Product Family
1

Hi,

Property ‘EnableFieldList’ related to the property ‘ShowPivotTableFieldList’ in Excel and It’s able to on/off field list instead of enable/disable.

Excel Developer Reference:
1. Workbook.ShowPivotTableFieldList Property
True (default) if the PivotTable field list can be shown. Read/write Boolean.
2. PivotTable.EnableFieldList Property
False to disable the ability to display the field list for the PivotTable. If the field list was already being displayed it disappears. The default value is True. Read/write Boolean.

I used these macro to change properties:

Sub RestrictPivotTableFieldList()
With ActiveSheet.PivotTables(1)
.EnableFieldList = False 'Excel 2002+
End With
End Sub

Sub AllowPivotTableFieldList()
Dim pt As PivotTable
Set pt = ActiveSheet.PivotTables(1)
With pt
.EnableFieldList = True 'Excel 2002+
End With
End Sub

Sub showFieldList()
ActiveWorkbook.ShowPivotTableFieldList = True
End Sub

Sub hideFieldList()
ActiveWorkbook.ShowPivotTableFieldList = False
End Sub

I use Aspose.Cells v7.0.3.2.

Best regards,
Alex Shloma
2

Hi,

I have logged this issue in our database. We will look into your requirements and update you asap.

This issue has been logged as CELLSNET-40134.

3

Hi,

Please try the fixed version: v7.0.3.3. Your issue should be fixed now.

Thank you

4

Works fine! Thank you!

Best regards,
Alex Shloma

5

The issues you have found earlier (filed as CELLSNET-40134) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.