Aspose.Cells misplaces chart when xlsx file is converted to html

Aspose.Cells Product Family
,
1

Hi!

I’m trying to convert the xlsx file from the archive attached to html using the following code:
var input = @"[…]\charts.xlsx";
var targetFolder = @"[…]\output_21.2";

        AsposeLicenser.LoadLicense();

        var targetPath = Path.Combine(targetFolder, "preview.html");
        var options = new HtmlSaveOptions
        {
            ExportImagesAsBase64 = true,
            ExportSingleTab = true,
            IsExportComments = false,
            ExportHiddenWorksheet = false,
            HiddenRowDisplayType = HtmlHiddenRowDisplayType.Remove,
            HiddenColDisplayType = HtmlHiddenColDisplayType.Remove,
            ExportGridLines = true
        };

        using (var wb = new Workbook(input))
            wb.Save(targetPath, options);

If I use version 20.12.0 the charts are placed correctly on the html page but if I use 21.1.0 or 21.2.0 the placement is incorrect (see the output folders from the archive attached). Is this a bug or am I missing something?

cells_20.12_vs_later.zip (59.5 KB)

Thanks,
Arnold

2

@arnoldbeilandevozon,
This issue is observed and logged in our database for further investigation. We will notify you here once any update is ready for sharing.

This issue is logged as:
CELLSNET-47907 - Chart placement is changed while converting Excel to HTML

3

@arnoldbeilandevozon,

We are pleased to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@arnoldbeilandevozon
Please try the latest fix 21.3.3 .
Aspose.Cells21.3.3 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.3.3 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.3.3 For .NetStandard20.Zip (5.5 MB)

5

Hi!
I tested with the 21.3.3 version, and it works as expected.
Thanks

6

@arnoldbeilandevozon,

Good to know that your issue is resolved by the new fix. In the event of further queries or issue, feel free to write us back.

7

The issues you have found earlier (filed as CELLSNET-47907) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao