Re: [libreoffice-users] Code snippet

2011-07-31 Thread planas
Andrew, On Sun, 2011-07-31 at 21:49 -0400, Andrew Douglas Pitonyak wrote: > On 07/31/2011 02:19 PM, Bill Gradwohl wrote: > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA1 > > > > On 07/30/2011 10:57 PM, Andrew Douglas Pitonyak wrote: > >> I expect that you need to set this from the sheets dr

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Andrew Douglas Pitonyak
On 07/31/2011 03:48 PM, Tom Davies wrote: Hi :) +1 The devs guide is not meant to be elitist but probably needs a re-write from a more "normal user" perspective lol. I'm sure the Documentation Team will work on it one day but it's not top priority just yet. Well, if you really understand thing

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Andrew Douglas Pitonyak
On 07/31/2011 02:19 PM, Bill Gradwohl wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/30/2011 10:57 PM, Andrew Douglas Pitonyak wrote: I expect that you need to set this from the sheets draw page Thank You Andrew. I have a copy of your book back in Texas. I wish I had it her

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Bill Gradwohl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/31/2011 08:19 AM, Andrew Douglas Pitonyak wrote: >>> If ashape.Control.Name = CName then Andrew FYI - I had to put an additional test in front of the above if statement as in: if not IsNull(aShape.Control) Some of the items ret

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Tom Davies
__ From: Onyeibo Oku To: users@global.libreoffice.org Sent: Sun, 31 July, 2011 19:31:37 Subject: Re: [libreoffice-users] Code snippet Oh! So I'm not a moron after all. However, I downloaded AndrewMacro.pdf few days ago and found Andrew's approach more practical and easier to grasp...an

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Onyeibo Oku
ract extension development via macro scripting, they should consider making those docs more like english language. sent from mobile device -Original Message- From: Bill Gradwohl Date: Sun, 31 Jul 2011 12:19:25 To: Reply-To: users@global.libreoffice.org Subject: Re: [libreoffice-user

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Bill Gradwohl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 07/30/2011 10:57 PM, Andrew Douglas Pitonyak wrote: > I expect that you need to set this from the sheets draw page Thank You Andrew. I have a copy of your book back in Texas. I wish I had it here on the island. I wrote most of the POS system

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Andrew Douglas Pitonyak
On 07/31/2011 03:50 AM, Johnny Rosenberg wrote: 2011/7/31 Andrew Douglas Pitonyak: I expect that you need to set this from the sheets draw page ' Gets the Shape of a Control( e. g. to reset the size or Position of the control ' Parameters: ' The 'oContainer' is the Document or a specific shee

Re: [libreoffice-users] Code snippet

2011-07-31 Thread Johnny Rosenberg
2011/7/31 Andrew Douglas Pitonyak : > I expect that you need to set this from the sheets draw page > > ' Gets the Shape of a Control( e. g. to reset the size or Position of the > control > ' Parameters: > ' The 'oContainer' is the Document or a specific sheet of a Calc - Document > ' 'CName' is the

Re: [libreoffice-users] Code snippet

2011-07-30 Thread Andrew Douglas Pitonyak
I expect that you need to set this from the sheets draw page ' Gets the Shape of a Control( e. g. to reset the size or Position of the control ' Parameters: ' The 'oContainer' is the Document or a specific sheet of a Calc - Document ' 'CName' is the Name of the Control Function GetControlShape(

[libreoffice-users] Code snippet

2011-07-30 Thread Bill Gradwohl
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I've searched and can't figure out how to specify the height of a button at execution time via a basic macro. If "Sheet1" contains a button name "OK", how would I specify a button height of 0.5cm? The only examples I can find are for buttons on forms