I worked on this a little bit and found some interesting things. If I add the
formulas to the cells AFTER I make it a TotalsRow, the formulas work (without
using a named range) and are in the TotalsRow. However I still can't figure out
how to get the label for the first column to show. The table xml is pretty much
exactly the same. The differences are in the sheet itself, specifically in the
row I want to have the totals row in. Below are the POI and Excel 2007 versions
of the row. I've got other things keeping me away from this at the moment. I'm
not sure what the <v> element is all about, but that's the only big difference
I see, so I was thinking about manually changing that to see what happens.
Maybe later this evening.
POI:
<row r="5">
<c r="A5" t="s">
<v>9</v>
</c>
<c r="B5" t="s">
<f>SUBTOTAL(103,B2:B4)</f>
</c>
<c r="C5">
<f>SUBTOTAL(103,C2:C4)</f>
</c>
<c r="D5" t="s">
<f>SUBTOTAL(103,D2:D4)</f>
</c>
</row>
Excel 2007:
<row r="5" spans="1:10" x14ac:dyDescent="0.25">
<c r="A5" t="s">
<v>15</v>
</c>
<c r="B5">
<f>SUBTOTAL(103,MYTABLE['#])</f>
<v>3</v>
</c>
<c r="C5">
<f>SUBTOTAL(103,MYTABLE[%])</f>
<v>3</v>
</c>
<c r="D5">
<f>SUBTOTAL(103,MYTABLE[Human])</f>
<v>3</v>
</c>
</row>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
