Saving Pivottable as mht

Aspose.Cells Product Family
1

I use the example
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:HyphenationZone>21</w:HyphenationZone>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>DA</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val=“–”/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–>

http://www.aspose.com/docs/display/cellsjava/Create+Pivot+Tables+and+Pivot+Charts

2

Hi Kristien,

Thanks for your posting and using Aspose.Cells for Java.

We were able to observe this issue. The pivot table does not display in the output mhtml. We have logged this issue in our database for investigation and fix. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSJAVA-40739.

3

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest version: Aspose.Cells
for Java v8.0.2.1.

Please call the method named PivotTable.refreshData() and the method named PivotTable.calculateData() before saving PivotTable as mht or html.

Please see the following sample code.

Java


Workbook wb = new Workbook(“pivotTable_test.xls”);

PivotTable pt = wb.getWorksheets().get(1).getPivotTables().get(0);

pt.setRefreshDataFlag(true);

pt.refreshData();

pt.calculateData();

pt.setRefreshDataFlag(false);

pt.setRefreshDataOnOpeningFile(false);

wb.save(“out.mht”);


4

The issues you have found earlier (filed as CELLSJAVA-40739) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.