Conditional Formatting for Borders Not Output Properly - Excel to HTML

Aspose.Cells Product Family
1

Hi, I am experiencing an issue when converting excel to html with some conditional styling (specifically for the borders). In the output html, the borders for cell N3 and N4 are displaying when they are not displaying in the excel sheet. The condition was not met; therefore the borders should not show. Any advice / fixes for this? I am using Aspose.Cells Version 25.1.1 for Dotnet with a proper license. I tried using the latest version 25.2.0 and still didn’t work.

Here is the zipped Excel file…
Sample Aspose QA Financial Risk.zip (8.2 KB)

public static string ConvertExcelToHtml(Worksheet ws)
{
try
{
var options = new Aspose.Cells.HtmlSaveOptions
{
ExportActiveWorksheetOnly = true,
ExportImagesAsBase64 = true,
HtmlCrossStringType = HtmlCrossType.Cross,
ExportHiddenWorksheet = true,
CalculateFormula = false //formulas are calculated in an earlier step using workbook.calculateFormula()

     };
     ws.Workbook.Worksheets.ActiveSheetIndex = ws.Index;
     using (MemoryStream htmlStream = new MemoryStream())
     {
         ws.Workbook.Save(htmlStream, options);
         htmlStream.Position = 0;
         using (StreamReader reader = new StreamReader(htmlStream))
         {
             string htmlContent = reader.ReadToEnd();
             return htmlContent;
         }
     }
 }
2

@prodigy234

It seems you are encountering an issue with conditional formatting not being reflected correctly when converting an Excel file to HTML using Aspose.Cells. Specifically, the borders for cells N3 and N4 are appearing in the HTML output even though the conditions for displaying those borders are not met in the original Excel sheet.

Here are a few suggestions to troubleshoot and potentially resolve this issue:

  1. Check Conditional Formatting Rules: Ensure that the conditional formatting rules applied to cells N3 and N4 are correctly set up in Excel. Sometimes, a misconfiguration can lead to unexpected results during conversion.

  2. Update Aspose.Cells Version: You mentioned using Aspose.Cells Version 25.1.1. If possible, consider updating to the latest version of Aspose.Cells. Newer versions often include bug fixes and improvements that could resolve issues like the one you are experiencing.

  3. Review Export Options: In your code, you are using HtmlSaveOptions with specific settings. You might want to experiment with the ExportSimilarBorderStyle option. Setting it to false could help in ensuring that only the borders that are actually visible in Excel are exported to HTML.

  4. Debugging the Output: You can also try saving the HTML output to a file and inspecting it directly. This might give you insights into how the borders are being rendered and whether there are any discrepancies.

  5. Consult Documentation: For more detailed guidance on exporting Excel to HTML and managing conditional formatting, you can refer to the Aspose.Cells documentation, which provides comprehensive information on various export options and settings.

If the issue persists after trying these suggestions, consider reaching out to the Aspose support team with your specific Excel file and code snippet for more targeted assistance.

For further reading, you might find the following resources helpful:

Feel free to ask if you have any more questions or need further assistance!

3

@prodigy234
By testing with sample files and code on the latest version v25.2, we can reproduce the issue. When saving the file to HTML, the conditional format border displays abnormally.

We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSNET-57832

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

4

@prodigy234 ,

We are pleased to inform you that your issue has been resolved. The fix will be included in an upcoming release (Aspose.Cells v25.3) that we plan to release in the first half of March 2025. You will be notified when the next version is released.
Attached is the result after fix for your reference:
output.zip (2.3 KB)

5

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