[Open Office] VBA work

[Noel Power]

Hi JianHua

On Thu, 2007-03-01 at 08:52 +0000, Jian Hua Jiao wrote:
> Hi,
> 
> 	I have test the control components which are on sheets. When I switch the sheet, the current sheet will call SdrPageView::ClearPageWindows to clear the control components and others. So we can get the windows to set focus, visible or etc, but MSO. 
> 	To solve this problem at this time, we will lost some control when the sheet is invisible. or change the OOo's behavior like MSO. 
So, what you are saying is that we will loose the ability to set some
attributes on a control that 'lives' on a sheet that is not curently
selected.
> And I think MSO's behavior is more suitable for Basic process. Noel, any suggestion?
So, it would appear that OO implementation is not helper for us then and
seems to be tied too tightly to the drawing layer. You should imo be
able to modify the state of the control e.g. its visibilty attribute
( and surely that state is stored somewhere ) so that when the sheet
does become the active sheet the control 'knows' is should be visible or
have focus or whatever.  My suggestion is that we forget about this for
the moment, rewriting how the controls act/interact with the drawing
layer is something I would prefer to avoid ;-) 
My main issue was the implementation was unusable right now because of a
side affect of the above,
> 	So ,I will remove the m_xWindowPeer variable from the ScVbaControl. And create a new help function for focus, visible etc..
yes, I would create a helper function to return the XWindow peer for the
Control to be used by set/getVisble etc. and if someone tries to access
that functionality on a control that on a non-visible sheet then this
will throw. That should be sufficient thanks :-)
> 	Should we CC the mail to or discuss the TAB behavior dev at openoffice.org ? 
As suggested I will cc this to openoffice at lists.ximian.com 
perhaps a query to dev at openoffice.org might yield some interesting
information
> 
> Jianhua
Noel
-- 
Noel Power
OpenOffice Developer 
noel.power at novell.com  

Novell, Inc. 
Software for the Open Enterprise 
www.novell.com/open 
SUSE® Linux Enterprise 10
Your Linux is ready
www.novell.com/linux