Calc/Proposal DataPilot byIBM

Background

Low performance when update a datapilot table
  Environment: Hardware: IBM T30  CPU: 2.4 GHz  Memory:1.0 GB Operation System: Window XP SP2
  Sample file: The datapilot table's source data have 5000 rows.
File:Pvt test result.jpg
Crash
  Insert two field into row area ( Each field have about 1000 members ),it causes freezing and crash.

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's data is stored in a big structure.
Set too many times of 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