We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

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

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

@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

@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.

@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)

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

@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.

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