Aspose failed to create pivot based on external file

Aspose.Cells Product Family
1

Attached is the project, and there is two files generated based on the same data.

Second (zip) should be extracted and xls open - error happened.
If data is created with one file - all is ok.

Note: it occurs only in Office Excel 2003!
2

Hi,

Thanks for reporting this issue.

Please let us know your Runtime Environment. Are you using Client Profile version of .NET framework?

We have logged this issue in our database. We will look into it and once we will have some fix/update available, we will let you know.

This issue has been logged as CELLSNET-40479.

3

Yep, Client Profile for .NET 4

4

Hi,

Thanks for your information, we have logged it. It will be helpful to sort out the issue.

5

Hi,

We could not find this issue clearly.

Please provide us more information about it, such as which file is giving error and provide us screenshots to illustrate your issue.

6

Opened in Excel 2003


ExportedAsOneFile.xls - correct.png
ExportedAsZipFile.zip (extract all and open Workbook.xls) - error.png


7

Hi,

It’s the limitation of the Ms Excel.

If you drag datapivotfield of ExportedAsOneFile.xls from column area to row area file in MS Excel, you will get the same error message.

The default position of datapivotfield is in Row area, so please change your VBA codes to move datapivotfield to row area first.

See following code and the attached file:


currentRow = 17



’ Metric Fields

ApplyPivotFieldsLayout sheet, pivotTable, currentRow

currentRow = currentRow + 1

If Not (pivotTable.DataPivotField Is Nothing) Then

pivotTable.DataPivotField.orientation = xlColumnField

End If


currentRow = 6

’ Data Fields

ApplyPivotFieldsLayout sheet, pivotTable, currentRow