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

Free Support Forum - aspose.com

Where do i find CubeFields and PivotFormulas with PivotTable


i have two vars that I can not find with PivotTable in Aspose.cells:CubeFields and PivotFormulas

In Excel I can use:

Dim pt As PivotTable

set pt = …

    For Each objCubeFld In pt.CubeFields
    Next objCubeFld

    For Each pivotForm In pt.PivotFormulas
    Next pivotForm

How do I do this with Aspose.Cells?

Thanks in Advance


Thanks for the details.

Could you provide template file having Pivot table with cube fields and pivot formulas, we will check it soon.

Hi Amjad,

I don’t have a file. My customers have some, but i can’t provide them. I don’t Need These fields for calculation purposes but more for analytical stuff as i calculate Checksums on them to validate that Nothing has changed.

I googled a bit and couldn’t find any samples that have These fields filled. I am wondering if it has anything to do with power Pivots…

Well, for now I can ignore These fields but it would be great if they would come in a future update.

Thanks a lot


We need the template file so that we can investigate your requirements and support the feature after analysis.