search

stephen-hardy / xlsx.js

XLSX.js is a JavaScript library for converting the data in base64 XLSX files into JavaScript objects - and back! Please note that this library is licensed under the Microsoft Office Extensible File License - a license NOT approved by the OSI. While this license is based off of the MS-PL, which is OSI-approved, there are significant differences.
http://blog.innovatejs.com/?tag=xlsx-js
Other
575 stars 122 forks source link

Splitting sharedStrings containing runs #9

Open JonasEngberg opened 11 years ago

JonasEngberg commented 11 years ago

When cell text contains different formating (Donald Duck) the sharedStrings array become wrong.

The array should combined the <t>s in <si> eg 'Donald Duck' but is incorrectly split into 'Donald ' and 'Duck'.

sharedString.xml

<si>
  <r>
    <t xml:space="preserve">Donald </t>
  </r>
  <r><rPr><b/><sz val="11"/><color theme="1"/><rFont val="Calibri"/><family val="2"/><scheme val="minor"/></rPr>
      <t>Duck</t>
  </r>
</si>
ro-ka commented 11 years ago

Having this problem, too. Will fix this and send a pull request.