Docker -> Save as HTML -> Bottom border is missing

Aspose.Cells Product Family
1

I have the following code sample:

var file = "c:\\temp\\print_missing_2.xlsx";
var workbook = new Workbook(file);

var worksheet = workbook.Worksheets["Sheet1"];

var name = workbook.Worksheets.Names["DR_PUBv2__1655026955"];

worksheet.PageSetup.PrintArea = name.GetRange().Address;
workbook.Worksheets.ActiveSheetIndex = worksheet.Index;

workbook.Save("c:\\temp\\print_missing_2.html", HtmlSaveOptions);

The input file and the output files are attached in the zip file.
The issue is: In the output HTML, the bottom border is missing.

Thanks
missing_border.zip (51.3 KB)

2

@eyalmolad,

Which version of Aspose.Cells for .NET you are using? I tested your scenario/case with your template file using our latest version/fix: Aspose.Cells for .NET 22.6.1 (please try it if you are not already using it) in simple .NET project on Windows8, it works fine and I do not get the issue regarding bottom border.
e.g.
Sample code:

           var file = "e:\\test2\\print_missing_2.xlsx";
           HtmlSaveOptions htmlSaveOptions = new HtmlSaveOptions(SaveFormat.Html);
           htmlSaveOptions.ExportPrintAreaOnly = true;
           htmlSaveOptions.ExportActiveWorksheetOnly = true;
           var workbook = new Workbook(file);

           var worksheet = workbook.Worksheets["Sheet1"];

           var name = workbook.Worksheets.Names["DR_PUBv2__1655026955"];

           worksheet.PageSetup.PrintArea = name.GetRange().Address;
           workbook.Worksheets.ActiveSheetIndex = worksheet.Index;

           workbook.Save("e:\\test2\\print_missing_2.html", htmlSaveOptions);

Please find attached the output HTML file for your reference.
files1.zip (18.3 KB)

3

It works on Windows but not on Docker. I wrote in the title :slight_smile:
I am using 2.6.1.
It’s Ubuntu Docker. I am getting the following version:
Unix 4.10.0.35

4

@eyalmolad,

Thanks for providing further details.

We have logged a ticket with an id “CELLSNET-51429” for your issue. We will look into it to figure it out soon.

Once we have an update on it, we will let you know.

5

@eyalmolad

After looking into your shared html file, the last two rows are missing.
It seems that the html file is modified after being generated by Aspose.Cells.

Please share us the html file directly generated by Aspose.Cells. Also please share us the HtmlSaveOptions used on your side.

6

This is the HtmlSaveOptions object:

private HtmlSaveOptions HtmlSaveOptions =>
            new()
            {
                ExportImagesAsBase64 = true,
                ExportPrintAreaOnly = true,
                ExportHiddenWorksheet = false,
                ExcludeUnusedStyles = true,
                ExportActiveWorksheetOnly = true,
                Encoding = Encoding.UTF8
            };

The workbook is saved to MemoryStream using this code:

    using var html = new MemoryStream();
    workbook.Save(html, _htmlOptions);
7

@eyalmolad

As I decribed, the html file is modified after being generated by Aspose.Cells.

Please share us the html file directly generated by Aspose.Cells(without modified by other program) with the sample source file and code you shared:

8

We are looking on our side. Will update. Thanks

9

@eyalmolad,

Sure, please take your time to evaluate it on your side.

10

Sorry, you are correct. the bug was on our side.
Thanks

11

@eyalmolad,

Good to know that your issue is sorted out now. Feel free to write us back if you have further queries or comments.