Extra columns in exported HTML output when Excel named range contains icons

Aspose.Cells Product Family
1

We are looking into upgrade of Aspose.Cells to version 23.11 and noticed an issue in the way HTML is created for the cases when Excel named range contains a table with icons in one of the columns. When exported HTML is inserted into Word document, the extra empty column is shown at the end of each row.
That did not happen with currently used Cells library 21.3.
The new column cells can also be noticed by comparing the generated HTML outputs.
Please take a look at the attached zip containing the following:

  • Icons_center_aligned_diff.png - screenshot of comparison of inserted HTMLs into word document;
  • ConditionalFormatsCenterIcons.xlsx - input template
  • ConditionalFormatsCenterIcons-IconSetCenterAlign-v21.3.0.html - HTML output created with Cells 21.3.0
  • ConditionalFormatsCenterIcons-IconSetCenterAlign-v23.11.0.html - HTML output created with Cells 23.11;
  • emptyInput.docx - empty Word document

Thank you.
ConditionalFormatsCenterIcons.zip (140.8 KB)

2

@oraspose,

Thanks for the sample files and details.

We noticed the issue as you mentioned. We need to evaluate your issue in details. 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): CELLSJAVA-45771

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.

3

@oraspose,

We evaluated your issue thoroughly.

This issue is same as Icon Sets Become Misaligned on Conversion to HTML - #19 by John.He. So, kindly create relative issue/ticket on Aspose.Words forum.

4

Thanks for your reply.
We do not agree that this issue is the same as "Icon Sets Become Misaligned on Conversion to HTML ". This issue is about the extra empty column that does not pertain to the named range but is somehow included in the HTML . This extra column (within the HTML) was not included in previous Cells version. Additionally, if you export the named range as HTML via MS Excel (Excel → Save As → HTML) , the extra (empty) column does not appear.

Thank you.

5

@oraspose,

We have logged your concerns with your existing ticket and will be looking into them. We will get back to you soon.

6

@oraspose
By reviewing the sample file, it was found that the xlsx file does not match the two HTML files. The xlsx file has an extra long text for cell B1. Due to a long text in cell B1, there are extra columns in the output HTML. If you delete the text in cell B1, save the file, and then export it to HTML, you will find that there are only 4 columns. It is correct and consistent with Excel.

Please check the HTML output result in the fourth line of the file.

 <tr height='19' style='mso-height-source:userset;height:14.4pt'>
<td height='19' style='height:14.4pt;'></td>
<td height='17' width='75' style='text-align:center;height:12.9pt;width:56.25pt;font-size:11pt;color:#000000;font-weight:400;text-decoration:none;text-line-through:none;font-family:Calibri,sans-serif;background:none;mso-pattern:auto;border-top:1px solid windowtext;border-right:1px solid windowtext;border-bottom:1px solid windowtext;border-left:1px solid windowtext;vertical-align:bottom;'><span style='mso-ignore:vglayout;position:absolute;z-index:1;margin-left:-7.5px;margin-top:1px;width:15px;height:15px'><img width='15' height='15' src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAA7EAAAOxAGVKw4bAAACbElEQVR4Xq2T30uTURjH3aVUky6au8mgRRRNMSk3yP1w/jiHvbgftteYm/M12WQ5nYphaCwocBcRxiKiiC6clVlZ/qCVhhkmRFGDggqKoOiyi/6Db895h8qbF970wpfzvuc838/znHOet6jofz35fB5KezsG+vrQ25NAPB5HNBaFoihoDYcRkGV4vV5wzuH3+yHiNeYmyY3M2Bgi4RACgeOQJAm1LhcsVivKKypgMplgNBqh1+tRXFwMnU63ARGZhZleVe2vOoBwOojkQhSR2WbwOxzWMw7sqdy7HiPk8/kKgP5kkjKH1ckjDUeReXMREx9v4Ub+ClIvBxF67IMjy1BPoEN15nWA0+ksAHoSCchUtqHMiAsrI5j7Oo0vvz/h1c9lXH17CfFcG9hdDjtBAo8Ydu02aAHiwMSebR12pFdTyH2bxY8/3/H61yquvbtMgAgYZXdkOWQCOE5atIBYLKYeGEu5cPp5N66/z2D68ySyH27i/Mow2mb8cE4wuG4zBGepitFaLUDpUNTTtg87aL9eDCx24ezyIIaWetE5fwLSPY6acQ73FIfyhEEerdMCWkMhmOmqqnttlIWjiQzyAzeaSWLvx8YLB9gyw9C9yOEdUY0bgECLTPe8DwddZiq1YBAZa2i0kfgkR2C6EV3PGPpfSKhsKNcCPB4PSqlJxGTjOSc89xmkKUYjR/NDhtAcQ3yBzMtutKTrN1+jaE99SYk6uW3nDrAhGzpzDNGnDKfImFxyq5l9VPp2Wt8EEL0t2nNtQchQZoDFexi2YDWNVfRdqlkXWu9E0dOit/8N2EqbfihBFGVtJRG3Zv4LLK6wM7VxsGgAAAAASUVORK5CYII="/></span><span style='mso-ignore:vglayout2'><table cellpadding='0' cellspacing='0'><tr><td height='17' class='x29' width='75' style='visibility:hidden;position:relative;background:transparent;height:12.9pt;width:56.25pt;'>1</td></tr></table></span></td>
<td class='x26'>Green light</td>
<td class='x26'>Go!</td>
 </tr>
7

We are only using the named range in order to export a table to HTML file, so it should not matter if cell B1 is empty or contains some text in it.
Attached is the zip file containing simplified sample program to illustrate this issue,
as well as input Excel worksheet having named range “IconSetCenterAlign” for only cells from B3 to D6 and the output HTML file that contains extra columns (lines 211,212, 217, 223, etc)
Thank you.

ConditionalFormatsCenterIcons-v23.11.0.zip (14.1 KB)

8

@oraspose
Thank you for your feedback. By using sample files and code for testing, we can reproduce the issue. Additional columns were found in the exported HTML. We will continue to investigate the issue and inform you promptly of any updates.

9

@oraspose ,

We are pleased to inform you that your issue inform you that your m has been resolved. The fix will be included in an upcoming release (Aspose.Cells v24.1) that we plan to release in the first half of January2024. You will be notified when the next version is released.
Here is the result after fix for your reference: output.zip (4.1 KB)

10

The issues you have found earlier (filed as CELLSJAVA-45771) have been fixed in Aspose.Cells for Java 24.1.