BorlandTalk.com Forum Index BorlandTalk.com
Borland discussion newsgroups
 
Archives   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

OleContainer + Excel

 
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi OLE Automation
View previous topic :: View next topic  
Author Message
jiri.klement@gmail.com
Guest





PostPosted: Tue Sep 20, 2005 10:20 am    Post subject: OleContainer + Excel Reply with quote



Hi,

I'm using OleContainer to show excel sheets. I need to put two
OleContainers on form, both containing opened sheet. Because standard
TOleContainer does'nt allow this (only one sheet can be active) I've
made modifications to TOleContainer to don't merge toolbars and menus
and to stay active after lost of focus.

Problem is that after creating second OleContainer, the first starts to
behave strange (ie Worksheet.Windows.Count = 0). But real problem is,
that after second OleContainer is closed, first OleContainer can't get
focus. I can use scrolbars but I can't select or even edit cell.

When I put ole containers on different mdi child, than everything works
ok. It doesn't work when I put them on different (non mdi) forms.

The same thing for Word works fine.

Some things which possible can help me:
1) What is the difference between mdi and standard form? The difference
which cause my OleContainer to work fine on mdi form.
2) Is there a way how to say Excel to run new instance for each
OleContainer?
3) Any other way how to show two active excel worksheets on one form?

--
Jiri

Back to top
Riki Wiki
Guest





PostPosted: Sat Sep 24, 2005 11:47 pm    Post subject: Re: OleContainer + Excel Reply with quote



Hoi Jiri

Take a look here:
<http://tinyurl.com/8m5nw>
which links to
<http://delphi.wikicities.com/wiki/Delphi_Newsgroups>
Back to top
Display posts from previous:   
Post new topic   Reply to topic    BorlandTalk.com Forum Index -> Delphi OLE Automation All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2006 phpBB Group
SEO toolkit © 2004-2006 webmedic.