Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-23 Thread Stephan Bergmann
On 21/10/2019 12:53, Stephan Bergmann wrote: On 18/10/2019 20:16, Johnny Rosenberg wrote: *Private Function ItemFound(sItem As string, _   oRange As com.sun.star.sheet.XSheetCellRange) As Boolean Dim oDescriptor As com.sun.star.util.XReplaceDescriptor

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-22 Thread Johnny Rosenberg
Den tis 22 okt. 2019 kl 14:32 skrev Stephan Bergmann : > On 22/10/2019 14:23, Johnny Rosenberg wrote: > > *Sub TestDim oRange As com.sun.star.sheet.XSheetCellRange > > > oRange=ThisComponent.getSheets().getByIndex(0).getCellRangeByPosition(0,0,10,10) > >Dim oDescriptor As

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-22 Thread Johnny Rosenberg
Den tis 22 okt. 2019 kl 09:00 skrev Stephan Bergmann : > On 21/10/2019 21:43, Johnny Rosenberg wrote: > > Den mån 21 okt. 2019 kl 12:53 skrev Stephan Bergmann < > sberg...@redhat.com>: > >> On 18/10/2019 20:16, Johnny Rosenberg wrote: > >>> *Private Function ItemFound(sItem As string, _ oRange

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-22 Thread Stephan Bergmann
On 21/10/2019 21:43, Johnny Rosenberg wrote: Den mån 21 okt. 2019 kl 12:53 skrev Stephan Bergmann : On 18/10/2019 20:16, Johnny Rosenberg wrote: *Private Function ItemFound(sItem As string, _ oRange As com.sun.star.sheet.XSheetCellRange) As Boolean Dim oDescriptor As

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-21 Thread Johnny Rosenberg
Den mån 21 okt. 2019 kl 12:53 skrev Stephan Bergmann : > On 18/10/2019 20:16, Johnny Rosenberg wrote: > > *Private Function ItemFound(sItem As string, _ oRange As > > com.sun.star.sheet.XSheetCellRange) As Boolean Dim oDescriptor As > > com.sun.star.util.XReplaceDescriptor > >

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-21 Thread Stephan Bergmann
On 18/10/2019 20:16, Johnny Rosenberg wrote: *Private Function ItemFound(sItem As string, _ oRange As com.sun.star.sheet.XSheetCellRange) As Boolean Dim oDescriptor As com.sun.star.util.XReplaceDescriptor oDescriptor=oRange.createSearchDescriptor()* *⁝* *⁝* *End Function* So the answer to my

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-18 Thread Johnny Rosenberg
Aaaa! Sorry, Stephan Bergmann! I accidentally replied to you, while my intention was to reply to the list. Here it is, this time to the list, and this time with further comments at the end: Den fre 18 okt. 2019 kl 20:03 skrev Johnny Rosenberg : > Den tis 15 okt. 2019 kl 08:53 skrev Stephan

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-15 Thread Stephan Bergmann
On 14/10/2019 21:02, Johnny Rosenberg wrote: When using the experimental features in Basic I can declare thing in a more specific way, for instance: *Dim SomeSheet As com.sun.star.sheet.XSpreadsheet* Without the experimental features enabled, I had to write this instead: *Dim SomeSheet As

Re: [libreoffice-users] Experimental macro features: How to determine object types?

2019-10-14 Thread Mauricio Baeza
On Mon, 14 Oct 2019 21:02:10 +0200, Johnny Rosenberg wrote: > When using the experimental features in Basic I can declare thing in a more > specific way, for instance: > > *Dim SomeSheet As com.sun.star.sheet.XSpreadsheet* > Without the experimental features enabled, I had to write this

[libreoffice-users] Experimental macro features: How to determine object types?

2019-10-14 Thread Johnny Rosenberg
When using the experimental features in Basic I can declare thing in a more specific way, for instance: *Dim SomeSheet As com.sun.star.sheet.XSpreadsheet* Without the experimental features enabled, I had to write this instead: *Dim SomeSheet As Object* Is there a way to find out for sure what