Difference between revisions of "Calc/Proposal DataPilot byIBM"
From Apache OpenOffice Wiki
< Calc
((checkpoint save)) |
((checkpoint save)) |
||
| Line 3: | Line 3: | ||
== | == | ||
== Problem Description == | == Problem Description == | ||
| − | '''Allocate | + | '''Allocate a lot of abundant data''' |
For a simple datapilot table: | For a simple datapilot table: | ||
[[Image:simple dptable.jpg]] | [[Image:simple dptable.jpg]] | ||
| Line 12: | Line 12: | ||
Some borders are set twice or more. | Some borders are set twice or more. | ||
== Solution == | == Solution == | ||
| − | + | '''Data Source buffer''' | |
| + | A document stored a source buffer array. Every table have a buffer id. The datapilot table can use the same id if they have same data source. | ||
| + | In the buffer, the members of a field can be identified by an id( the sorted index ). | ||
| + | Then in the output table's algorithm the ScDPItemData structure is replaced by an id. | ||
| + | '''Only allocate visible member''' | ||
| + | '''Enhancement of setting the border style''' | ||
Revision as of 06:59, 23 June 2009
Background
==
Problem Description
Allocate a lot of abundant data
For a simple datapilot table:
Member A1 in L1 field will create a array for all members {B1,B2,B3}. But only B1 is visible and valid.
Allocate too much memories
Every member stored a big structure.
Set too many border styles for output area
Some borders are set twice or more.
Solution
Data Source buffer A document stored a source buffer array. Every table have a buffer id. The datapilot table can use the same id if they have same data source. In the buffer, the members of a field can be identified by an id( the sorted index ). Then in the output table's algorithm the ScDPItemData structure is replaced by an id. Only allocate visible member Enhancement of setting the border style
