#2 Serialized XML does not open in MS Excel with any data in the cells

[Jason Mathews]

The Data elements in serialized XML have an empty local namespace and are discarded in MS Excel 2013. The sheets are created correctly, but the data in the cells come up blank.

Changing the default namespace fixes the problem.

original XML:

  <ss:Cell>
     <Data xmlns="" ss:Type="String">Hello Excel!</Data>
                  ^----- error: wrong namespace won't load in MS Excel 2013
  </ss:Cell>

fixed XML:

  <ss:Cell>
    <Data ss:Type="String">Hello Excel!</Data>
 </ss:Cell>

== Patch ==

Index: src/nl/fountain/xelem/excel/ss/SSCell.java

RCS file: /cvsroot/xelem/xelem/src/nl/fountain/xelem/excel/ss/SSCell.java,v
retrieving revision 1.12
diff -c -r1.12 SSCell.java
*** src/nl/fountain/xelem/excel/ss/SSCell.java 27 Apr 2005 15:29:54 -0000 1.12
--- src/nl/fountain/xelem/excel/ss/SSCell.java 4 Feb 2015 02:46:05 -0000

---

*** 465,471 ****
}

  public Element getDataElement(Document doc) {

! Element data = doc.createElement("Data");

--- 465,472 ----
}

  public Element getDataElement(Document doc) {

! //Element data = doc.createElement("Data"); // old
! Element data = doc.createElementNS(getNameSpace(), "Data");