Free Support Forum - aspose.com

Where do i find CubeFields and PivotFormulas with PivotTable


#1

Hi,

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
Norman


#2

@norman.neubert,

Thanks for the details.

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


#3

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
Norman


#4

@norman.neubert,

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