poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Greg Woolsey <greg.wool...@gmail.com>
Subject Re: Pivot tables
Date Wed, 21 Mar 2018 20:43:29 GMT
The structure is actually quite convoluted, and involves multiple
components of the Zip structure, connected by relationship IDs (rId
attributes, _rels files):


If cell data is modified the corresponding PivotCacheRecords file needs to
be updated as well.  If the definition is changed (selecting different
metrics, etc.) again the cache needs to be rebuilt/updated.  Changing the
definition can (and most likely will) change the PivotTable area reference.

Excel has a ton of management code and functionality around keeping all
these in sync as the user makes changes.  POI has none of that yet.

On Wed, Mar 21, 2018 at 1:33 PM Blake Watson <blake.watson@pnmac.com> wrote:

> The CT for a (simple) pivot table section seems simple enough. I'm seeing
> this part, though, which I believe is for the data source:
> <main:location firstDataCol=\"1\" firstDataRow=\"2\" firstHeaderRow=\"1\"
> ref=\"A3:D7\"/>
> ​
> ​firstDataCol and firstDataRow (with firstHeaderRow) are the source, and
> ​A3:D7 is the target. The A3:D7 sheet is the one I pulled the CT from. I
> don't see where firstDataCol, firstDataRow and firstHeaderRow are mapped to
> a specific sheet!
> ===Blake===

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message