On Tue, 5 Jul 2011, Christian Lercher wrote:
1. styles.xml gets a new entry:
<cellXfs count="2">
<xf numFmtId="0" fontId="0" fillId="0" borderId="0" xfId="0" />
<xf numFmtId="49" fontId="0" fillId="0" borderId="0" xfId="0"
applyNumberFormat="1" />
</cellXfs>
There are two bits in that entry of interest:
* numFmtId="49"
* applyNumberFormat="1"
I suspect both may be needed.
2. sheet1.xml gets a new entry:
<cols>
<col min="1" max="1" width="11.42578125" style="1" />
</cols>
That means the 1st column has a style. If you use POI to set a default
column style, do you get the same? (I'd expect you to). And if you set up
the style to be the same as excel gives you (i.e. with number format 49,
and apply number format set), does it behave the same or not?
3. sheet1.xml gets a new attribute "s" on the "c" element:
<c r="A1" s="1">
<v>55</v>
</c>
Looks like the cell has an explicit style set on it, rather than relying
on the column default, interesting. If you were to manually remove that
style s="1" entry, what does excel show for the cell, styled or not?
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
