You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/08/16 04:17:24 UTC

[Bug 120586] New: optimize 'updaterowheights' in loading procedure to improve xls loading performance.

https://issues.apache.org/ooo/show_bug.cgi?id=120586

          Priority: P3
            Bug ID: 120586
          Assignee: ooo-issues@incubator.apache.org
           Summary: optimize 'updaterowheights' in loading procedure to
                    improve xls loading performance.
          Severity: normal
        Issue Type: DEFECT
    Classification: Code
                OS: All
          Reporter: lizh.fee@gmail.com
          Hardware: All
            Status: UNCONFIRMED
           Version: AOO 3.4.0
         Component: www
           Product: performance

In filter process, record which sheet will contain sdrobject, then only do
'updaterowheights' for visible sheet and sheet containing sdrobject.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120586] optimize 'updaterowheights' in loading procedure to improve xls loading performance.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120586

--- Comment #4 from SVN Robot <sv...@dev.null.org> ---
"leiw" committed SVN revision 1384699 into trunk:
#i120586 optimize 'updaterowheights' in loading procedure to improve xls
load...

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120586] optimize 'updaterowheights' in loading procedure to improve xls loading performance.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120586

--- Comment #1 from lizh.fee@gmail.com ---
This patch is only for optimizing excel8 type. 
In filter process, just update row heights for : 1. visible sheet, 2. sheet
containing sdrobject.

following is test result for sample file sc_complex_13sh_4kcell.xls(manual
test), about 20% improvement. 
old: 3.90 3.93 3.78 3.75 3.75 3.85 3.84 3.87 4.00 4.00    avg:3.87
new: 3.03 3.03 3.06 3.03 3.06 3.09 3.06 3.12 3.09 3.15      avg:3.07

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120586] optimize 'updaterowheights' in loading procedure to improve xls loading performance.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120586

lizh.fee@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
  Attachment #79080|                            |review?
              Flags|                            |

--- Comment #2 from lizh.fee@gmail.com ---
Created attachment 79080
  --> https://issues.apache.org/ooo/attachment.cgi?id=79080&action=edit
patch to improve xls loading performance

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120586] optimize 'updaterowheights' in loading procedure to improve xls loading performance.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120586

Wang Lei <le...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
                 CC|                            |leiw@apache.org
          Component|www                         |code
         Resolution|---                         |FIXED
   Target Milestone|not determined              |AOO 3.5.0

--- Comment #5 from Wang Lei <le...@apache.org> ---
Submit in revision 1384699

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120586] optimize 'updaterowheights' in loading procedure to improve xls loading performance.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120586

lizh.fee@gmail.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Issue Type|DEFECT                      |ENHANCEMENT

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120586] [From Symphony] optimize 'updaterowheights' in loading procedure to improve xls loading performance.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120586

Shenfeng Liu <li...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |liushenf@gmail.com
            Summary|optimize 'updaterowheights' |[From Symphony] optimize
                   |in loading procedure to     |'updaterowheights' in
                   |improve xls loading         |loading procedure to
                   |performance.                |improve xls loading
                   |                            |performance.

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Bug 120586] optimize 'updaterowheights' in loading procedure to improve xls loading performance.

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120586

--- Comment #3 from lizh.fee@gmail.com ---
Created attachment 79081
  --> https://issues.apache.org/ooo/attachment.cgi?id=79081&action=edit
sample

-- 
You are receiving this mail because:
You are the assignee for the bug.