Diagram is not shown in html when sheet has no other content - Excel to HTML

Aspose.Cells Product Family
1

Hi!

We are converting xlsx to html using the following code and Aspose.Cells 20.9.0:

AsposeLicenser.LoadLicense();
var options = new HtmlSaveOptions
{
    ExportImagesAsBase64 = true,
    ExportSingleTab = true,
    ExportGridLines = true
};
using (var wb = new Workbook("..."))
    wb.Save("...", options);

On converting the noOtherContent.xlsx file from the archive below, the diagram is not shown. If there was some other content on the sheet (added “test” into cell A1 in withOtherContent.xlsx), the diagram would be shown as expected (see images below).
noOtherContent.PNG (1.0 KB)
withOtherContent.PNG (10.9 KB)

This issue was not present in 20.8.0.
files.zip (30.0 KB)

Thanks,
Arnold

2

@arnoldbeilandevozon,

Please notice, we were able to reproduce the issue as you mentioned by using your sample code with your template file. We found diagram (smartart shape) is not shown in the html when sheet has no other contents in it. We have logged a ticket with an id “CELLSNET-47609” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@arnoldbeilandevozon,
Please try our latest version/fix: Aspose.Cells for .NET v20.9.9:

Aspose.Cells20.9.9 For .Net4.0.Zip (5.4 MB)
Aspose.Cells20.9.9 For .NetStandard20.Zip (5.4 MB)
Aspose.Cells20.9.9 For .Net2_AuthenticodeSigned.Zip (5.4 MB)

Your issue should be fixed in it.

Let us know your feedback.

4

Hi!

I’ve tested the dll you attached, the output looks correct. Waiting for the next official nuget release with this included.

Thanks!
Arnold

5

@arnoldbeilandevozon,

Good to know that your issue is sorted out by the new fix/version.
You may use this fix as an official release, it contains all the features of previous version (v20.9) plus new enhancements and other fixes. The hotfixes (shared in the forums) are fully tested and can be used on production server. However, if you need official release to get from Nuget/Downloads section, please wait for one and a half week as our next official release (e.g Aspose.Cells for .NET v20.10) is scheduled to be published (Nuget repos./Downloads) in the third week of October, 2020 (the release might be released a little earlier too, because releases are published when ready). You will also be notified once the new release is published.

1 Like
6

The issues you have found earlier (filed as CELLSNET-47609) have been fixed in Aspose.Cells for .NET v20.10. This message was posted using Bugs notification tool by Amjad_Sahi. You may also get the version @ Nuget repos. (NuGet Gallery | Aspose.Cells 20.10.0).