HTML in Excel export damage it

[Robin KluthMember]

If a datafield (in my case type: string) contains any HTML-character, the created xls is defective:

If I open it, Excel say that the Sheet 1 is damaged and generate me an error log:

XML PARSE ERROR: Extraneous end-tag
Error occurs at or below this element stack:
    <ss:Workbook>
     <ss:Worksheet>
      <ss:Table>
       <ss:Row>
        <ss:Cell>
         <ss:Data>

As soon as I fill the grid with Text with HTML in it (like: This is a <i>test</i>), the created xls will not work:

That worked in previous versions of jqwidgets.

Is that a correct behaviour? I mean: Is HTML not allowed here anymore?

[DimitarParticipant]

Hello Robin Kluth,

We tested for the reported issue using the demo Spreadsheet. Excel opens the generated .xls file without an error.

We used version 2.9.3 of jQWidgets and Microsoft Excel 2010.

Please share more information on your testing conditions if the issue persists.

Best Regards,
Dimitar

jQWidgets team
http://www.jqwidgets.com/

[Robin KluthMember]

Hi Dimitar,

I’ve used 2.9.0 in my case and did a update to 3.0.0. Now it works as expected!

So, it seems that you fixed something in that direction – but I did not found any hint in the Release History.

Thanks anyway!

[Author]

Posts