We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

PivotTable.EnableFieldList. Incorrect property name and description

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

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.

Hi,

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

Thank you

Works fine! Thank you!

Best regards,
Alex Shloma

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.