DeleteBlankRows does not work when I Export active worksheet to HTML

Aspose.Cells Product Family
1

Hello,

I work with a worksheet which contains a pivot table. I refreshed the pivot table and I saved the active worksheet to html.

When I open my html file it contains many empty lines with the following html code :

\<tr height=20 style='mso-height-source:userset;height:15pt'> \<td colspan=4 height=20 style='mso-ignore:colspan;height:15pt'></td> \</tr>

Before saving I deleted empty rows and columns, but i still have the empty rows in html:

pivotWorksheet.Cells.DeleteBlankRows();
pivotWorksheet.Cells.DeleteBlankColumns();

Thanks,
Oussama

2

@Oussama_Mokni,

Thanks for the details.

Please provide us sample code (runanble) (or preferably a console demo application (you may zip the project prior attaching)) and attach your template files (input file and output file, etc.) to show the issue, we will check it soon.