jiri.klement@gmail.com Guest
|
Posted: Tue Sep 20, 2005 10:20 am Post subject: OleContainer + Excel |
|
|
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
|
|