Aspose.Cells -> Wrong HTML output, when rendering range with bottom aligment

Aspose.Cells Product Family
,
1

I am using the code below to export a range to the html file.
Both columns have ‘bottom’ alignment set.
When rendering to HTML -> the both columns are combined - there is no space between them.
Attaching the output and the Excel file.

using (var fstream = new FileStream(dataDir + "bottom_bug.xlsx", FileMode.Open))
{
	// Instantiate a Workbook object that represents the existing Excel file
	var workbook = new Workbook(fstream);
	
	var sheet = workbook.Worksheets["Sheet1"];

	workbook.Worksheets.ActiveSheetIndex = sheet.Index;

	var range = workbook.Worksheets.GetRangeByName("DR_EXPORT");

	sheet.PageSetup.PrintArea = range.Address;

	// Save the Excel file
	workbook.Save(dataDir + "1.html", new HtmlSaveOptions
	{
		ExportImagesAsBase64 = true,
		ExportPrintAreaOnly = true,
		ExportHiddenWorksheet = false,
		ExportActiveWorksheetOnly = true
	});
}

bottom_bug.zip (9.1 KB)

2

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

This issue is logged as:
CELLSNET-48333 - Table Columns in range with bottom alignment are combined in converted HTML

3

@eyalmolad,

This is to inform you that your issue has been resolved now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

4

@eyalmolad,
Please try our latest version/fix: Aspose.Cells for .NET v21.7.4 (attached)
Aspose.Cells21.7.4 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.7.4 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.7.4 For .NetStandard20.Zip (5.6 MB)

Your issue should be fixed in it.
Let us know your feedback.

5

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