http://bugs.winehq.org/show_bug.cgi?id=21417
Summary: opening large files in excel 2000 takes very long, cannot save Product: Wine Version: 1.1.36 Platform: x86 OS/Version: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: -unknown AssignedTo: wine-bugs@winehq.org ReportedBy: jan-winehq@h-i-s.nl
opening large files in excel 2000 takes very long, cannot save these files. Regression since 1.33; reverting to 1.33 solves the problem. May be remnant of big bug introduced in 1.34. I was not able to use office suite in 1.34 and 1.35 at all. 1.36 looks better, but has not everything solved.
http://bugs.winehq.org/show_bug.cgi?id=21417
Andrew Nguyen arethusa26@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords| |regression
--- Comment #1 from Andrew Nguyen arethusa26@gmail.com 2010-01-19 02:14:59 --- Please perform a regression test:
http://wiki.winehq.org/RegressionTesting
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #2 from Jan Hoogenraad jan-winehq@h-i-s.nl 2010-03-02 10:15:15 --- I do not have the wine sources installed, so running git etc. will take me a while. I just tried wine-1.38: I still have problems saving, expecially with large files and/or links to other workbooks. I will revert again to 1.33.
Is there any logging I could take off the 1.38 that would be helpful, short of running bisects ?
http://bugs.winehq.org/show_bug.cgi?id=21417
Wylda wylda@volny.cz changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |wylda@volny.cz
--- Comment #3 from Wylda wylda@volny.cz 2010-03-02 10:23:29 --- Could you attach such an excel file(compresed), which causes you toubles? I can do a regression test for you For FREE!! :-))
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #4 from Jan Hoogenraad jan-winehq@h-i-s.nl 2010-03-25 11:11:26 --- Thanks a lot for the offer. I will follow-up on that. I need to create a file (still unsure how). Tried 1.40 on a customer's file (cannot expose the data here) with the same effect. Again in the process of downgrading to 1.33...
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #5 from Wylda wylda@volny.cz 2010-04-21 16:29:10 ---
OK, i made cca 2MB excel sheet (table from test.winehq.org copied many times) having more than 10000 rows. In 1.1.33 opens immediately, in 1.1.43 takes more than 15sec, so slowdown few thousands %.
1. Confirming, please consider UNCONFIRMED->NEW and COMPONENT: Ole32
2. I did a regression test between 1.1.34 and 1.1.35:
commit 226363f5dfb9caa8313e425c7f85ed9fe581f1fe Author: Vincent Povirk vincent@codeweavers.com Date: Fri Dec 4 17:33:50 2009 -0600
ole32: Implement transacted storage.
:040000 040000 79e7adf6177afe9cb8bfdea75270edb00026c5e5 abc173741982ee971ac490738917d735c6869a78 M dlls
3. No other bug report suffers from this commit.
4. Revert of this patch after git checkout makes that problem go away.
5. Adding author of this patch to CC.
--private keyword: bisected
http://bugs.winehq.org/show_bug.cgi?id=21417
Wylda wylda@volny.cz changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |madewokherd@gmail.com
http://bugs.winehq.org/show_bug.cgi?id=21417
Vitaliy Margolen vitaliy@kievinfo.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|UNCONFIRMED |NEW Component|-unknown |ole32 Ever Confirmed|0 |1
--- Comment #6 from Vitaliy Margolen vitaliy@kievinfo.com 2010-04-22 00:03:12 --- Confirming per comment 5.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #7 from Vincent Povirk madewokherd@gmail.com 2010-06-05 11:30:16 --- Transacted storage has been rewritten to improve this. Please retest.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #8 from Jan Hoogenraad jan-winehq@h-i-s.nl 2010-06-07 01:59:49 --- Log read time still present in wine-1.2-rc2-111-g9aa9a12. I tried to unto the mentioned patch by
git show 226363f5dfb9caa8313e425c7f85ed9fe581f1fe | patch -p1 -R But got the following output (which I cannot not understand as I am not very familiar with git)
patching file dlls/ole32/storage32.c Unreversed patch detected! Ignore -R? [n] n Apply anyway? [n] n Skipping patch.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #9 from Wylda wylda@volny.cz 2010-06-08 06:26:56 --- (In reply to comment #7)
Transacted storage has been rewritten to improve this. Please retest.
Hi Vincent, i did some tests:
* 0.1 sec in wine-1.1.34 * 25.0 sec in wine-1.2-rc2-197-ge1fd439
Probably the difference is much bigger, because in case of 1.1.34 it's unmeasurable _fast_ (when you click you have it).
@Jan Hoogenraad: Your revert fails on top of current git because the wine code changed significantly since 1.1.34. So you can't easily revert.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #10 from Jan Hoogenraad jan-winehq@h-i-s.nl 2010-06-15 23:52:49 --- To me, this is the only significant bug left in wine-1.2-rc3. I now still run in 1.33, as some files take > half an hour to open in wine-1.2-rc3. (1.33: less than a minute).
http://bugs.winehq.org/show_bug.cgi?id=21417
Jan Hoogenraad jan-winehq@h-i-s.nl changed:
What |Removed |Added ---------------------------------------------------------------------------- Summary|opening large files in |opening large files in |excel 2000 takes very long, |excel 2000 takes very long |cannot save |
--- Comment #11 from Jan Hoogenraad jan-winehq@h-i-s.nl 2010-08-10 07:56:38 --- I did a quick check. The problem is still present in wine-1.3.0-166-g277040d
During opening of large file: EXCEL.EXE takes max CPU, sometime for hours. I am reverting back to 1.33, the last useful wine version for me.
http://bugs.winehq.org/show_bug.cgi?id=21417
Austin English austinenglish@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |flavio.becker@gmail.com
--- Comment #12 from Austin English austinenglish@gmail.com 2010-08-16 23:56:11 --- *** Bug 23987 has been marked as a duplicate of this bug. ***
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #13 from Flavio Becker flavio.becker@gmail.com 2010-08-17 09:01:41 --- (In reply to comment #12)
*** Bug 23987 has been marked as a duplicate of this bug. ***
Ok, I originaly filed the bug 23987 and I accept that it is very similar to this other one, except that I can successfully use Wine 1.2 to work with excel 2007 with no measurable delay openning "normal" spreadsheets. Working with huge files though there is indeed some delay compared to the same spreadsheet openning with openoffice but it's still very acceptable. In fact I've been working with Office 2007 since wine 1.1.42 with almost no problems. For now 1.2 is the best wine version I know and my sugestion is to not update to wine 1.3.0 .
Flavio Becker
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #14 from Vincent Povirk madewokherd@gmail.com 2010-08-26 22:05:11 --- 89646084ba281366d69b1cd8fb168d9440cf3569 should fix the worst of the performance issues. Please retest.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #15 from Wylda wylda@volny.cz 2010-08-27 09:36:58 --- (In reply to comment #14)
89646084ba281366d69b1cd8fb168d9440cf3569 should fix the worst of the performance issues. Please retest.
Can't compare with comment #9. Now i have stronger machine, so complete retest:
* 0.1 sec in wine-1.1.34 * 140.0 sec in wine-1.3.0 * 15.0 sec in wine-1.3.1-221-gf6bcd27
So well... better now, but far a way from 1.1.34, so i would keep this bug opened for some time yet.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #16 from Jan Hoogenraad jan-winehq@h-i-s.nl 2010-10-27 00:48:42 CDT --- I retried the current git (also because I wanted to see what happened to other bugs). One 16 MB excel sheet did not open for 9 hours (100 % CPU usage on process EXCEL) in excel 2000. Reverting to 1.1.33~winehq0~ubuntu~9.04-0ubuntu1 made it very quick (<0.3 sec) again. So I need to stay at 1.1.33.
http://bugs.winehq.org/show_bug.cgi?id=21417
André H. nerv@dawncrow.de changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |nerv@dawncrow.de Regression SHA1| |226363f5dfb9caa8313e425c7f8 | |5ed9fe581f1fe
http://bugs.winehq.org/show_bug.cgi?id=21417
Bruno Jesus 00cpxxx@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |00cpxxx@gmail.com
--- Comment #17 from Bruno Jesus 00cpxxx@gmail.com 2011-10-02 07:31:58 CDT --- Still present in 1.3.29?
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #18 from Flavio Becker flavio.becker@gmail.com 2011-10-03 16:17:24 CDT --- (In reply to comment #17)
Still present in 1.3.29?
Well, my wine is still at 1.3.28 but I confirm that the bug is not present any more. I'll test again when I update.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #19 from Bruno Jesus 00cpxxx@gmail.com 2011-10-03 16:32:17 CDT --- If you have the testfile you can attach it here (compressed if necessary) so others can test too.
Are you testing in the same hardware from before?
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #20 from Jan Hoogenraad jan-winehq@h-i-s.nl 2011-10-03 16:47:31 CDT --- I will need to set up a non-packaged wine environment to check the versions. Furthermore, I have a much faster machine now to test, and thus the impact of the bug has diminished for me.
See if someone can repeat the test of #15.
http://bugs.winehq.org/show_bug.cgi?id=21417
--- Comment #21 from Flavio Becker flavio.becker@gmail.com 2011-10-03 16:57:50 CDT --- (In reply to comment #20)
I will need to set up a non-packaged wine environment to check the versions. Furthermore, I have a much faster machine now to test, and thus the impact of the bug has diminished for me.
See if someone can repeat the test of #15.
(In reply to comment #19)
If you have the testfile you can attach it here (compressed if necessary) so others can test too.
Are you testing in the same hardware from before?
In fact my hardware is quite the same but I didn't do the tests with a special file. I just picked some spreadsheets around and tried them. Many users at my job reported the same issue and we had to stuck at 1.2.3 to "solve" the problem. I am going to do some more tests before I update my users versions as there are bad issues with other office 2007 components and I need to test them too.
http://bugs.winehq.org/show_bug.cgi?id=21417
Wylda wylda@volny.cz changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED
--- Comment #22 from Wylda wylda@volny.cz 2011-12-03 03:53:54 CST ---
See if someone can repeat the test of #15.
OK, me again:
* wine-1.3.0 = 142sec * wine-1.3.1 = 138sec * wine-1.3.2 = 14sec * wine-1.3.5 = 14sec * wine-1.3.10 = 0.1sec * wine-1.3.20 = 0.1sec * wine-1.3.34 = 0.1sec
so FIXED some time ago :)
http://bugs.winehq.org/show_bug.cgi?id=21417
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #23 from Alexandre Julliard julliard@winehq.org 2011-12-16 13:30:53 CST --- Closing bugs fixed in 1.3.35.
-
wine-bugs＠winehq.org