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 2014/07/07 23:10:41 UTC
[Issue 125218] New: calc slow saving in xls
https://issues.apache.org/ooo/show_bug.cgi?id=125218
Issue ID: 125218
Issue Type: DEFECT
Summary: calc slow saving in xls
Product: Calc
Version: 4.1.0
Hardware: Mac
OS: Mac OSX, 10.8
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: save-export
Assignee: issues@openoffice.apache.org
Reporter: eric.gunderson+apache@gmail.com
Since updating from 4.0.1 to 4.1.0, the time to save certain XLS documents has
increased from a few seconds to a few (3 to 20) minutes.
This may be a bug that was reintroduced, please look at ISSUE ID 122827. I had
this same problem in 4.0.0. It was fixed in 4.0.1.
https://issues.apache.org/ooo/show_bug.cgi?id=122827
The problem file is 558KB, it has some simple cell calculations, and multiple
sheets.
Non-problem files are 100KB or less and have few if any cell calculations or
contain single sheets.
To reproduce the problem please download the attachment from ISSUE 122827.
https://issues.apache.org/ooo/attachment.cgi?id=81137
Add a cell value.
Save the document.
The save time for this document was in the 90 to 120 seconds range.
I expect most saves to take less than 10 seconds.
MacBook Pro
2.2 GHz Intel Core 2 Duo
2 GB 667 MHz DDR2 SDRAM
OS X 10.8.5
THANKS
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
--- Comment #6 from Eric Gunderson <er...@gmail.com> ---
Yeah, you should be able to make any edit to the spreadsheet and save it, then
the problem occurs.
I tried it out on a Windows Vista running AOO4.1.0. But I could not reproduce.
I just tried uninstalling and reinstalling AOO4.1.0 on the Mac OS X 10.8.5.
It's still saving slow.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
--- Comment #9 from oooforum <oo...@free.fr> ---
(In reply to Eric Gunderson from comment #8)
> Will that reset the profile?
Read this: https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426
You should take your questions to our support forum. They can help you.
The Bugzilla system is for reporting specific, detailed, reproducible bugs that
developers can investigate and fix.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
--- Comment #4 from Eric Gunderson <er...@gmail.com> ---
I'm running:
AOO410m18(Build:9764) - Rev. 1589052
2014-04-15 11:15:48 (Tue, 15 Apr 2014)
I checked the source code for the files in this revision
(http://svn.apache.org/viewvc?view=revision&revision=1518253).
I noticed this comment in the source.
// Loop backwards from the end instead of using Search, assuming that
// there usually aren't many attributes below the last cell.
This got me thinking that maybe my problem has to do with the formatting of the
cells. So I selected all the cells and did default formatting on all my sheets.
This fixed my problem spreadsheets so that they would save quickly.
I've created a new spreadsheet (and attached it here) that took close to 20
minutes to save.
I simply created a new document and the only formatting I added was to make the
first column as a "Date". The other columns were given background colors.
As you duplicate the sheet the save time will get worse and worse.
With only 3 sheets it took about one minute.
With 40 sheets it took 20 minutes.
I should also mention that the memory usage goes way up when saving occurs, and
slows down the whole computer.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
--- Comment #5 from Armin Le Grand <Ar...@me.com> ---
Tried with the attachment from comment 2, loaded in Win pro version of AOO411.
Changed (added a word in one empty cell) save as -> one second.
Maybe I am doing the wrong change? What *exactly* do I have to change to get a
slow save? Should I already get one by
- load SlowSave.xls
- save as changed filename
...? Still cannot reproduce.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
oooforum <oo...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oooforum@free.fr
--- Comment #7 from oooforum <oo...@free.fr> ---
(In reply to Eric Gunderson from comment #6)
> I just tried uninstalling and reinstalling AOO4.1.0 on the Mac OS X 10.8.5.
Did you reset your profile between this 2 steps?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
--- Comment #2 from Eric Gunderson <er...@gmail.com> ---
Created attachment 83668
--> https://issues.apache.org/ooo/attachment.cgi?id=83668&action=edit
Spreadsheet with formatting that causes a slow save.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
Armin Le Grand <Ar...@me.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |Armin.Le.Grand@me.com
--- Comment #1 from Armin Le Grand <Ar...@me.com> ---
File is: 2013 Market Accounting.xls, checked on Win version, could not
reproduce the problem:
7s on AOO420 (with debug)
1s on AOO411 pro
Tried on mac with AOO411 pro, the same -> very fast.
Tried also on mac with AOO410 debug -> also very fast.
Could not reproduce.
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
--- Comment #8 from Eric Gunderson <er...@gmail.com> ---
(In reply to oooforum from comment #7)
> > I just tried uninstalling and reinstalling AOO4.1.0 on the Mac OS X 10.8.5.
> Did you reset your profile between this 2 steps?
Yes, I think so. I removed what I could find in the /Users/{account}/Library/
in regards to OpenOffice.
I removed the following.
Library/Application Support/OpenOffice
Library/Application Support/OpenOffice.org
Library/Preferences/org.openoffice.script.LSSharedFileList.plist
Library/Preferences/org.openoffice.script.plist
I also removed a folder "org.openoffice.script", but I can't remember where it
was in the Library structure.
I removed all of that before reinstalling AOO4.1.0.
Will that reset the profile?
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.
[Issue 125218] calc slow saving in xls
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=125218
--- Comment #3 from Eric Gunderson <er...@gmail.com> ---
This document took ~20 minutes to save.
https://issues.apache.org/ooo/attachment.cgi?id=83668
--
You are receiving this mail because:
You are the assignee for the issue.
You are watching all issue changes.