Hi,
we are creating Pivottables in empty Workbooks. We are using the
'Public Sub Save(stream As System.IO.Stream, saveFormat As Aspose.Cells.SaveFormat)'-method for saving.
For generating the file the following function and properties are used:
PivotableCollection
Public Function Add(sourceData As String, row As Integer, column As Integer, tableName As String) As Integer
Pivottable
Public Property IsAutoFormat As Boolean
Public Property AutoFormatType As Aspose.Cells.Pivot.PivotTableAutoFormatType
Public Property RowGrand As Boolean
Public Property ColumnGrand As Boolean
Public Function AddFieldToArea(fieldType As Aspose.Cells.Pivot.PivotFieldType, baseFieldIndex As Integer) As Integer
PivotField
Public Property IsAutoSort As Boolean
Public Property IsAscendSort As Boolean
Public Property [Function] As Aspose.Cells.ConsolidationFunction
Public Property DataDisplayFormat As Aspose.Cells.Pivot.PivotFieldDataDisplayFormat
Public Sub SetSubtotals(subtotalType As Aspose.Cells.Pivot.PivotFieldSubtotalType, shown As Boolean)
After an update from 4.8.1 to Aspose.Cells 7.3.0 we get a warning, when we open the File in Excel 2003 (11.8346.8341 SP3).
Microsoft Office Excel File Repair Log
Errors were detected in file 'filepath'
The following is a list of repairs:
Repairs were made to PivotTable report 'PivotTable1' on '[filepath.xls]Sheetname'.
In an earlier Excel verion (for example: 11.8231.8221 SP3) there are no Problems. Opening the File in Excel 2010 doesn't work either. The whole Pivots are empty there.
Any suggestions in this regards will be really helpful.
Regards,
Birgit Krackv