I have a situation where I am working with an HTML table that includes both text and radio buttons. The issue arises when I attempt to export the table data along with the selected radio button values to Excel using the 'Export to Excel' button.
What I have noticed is that if any of the radio buttons are selected and then the 'Export to Excel' button is clicked, it causes two cells in the exported Excel sheet to merge together, combining the text from the table rows. This merging does not occur when none of the radio buttons are selected.
https://i.sstatic.net/6Xyuh.png
An image provided illustrates this issue, showing how cells without radio buttons selected get merged, while those without do not experience cell merging in 'Row 3.'
After testing across multiple computers and versions of Excel and OpenOffice Calc, I believe the problem lies within the code or logic rather than the software itself. Any insights on resolving this behavior would be greatly appreciated.
You can access the fiddle here, and the snippet of code is posted below:
{insert your JavaScript code snippet here}
{insert your CSS code snippet here}
{insert your HTML code snippet here}