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
@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.
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
@norman.neubert,
We need the template file so that we can investigate your requirements and support the feature after analysis.