Wrong Offset in vertical alignment

Aspose.Cells Product Family
1

Hello,


when we try to save the attached excel file to html, there can be found an vertical offset within the lines, which is not displayed in the excel document itself.

For example the line 3 and 5 starts one or more rows lower.

Thank you in advance.

Greetings.

Sacha End
2
Hi,

Thanks for the sample files.

I can notice the issue by converting your template XLSX file to HTML. There is an issue with the vertical alignment as you pointed out.

Sample code:

Workbook wb = new Workbook(@"E:\test2\Duplikat_von_QT_IO_DOK_300812(363551%2c1004).xlsx");

wb.Save(@"E:\test2\outDuplikat.html", SaveFormat.Html);

I have logged a ticket with an id: CELLSNET-41019. We will look into your issue soon.

Thank you.
3

Hi,

Thanks for using Aspose.Cells.

Please download and try this fix: Aspose.Cells for .NET v7.3.4.5 and let us know your feedback.

If you open this template file using MS Excel and save it to html file,you will find the same result in firefox.
although,please try this sample code:

C#
Workbook book = new Workbook(filePath);
AutoFitterOptions af = new AutoFitterOptions();
af.OnlyAuto = true;
book.Worksheets[0].AutoFitRows(af);
book.Save("D:\\dest.htm");