Hi all,
I am Wang Xu Ming, the dev lead of DataPilot of Lotus Symphony.
I did not write some details because it is too detail and do not know if
it is proper.
Here answer Niklas's mail below in blue:
- The data in the Quantify screenshot looks strange. For any larger
calculation, screen output (OutputDevice::DrawLine) shouldn't play a
significant role.
It maybe relate to Quantify environment - drawing is very slow.
Actually, ScAttrArray::ApplyBlockFrame is a low performance function.
If the output table about 10000 rows, ScDPOutput::Output() used 8-10
seconds in our test environment.
Current solution, to data area in the table:
Case 1: all cells need set border, then setting block frame border only
once is ok.
Case 2: otherwise, set block frame border like this
|----------+----------+----------|
| | | |
|----------+----------+----------|
| | | |
|----------+----------+----------|
| | | |
|----------+----------+----------|
| | | |
|----------+----------+----------|
| | | |
|----------+----------+----------|
| | | |
|----------+----------+----------|
| | | |
|----------+----------+----------|
- "Data Source buffer" sounds interesting. Now it would of course be
helpful to see the actual code changes for it.
It is something like Excel's PivotCache, and better to save it in the
document file.
If that, we need the approval of the ODF format proposal relate it.
- The allocation for all members (B1,B2,B3) is what issue 55266 is
about. In the "Solution Description" section, there's only the heading.
Do you have a solution for that?
I have a solution in LateInitFrom. To row data, only new
ScDPResultMember when find it.
Sincerely,
Xu Ming Wang
Lotus Symphony
China Software Development Laboratory,Beijing
Phone: 010-82453493
E-mail : wang...@cn.ibm.com
Niklas Nebel
<niklas.ne...@sun
.COM> To
Sent by: dev@sc.openoffice.org
niklas.ne...@sun. cc
COM
Subject
Re: [sc-dev] about DataPilot
2009-06-24 00:51
Please respond to
d...@sc.openoffice
.org
On 06/23/09 17:24, Zhi Yu Yue wrote:
> Struggled a little with the wiki editing, and here is the performance
> part. Thanks, Xu
>
Ming!http://wiki.services.openoffice.org/wiki/Calc/Proposal_DataPilot_byIBM
Great, thanks. Some comments:
- The data in the Quantify screenshot looks strange. For any larger
calculation, screen output (OutputDevice::DrawLine) shouldn't play a
significant role.
- "Data Source buffer" sounds interesting. Now it would of course be
helpful to see the actual code changes for it.
- The allocation for all members (B1,B2,B3) is what issue 55266 is
about. In the "Solution Description" section, there's only the heading.
Do you have a solution for that?
> Not completed, but should be OK to start some discussion. We will then
> turn to the UX spec.
For the UI features, note that Kohei's changes are now available, with a
description at
http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_enhanced_field_popup_window
and
http://wiki.services.openoffice.org/wiki/Calc/Features/DataPilot_custom_display_names
.
You should take a look at that and see where your proposed changes are
different.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@sc.openoffice.org
For additional commands, e-mail: dev-h...@sc.openoffice.org
