Wrong formatting when opening HTML as Workbook

Aspose.Cells Product Family
1

Hi, we have an html file containing a table (Test.html). If we open this file with Microsoft Excel or a browser we see the table correctly.

But if we open the file and save it as a workbook using the following code with Aspose.Cells, we see the table with a messed up formatting (see Test.xlsx).

var wb = new Workbook("Test.html");
wb.Save("Test.xlsx");

The font formatting (bold, underline, italics, color) is lost and some fonts are changed (Calibri instead of Book Antiqua or Comic Sans). Also we see “-1” instead of “(€ 1,000)”.

Could you please provide a fix?

Attachments.zip (8.3 KB)

2

@davidepedrocca,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47382 – Html to Excel conversion loses formatting

3

@davidepedrocca,

This is 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.

Keep in touch.

4

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

5

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

6

A post was split to a new topic: Vertical alignment of text changed while converting HTML to XLSX