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)