http://bugs.winehq.org/show_bug.cgi?id=25754
Summary: Excel Workbook with Macros Is not Running : Getting Crashed. Product: Wine Version: unspecified Platform: x86 OS/Version: Linux Status: UNCONFIRMED Severity: normal Priority: P2 Component: -unknown AssignedTo: wine-bugs@winehq.org ReportedBy: ajeet_singh1978@yahoo.co.in
I have just installed the microsoft office and tried to open a Excel Workbook containing the Macros specific to the workbook, but whenever i open this excel and it gets crashed.
Same workbook is running fine in Windows.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #1 from Nikolay Sivov bunglehead@gmail.com 2011-01-11 07:14:27 CST --- Specify wine version, excel version and attach complete terminal output as a text file. If it's possible attach excel document too.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #2 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-11 07:45:40 CST --- [ajeets@virus ~]$ wine --version wine-1.3.8
MS Office 2007.
http://bugs.winehq.org/show_bug.cgi?id=25754
Nikolay Sivov bunglehead@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Version|unspecified |1.3.8
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #3 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-11 07:52:44 CST --- Created an attachment (id=32815) --> (http://bugs.winehq.org/attachment.cgi?id=32815) Attached are the logs / command prompt output
Please find the attached command prompt output nohup.out and nohup2.out
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #4 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-11 07:55:10 CST --- Created an attachment (id=32816) --> (http://bugs.winehq.org/attachment.cgi?id=32816) part2 of command prompt output
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #5 from Nikolay Sivov bunglehead@gmail.com 2011-01-11 08:06:46 CST --- Ok, update to 1.3.11 first, it contains some bug fixes for that issue. Attach new trace after that as a single file, compress it if needed.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #6 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-11 08:34:32 CST --- Ok. Current update available is 1.3.9, but i have found the source code for 1.3.11, just compiling it.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #7 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-11 09:01:07 CST --- Same problem after 1.3.11 as well, attached is nohup.out.tar.bz2
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #8 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-11 09:02:15 CST --- Created an attachment (id=32817) --> (http://bugs.winehq.org/attachment.cgi?id=32817) nohup.out.tar.bz2 after 1.3.11
http://bugs.winehq.org/show_bug.cgi?id=25754
Nikolay Sivov bunglehead@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Attachment #32815|1 |0 is patch| | Attachment #32815|0 |1 is obsolete| |
http://bugs.winehq.org/show_bug.cgi?id=25754
Nikolay Sivov bunglehead@gmail.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Attachment #32816|1 |0 is patch| | Attachment #32816|0 |1 is obsolete| |
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #9 from Nikolay Sivov bunglehead@gmail.com 2011-01-11 16:39:35 CST --- Ok, now let me see +typelib2,+tid log.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #10 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 03:55:41 CST --- (In reply to comment #9)
Ok, now let me see +typelib2,+tid log.
Can you please elaborate it more, do you need something from myside?
+typelib2? +tid log ?
http://bugs.winehq.org/show_bug.cgi?id=25754
Rosanne DiMesio dimesio@earthlink.net changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords| |regression Status|UNCONFIRMED |NEW CC| |aeikum@codeweavers.com Component|-unknown |oleaut32 Ever Confirmed|0 |1
--- Comment #11 from Rosanne DiMesio dimesio@earthlink.net 2011-01-12 08:55:11 CST --- Confirming; Excel crashes trying to run any macro. This affects every version of Excel I have (97, 2003, 2007, 2010), and it's also a regression:
c0f120db5d6b72917dd9bb1e4630f2b6ff6960a6 is first bad commit commit c0f120db5d6b72917dd9bb1e4630f2b6ff6960a6 Author: Andrew Eikum aeikum@codeweavers.com Date: Tue Nov 9 16:04:10 2010 -0600
oleaut32: Search inherited interfaces again in ITypeComp::Bind.
:040000 040000 3b22bce11b0e5dc9df0c30658009c45a0bae7955 add823888e853fc234e1991a6aed674b456c56e8 M dlls
Reverting that commit fixes the crash.
http://bugs.winehq.org/show_bug.cgi?id=25754
Rosanne DiMesio dimesio@earthlink.net changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |dimesio@earthlink.net
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #12 from Andrew Eikum aeikum@codeweavers.com 2011-01-12 09:43:24 CST --- I probably won't have time to look into this today, but here's some thoughts if someone else does.
The original commit modifying Bind was 3173305e887775624d46f7cc65283723886930c0. This had a bug which prevented inherited interfaces from being searched, and this was fixed by c0f120db5d6b72917dd9bb1e4630f2b6ff6960a6.
From a brief look, it seems that Bind is returning bad data, which causes a
crash somewhat later. The crash doesn't take place in Bind itself.
Perhaps some of the inherited interfaces shouldn't be searched? Maybe one of the pointers to an inherited interface is wrong?
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #13 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 09:46:33 CST --- Will there be any fix available soon or any alternative?
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #14 from Andrew Eikum aeikum@codeweavers.com 2011-01-12 09:49:07 CST --- And some detailed steps to reproduce.
In Excel, make sure Macros are enabled (Tools->Options->Security tab->Macros...). Go to Tools -> Macro -> Record New Macro Press OK Type some junk into any cell and press Enter Click the Stop button Use Tools -> Macro -> Macros... to Run the macro you just made
You can save the file before the last step so you don't have to re-do the steps every time it crashes.
Will there be any fix available soon or any alternative?
There might be a fix in the next release, if someone gets around to it. Otherwise, you can revert the bad commit from a Git repository with the latest version of Wine checked out: git revert c0f120db5d6b72917dd9bb1e4630f2b6ff6960a6 Then rebuild Wine.
Note that this might cause other problems, as the behavior fixed in that commit is legitimate.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #15 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 09:53:12 CST --- (In reply to comment #14)
And some detailed steps to reproduce.
In Excel, make sure Macros are enabled (Tools->Options->Security tab->Macros...). Go to Tools -> Macro -> Record New Macro Press OK Type some junk into any cell and press Enter Click the Stop button Use Tools -> Macro -> Macros... to Run the macro you just made
You can save the file before the last step so you don't have to re-do the steps every time it crashes.
Andrew its not the case that when I am making new macros then it is getting crashed, it is getting crashed when I am having a workbook or sheet with lot of macros and user form controls, even if i click the Tools -> Macro it gets hang and gets crashed after sometime.
Will there be any fix available soon or any alternative?
There might be a fix in the next release, if someone gets around to it. Otherwise, you can revert the bad commit from a Git repository with the latest version of Wine checked out: git revert c0f120db5d6b72917dd9bb1e4630f2b6ff6960a6 Then rebuild Wine.
Note that this might cause other problems, as the behavior fixed in that commit is legitimate.
I might give a try to this one and check what is there for me...
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #16 from Andrew Eikum aeikum@codeweavers.com 2011-01-12 10:00:33 CST --- (In reply to comment #15)
Andrew its not the case that when I am making new macros then it is getting crashed, it is getting crashed when I am having a workbook or sheet with lot of macros and user form controls, even if i click the Tools -> Macro it gets hang and gets crashed after sometime.
When you get crashes with macros, it's very important to specify _exactly_ how to reproduce the crash. If the best you can do is provide a "crashy" file, that's okay too. This helps prevent confusion like this.
There are lots of problems with Office macros and typelib in general. I have some work done that will fix a lot of problems, but it's a major re-working of Wine's typelib support and will take quite some time to complete. User forms are known not to work, and that specific problem isn't caused by my commit.
The crash I described above is caused by my commit, as Rosanne found, and should be fixed. If there are other bugs, please file those separately, and again, make it very clear how to reproduce the crash.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #17 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 10:07:02 CST --- (In reply to comment #16)
(In reply to comment #15)
Andrew its not the case that when I am making new macros then it is getting crashed, it is getting crashed when I am having a workbook or sheet with lot of macros and user form controls, even if i click the Tools -> Macro it gets hang and gets crashed after sometime.
When you get crashes with macros, it's very important to specify _exactly_ how to reproduce the crash. If the best you can do is provide a "crashy" file, that's okay too. This helps prevent confusion like this.
There are lots of problems with Office macros and typelib in general. I have some work done that will fix a lot of problems, but it's a major re-working of Wine's typelib support and will take quite some time to complete. User forms are known not to work, and that specific problem isn't caused by my commit.
The crash I described above is caused by my commit, as Rosanne found, and should be fixed. If there are other bugs, please file those separately, and again, make it very clear how to reproduce the crash.
(In reply to comment #16)
(In reply to comment #15)
Andrew its not the case that when I am making new macros then it is getting crashed, it is getting crashed when I am having a workbook or sheet with lot of macros and user form controls, even if i click the Tools -> Macro it gets hang and gets crashed after sometime.
When you get crashes with macros, it's very important to specify _exactly_ how to reproduce the crash. If the best you can do is provide a "crashy" file, that's okay too. This helps prevent confusion like this.
There are lots of problems with Office macros and typelib in general. I have some work done that will fix a lot of problems, but it's a major re-working of Wine's typelib support and will take quite some time to complete. User forms are known not to work, and that specific problem isn't caused by my commit.
The crash I described above is caused by my commit, as Rosanne found, and should be fixed. If there are other bugs, please file those separately, and again, make it very clear how to reproduce the crash.
No where i said that that making new macros are creating problem, when you gave me that suggestion.
Yeah I missed to tell that this workbook also contains forms. And the moment I try to click on button which is supposed to run macros and forms or when I try to click on Tools -> Macros to see / edit macros, the application gets crashed.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #18 from Andrew Eikum aeikum@codeweavers.com 2011-01-12 10:12:34 CST ---
Yeah I missed to tell that this workbook also contains forms. And the moment I try to click on button which is supposed to run macros and forms or when I try to click on Tools -> Macros to see / edit macros, the application gets crashed.
You're getting a crash on the Tools->Macros->Macros... dialog? I haven't seen that before. Can you attach your Excel document to this bug? If not, can you create a new, similar document that also has that crash?
I think it's unlikely that all of your problems will be fixed soon (like I said, macros are pretty broken), but having more test data will help diagnose the problem.
Thanks for your reports.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #19 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 10:16:56 CST --- Created an attachment (id=32822) --> (http://bugs.winehq.org/attachment.cgi?id=32822) Attached is the zip file containing both the excel templates.
Hi Andrew,
For you reference I have attached the zip file containing the templates.
The one I am concentrating on is Scorebook.xlt
Regards, Ajeet
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #20 from Rosanne DiMesio dimesio@earthlink.net 2011-01-12 11:03:37 CST --- Scorebook.xlt does not crash on my system with an override for riched20, but does without it.
Ajeet: does setting riched20 to native fix it for you? If so, your problem is a duplicate of bug 14980.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #21 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 11:38:18 CST --- (In reply to comment #20)
Scorebook.xlt does not crash on my system with an override for riched20, but does without it.
Ajeet: does setting riched20 to native fix it for you? If so, your problem is a duplicate of bug 14980.
Let me check, can you please let me know how can i do the override of riched20. Cos if i am not wrong i did it with winetricks but it still crashes.
Do you mean that you are able to run everything in the Scorebook.xlt ?
Are you able to see the dialogs when you click on new game button?
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #22 from Rosanne DiMesio dimesio@earthlink.net 2011-01-12 12:25:17 CST --- (In reply to comment #21)
Let me check, can you please let me know how can i do the override of riched20. Cos if i am not wrong i did it with winetricks but it still crashes.
Open winecfg, go to the Libraries tab, add riched20 to the list, then select it and set it to "native" (not native, builtin). Do not install riched20 with winetricks; Office installs its own version, and winetricks doesn't set the override to native only.
But since you mention winetricks, did you install anything else with it? You shouldn't--tests need to be done in a clean wineprefix.
Do you mean that you are able to run everything in the Scorebook.xlt ?
All I tested was opening the file, since you said it crashed for you on opening. It takes a long time to fully open, and at the end throws up several visual basic error messages. The error dialogs are what's crashing with builtin riched20.
Are you able to see the dialogs when you click on new game button?
I just tested the new game button; it doesn't do anything. That's a different issue; file a separate bug for that.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #23 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 12:34:00 CST --- (In reply to comment #22)
(In reply to comment #21)
Let me check, can you please let me know how can i do the override of riched20. Cos if i am not wrong i did it with winetricks but it still crashes.
Open winecfg, go to the Libraries tab, add riched20 to the list, then select it and set it to "native" (not native, builtin). Do not install riched20 with winetricks; Office installs its own version, and winetricks doesn't set the override to native only.
But since you mention winetricks, did you install anything else with it? You shouldn't--tests need to be done in a clean wineprefix.
Do you mean that you are able to run everything in the Scorebook.xlt ?
All I tested was opening the file, since you said it crashed for you on opening. It takes a long time to fully open, and at the end throws up several visual basic error messages. The error dialogs are what's crashing with builtin riched20.
I am able to open the file.
Are you able to see the dialogs when you click on new game button?
I just tested the new game button; it doesn't do anything. That's a different issue; file a separate bug for that.
This is now the main problem where it is getting crashed. It gets hang and after sometime it gets crashed as well.
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #24 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 12:37:09 CST --- (In reply to comment #23)
(In reply to comment #22)
(In reply to comment #21)
Let me check, can you please let me know how can i do the override of riched20. Cos if i am not wrong i did it with winetricks but it still crashes.
Open winecfg, go to the Libraries tab, add riched20 to the list, then select it and set it to "native" (not native, builtin). Do not install riched20 with winetricks; Office installs its own version, and winetricks doesn't set the override to native only.
But since you mention winetricks, did you install anything else with it? You shouldn't--tests need to be done in a clean wineprefix.
Do you mean that you are able to run everything in the Scorebook.xlt ?
All I tested was opening the file, since you said it crashed for you on opening. It takes a long time to fully open, and at the end throws up several visual basic error messages. The error dialogs are what's crashing with builtin riched20.
I am able to open the file.
Are you able to see the dialogs when you click on new game button?
I just tested the new game button; it doesn't do anything. That's a different issue; file a separate bug for that.
This is now the main problem where it is getting crashed. It gets hang and after sometime it gets crashed as well.
Getting these errors
fixme:typelib2:ICreateTypeInfo2_fnSetVarHelpContext (0x54df130,0,0), stub! err:ole:TLB_ReadTypeLib Loading of typelib L"C:\users\ajeets\Temp\Excel8.0\MSForms.exd" failed with error 2 fixme:typelib2:ICreateTypeInfo2_fnSetTypeDescAlias (0x54dcfe0,0x54dcfc4), hack! fixme:typelib2:ICreateTypeInfo2_fnSetTypeDescAlias (0x54df0a0,0x54df084), hack!
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #25 from Austin English austinenglish@gmail.com 2011-01-12 12:50:08 CST --- (In reply to comment #10)
(In reply to comment #9)
Ok, now let me see +typelib2,+tid log.
Can you please elaborate it more, do you need something from myside?
+typelib2? +tid log ?
WINEDEBUG=+typelib2,+tid wine excel.exe &> /tmp/log.txt
then attach log.txt here. If larger than 1MB, compress it (with bzip2 -9).
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #26 from Ajeet Singh ajeet_singh1978@yahoo.co.in 2011-01-12 13:07:26 CST --- (In reply to comment #25)
(In reply to comment #10)
(In reply to comment #9)
Ok, now let me see +typelib2,+tid log.
Can you please elaborate it more, do you need something from myside?
+typelib2? +tid log ?
WINEDEBUG=+typelib2,+tid wine excel.exe &> /tmp/log.txt
then attach log.txt here. If larger than 1MB, compress it (with bzip2 -9).
The file size was 183M, after compressing it is 4.9MB :(
http://bugs.winehq.org/show_bug.cgi?id=25754
Rosanne DiMesio dimesio@earthlink.net changed:
What |Removed |Added ---------------------------------------------------------------------------- Keywords|regression | Component|oleaut32 |-unknown
--- Comment #27 from Rosanne DiMesio dimesio@earthlink.net 2011-01-12 21:39:10 CST --- I've opened bug 25762 for the regression I found, since it's now clear that it's not the same problem being reported here.
http://bugs.winehq.org/show_bug.cgi?id=25754
sancho c4490522@pjjkp.com changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |c4490522@pjjkp.com
--- Comment #28 from sancho c4490522@pjjkp.com 2011-01-28 16:30:38 CST --- (In reply to comment #24)
(In reply to comment #23)
(In reply to comment #22)
(In reply to comment #21)
Let me check, can you please let me know how can i do the override of riched20. Cos if i am not wrong i did it with winetricks but it still crashes.
Open winecfg, go to the Libraries tab, add riched20 to the list, then select it and set it to "native" (not native, builtin). Do not install riched20 with winetricks; Office installs its own version, and winetricks doesn't set the override to native only.
But since you mention winetricks, did you install anything else with it? You shouldn't--tests need to be done in a clean wineprefix.
Do you mean that you are able to run everything in the Scorebook.xlt ?
All I tested was opening the file, since you said it crashed for you on opening. It takes a long time to fully open, and at the end throws up several visual basic error messages. The error dialogs are what's crashing with builtin riched20.
I am able to open the file.
Are you able to see the dialogs when you click on new game button?
I just tested the new game button; it doesn't do anything. That's a different issue; file a separate bug for that.
This is now the main problem where it is getting crashed. It gets hang and after sometime it gets crashed as well.
Getting these errors
fixme:typelib2:ICreateTypeInfo2_fnSetVarHelpContext (0x54df130,0,0), stub! err:ole:TLB_ReadTypeLib Loading of typelib L"C:\users\ajeets\Temp\Excel8.0\MSForms.exd" failed with error 2 fixme:typelib2:ICreateTypeInfo2_fnSetTypeDescAlias (0x54dcfe0,0x54dcfc4), hack! fixme:typelib2:ICreateTypeInfo2_fnSetTypeDescAlias (0x54df0a0,0x54df084), hack!
I get this errors also. I can't run any macro. Wine 1.3.12, Office 2007
Is there any way to run macros in any version of Excel on Wine?
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #29 from butraxz@gmail.com 2013-08-05 12:36:08 CDT --- This ticket has not been updated for over 900 days. Development recommends to check the status on your bug every release or two and let to be known if the bug is still present. If not, mark it fixed.
Is this still an issue with 1.7.0 or higher ?
http://bugs.winehq.org/show_bug.cgi?id=25754
--- Comment #30 from Andrew Eikum aeikum@codeweavers.com 2013-08-09 12:45:14 CDT --- Yes, It's still an issue.
Right now, it's failing at ICreateTypeInfo2_fnSetTypeDescAlias, which is unimplemented.
http://bugs.winehq.org/show_bug.cgi?id=25754
Andrew Eikum aeikum@codeweavers.com changed:
What |Removed |Added ---------------------------------------------------------------------------- Fixed by SHA1| |808c47cecba0fcd4a9a62b69183 | |e88d20cabbe19 Status|NEW |RESOLVED Resolution| |FIXED
--- Comment #31 from Andrew Eikum aeikum@codeweavers.com 2013-09-10 08:44:01 CDT --- After commit 808c47cecba0fcd4a9a62b69183e88d20cabbe19 in yesterday's Wine, and with native riched20, Scorebook.xlt seems to be working correctly.
http://bugs.winehq.org/show_bug.cgi?id=25754
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |CLOSED
--- Comment #32 from Alexandre Julliard julliard@winehq.org 2013-09-13 13:20:24 CDT --- Closing bugs fixed in 1.7.2.
http://bugs.winehq.org/show_bug.cgi?id=25754
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Target Milestone|--- |1.6.x
http://bugs.winehq.org/show_bug.cgi?id=25754
Alexandre Julliard julliard@winehq.org changed:
What |Removed |Added ---------------------------------------------------------------------------- Target Milestone|1.6.x |---
--- Comment #33 from Alexandre Julliard julliard@winehq.org 2013-11-15 13:40:12 CST --- Removing 1.6.x milestone from bugs included in 1.6.1.
https://bugs.winehq.org/show_bug.cgi?id=25754
Anastasius Focht focht@gmx.net changed:
What |Removed |Added ---------------------------------------------------------------------------- CC| |focht@gmx.net Component|-unknown |oleaut32
-
wine-bugs＠winehq.org