https://issues.apache.org/ooo/show_bug.cgi?id=123791
Bug ID: 123791
Issue Type: DEFECT
Summary: xlsx very slow to load
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Linux
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: dsik...@hotmail.com
CC: issues@openoffice.apache.org
Just installed AOO 4.0.1. for Linux (RHEL 6.4 64-bit). Computer is Lenovo W530
with 4-core i7, 16GB RAM and plenty of free disk space. I have xlsx-file sized
2.7MB, containing 4 sheets of data and one containing column graphs about data
on the other sheets. Biggest sheet has 14000+ lines and 7 columns, others have
less lines. With Excel viewer on KVM Windows 7 at the same machine it takes
some 2-3 seconds to open that file but AOO 4.0.1 takes 15 minutes and Lotus
Symphony 3.0.1 whopping 30 minutes.
[b]Following formulas used:[/b]
Column A: text like "start" or "stop"
Column B: Date, like 10/19/2013
Column C: Time, like 02:07:57.95
Column D: sum column B and C like "=B828+C828"
Column E: Mostly nothing, for commenting
Column F: =TEXT(D828;"p.k t:mm")
Column G: =ROUND((D829-D828)*$E$1;1)
AutoFilter is ON
Graph type Column, left one from the selection
Graphs data series like $Sheet1'.$F$1:$G$13954
Data series in columns
First row as label selected
First column as label selected
When I save this file to ODS format, size is 1.2MB and opening that file takes
less than 5 minutes.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
