Specify wine version, excel version and attach complete terminal output as a text file. If it's possible attach excel document too.

[ajeets@virus ~]$ wine --version
wine-1.3.8

MS Office 2007.

Created attachment 32815 [details]
Attached are the logs / command prompt output

Please find the attached command prompt output nohup.out and nohup2.out

Created attachment 32816 [details]
part2 of command prompt output

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.

Ok. Current update available is 1.3.9, but i have found the source code for 1.3.11, just compiling it.

Same problem after 1.3.11 as well, attached is nohup.out.tar.bz2

Created attachment 32817 [details]
nohup.out.tar.bz2 after 1.3.11

Ok, now let me see +typelib2,+tid log.

(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 ?

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.

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?

Will there be any fix available soon or any alternative?

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.

(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...

(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.

(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.

> 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.

Created attachment 32822 [details]
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

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.

(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?

(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.

(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.

(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!

(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).

(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 :(

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.

(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?

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 ?

Yes, It's still an issue.

Right now, it's failing at ICreateTypeInfo2_fnSetTypeDescAlias, which is unimplemented.

After commit 808c47cecba0fcd4a9a62b69183e88d20cabbe19 in yesterday's Wine, and with native riched20, Scorebook.xlt seems to be working correctly.

Closing bugs fixed in 1.7.2.

Removing 1.6.x milestone from bugs included in 1.6.1.