we are having an issue on our service (docker that runs on Azure cloud as a kubernetes pod with Debian 11 OS.).
When we try to convert the name range DR_PUBv2__1648448656 in the sorce.xlsx we are having an issue with the formatting of cells N10, H10, N14, H14, N19 & H19
You can see that number is hidden behind red/green circle.
The code we run is below.
The source and the output are attached Html-Render-Docker.zip (24.1 KB)
private HtmlSaveOptions HtmlSaveOptions =>
ExportImagesAsBase64 = true,
ExportPrintAreaOnly = true,
ExportHiddenWorksheet = false,
ExcludeUnusedStyles = true,
ExportActiveWorksheetOnly = true,
Encoding = Encoding.UTF8
worksheet.PageSetup.PrintArea = range.Address;
workbook.Worksheets.ActiveSheetIndex = worksheet.Index;
using var html = new MemoryStream();