Hyperlink in Table of content always throwing IllegalArgumentException, plz help

Hi,
I am trying to implement the hyperlink functionality for
table of content
using Visual Basic 6.0 and though the documentation says
that we have to
pass first parameter as Long and Second one as Any/Variant,
the
replaceByIndex is always throwing IllegalArgumentException.

Here is the code:

////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////
//////////////////////////

Dim iIndexLevel As Long
Dim oLevelFormat As Object
Dim arrLevelFormat
Dim i
Set oLevelFormat = oTOC.LevelFormat
For iIndexLevel = 0 To oLevelFormat.getCount() - 1

   arrLevelFormat = oLevelFormat.getByIndex(iIndexLevel)
   If IsArray(arrLevelFormat) And UBound(arrLevelFormat)
> 0 Then
       Dim iCount As Integer
       iCount = UBound(arrLevelFormat)
       Dim newFormat() As Variant
       ReDim newFormat(iCount + 2)
       Dim arrTemp(1) As Variant
       Dim oProperty As Object

       Set oProperty =
oSM.bridge_getstruct("com.sun.star.beans.PropertyValue&
quot;)
       oProperty.name = "TokenType"
       oProperty.Value = "TokenHyperlinkStart"
       arrTemp(0) = Array(oProperty)
       newFormat(0) = arrTemp

       For i = 0 To UBound(arrLevelFormat)
           newFormat(i + 1) = arrLevelFormat(i)
       Next

       Dim arrTempNew(1) As Variant
       Dim oPropertyNew As Object

       Set oPropertyNew =
oSM.bridge_getstruct("com.sun.star.beans.PropertyValue&
quot;)
       oPropertyNew.name = "TokenType"
       oPropertyNew.Value = "TokenHyperlinkStart"
       arrTempNew(0) = Array(oPropertyNew)
       newFormat(UBound(arrLevelFormat) + 2) = arrTempNew

       Call oTOC.LevelFormat.replaceByIndex(iIndexLevel,
newFormat)

   End If

Next

oTOC.Update

////////////////////////////////////////////////////////////
////////////////////////////////////////////////////////////
//////////////////////////

Can anyone please help me out? it is very urgent for me and
I have tried
searching forum also but to no avail.

Plz help,

thanks & regards,

Sandeep

Message de Sandeep Raghuvanshi  date 2007-09-20 16:58 :
> Hi,
> I am trying to implement the hyperlink functionality
for table of content
> using Visual Basic 6.0 and though the documentation
says that we have to
> pass first parameter as Long and Second one as
Any/Variant, the
> replaceByIndex is always throwing
IllegalArgumentException.
> 
> Here is the code:
> 
( ... )

> 
>        Call
oTOC.LevelFormat.replaceByIndex(iIndexLevel, newFormat)
> 

I already have answered a similar question in
<http://www.oooforum.org/forum/viewtopic.phtml?p
=239563#239563>

Answer adapted to your case:

You have to pass an array of Uno objects, and the argument
of 
replaceByIndex is defined as : any
So you have to tell the bridge what exactly you are
passing.
This is a limitation of the COM bridge, whatever the
language you use.

Solution:
Dim unoWrap As Variant
Set unoWrap = oSM.Bridge_GetValueObject
unoWrap.set "[]com.sun.star.beans.PropertyValue",
newFormat
Call oTOC.LevelFormat.replaceByIndex(iIndexLevel, unoWrap)


Concerning OOo general programming through VB6 you may be
interested in 
the libraries provided by VBx_OOo tool : 
<http://ww
w.ooomacros.org/dev.php#240562>

______
Bernard

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org

Message de Sandeep Raghuvanshi  date 2007-09-21 09:07 :
> Hi Bernard,
> Thank you for your kind response. I have tried the
logic suggested by 
> you but still there is an automation error getting
generated when I 
> tried to update the TOC.
>  
> Here is my modified code and the error screen shot is
attached:

The screenshot was discarded by the mailing list. You should
have 
described the error message.

I have no knowledge about ToC handling. Sorry I can't help
more.

______
Bernard

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org

Thanks Bernard,
May be by looking at the error message you get some idea:

*Error: [automation bridge] unexpected exception in
UnoConversionUtilities<T>::convertValueObject !
Message : [automation
bridge]UnoConversionUtilities<T>::createOleObjectWrapp
er
The variant does not contain an object type!*


Thanks for the help so far,

regards,
Sandeep

On 9/21/07, Bernard Marcelly <marcellyclub-internet.fr> wrote:
>
> Message de Sandeep Raghuvanshi  date 2007-09-21 09:07
:
> > Hi Bernard,
> > Thank you for your kind response. I have tried the
logic suggested by
> > you but still there is an automation error getting
generated when I
> > tried to update the TOC.
> >
> > Here is my modified code and the error screen shot
is attached:
>
> The screenshot was discarded by the mailing list. You
should have
> described the error message.
>
> I have no knowledge about ToC handling. Sorry I can't
help more.
>
> ______
> Bernard
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> For additional commands, e-mail: dev-helpapi.openoffice.org
>
>

Thank you very much Bernard for the solution in the forum:
http://www.oooforum.org/forum/viewtopic.phtml?t=11415

The only change I discovered was that we have to use one set
of square
bracket as TOC is Array of Array of PropertyValue

Now I have another problem(sorry guys but the solution has
to work in MS
Word also)
When I convert this document to MS Word format, all of the
hyperlinks are
pointing to the first page of the document instead of the
actual page
number.
Any idea about this strange behavior? Is this an issue with
the OpenOffice
API?

Please guide,

thanks & regards,
Sandeep

On 9/21/07, Sandeep Raghuvanshi <sandyraghavgmail.com> wrote:
>
> Thanks Bernard,
> May be by looking at the error message you get some
idea:
>
> *Error: [automation bridge] unexpected exception in
> UnoConversionUtilities<T>::convertValueObject !
Message : [automation
>
bridge]UnoConversionUtilities<T>::createOleObjectWrapp
er
> The variant does not contain an object type! *
>
>
> Thanks for the help so far,
>
> regards,
> Sandeep
>
> On 9/21/07, Bernard Marcelly <marcellyclub-internet.fr> wrote:
> >
> > Message de Sandeep Raghuvanshi  date 2007-09-21
09:07 :
> > > Hi Bernard,
> > > Thank you for your kind response. I have
tried the logic suggested by
> > > you but still there is an automation error
getting generated when I
> > > tried to update the TOC.
> > >
> > > Here is my modified code and the error screen
shot is attached:
> >
> > The screenshot was discarded by the mailing list.
You should have
> > described the error message.
> >
> > I have no knowledge about ToC handling. Sorry I
can't help more.
> >
> > ______
> > Bernard
> >
> >
------------------------------------------------------------
---------
> > To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> > For additional commands, e-mail: dev-helpapi.openoffice.org
> >
> >
>

Sandeep Raghuvanshi wrote:
> Thank you very much Bernard for the solution in the
forum:
> http://www.oooforum.org/forum/viewtopic.phtml?t=11415
> 
> The only change I discovered was that we have to use
one set of square
> bracket as TOC is Array of Array of PropertyValue
> 
> Now I have another problem(sorry guys but the solution
has to work in MS
> Word also)
> When I convert this document to MS Word format, all of
the hyperlinks are
> pointing to the first page of the document instead of
the actual page
> number.
> Any idea about this strange behavior? Is this an issue
with the OpenOffice

and the document is valid when loading it in OO.org, right?
If yes i 
would assume that it is no problem with the API. Have you
tried to 
create a simple document with a TOC with links via the UI
and have you 
export it then?

Juergen


> API?
> 
> Please guide,
> 
> thanks & regards,
> Sandeep
> 
> On 9/21/07, Sandeep Raghuvanshi <sandyraghavgmail.com> wrote:
>> Thanks Bernard,
>> May be by looking at the error message you get some
idea:
>>
>> *Error: [automation bridge] unexpected exception
in
>> UnoConversionUtilities<T>::convertValueObject
! Message : [automation
>>
bridge]UnoConversionUtilities<T>::createOleObjectWrapp
er
>> The variant does not contain an object type! *
>>
>>
>> Thanks for the help so far,
>>
>> regards,
>> Sandeep
>>
>> On 9/21/07, Bernard Marcelly <marcellyclub-internet.fr> wrote:
>>> Message de Sandeep Raghuvanshi  date 2007-09-21
09:07 :
>>>> Hi Bernard,
>>>> Thank you for your kind response. I have
tried the logic suggested by
>>>> you but still there is an automation error
getting generated when I
>>>> tried to update the TOC.
>>>>
>>>> Here is my modified code and the error
screen shot is attached:
>>> The screenshot was discarded by the mailing
list. You should have
>>> described the error message.
>>>
>>> I have no knowledge about ToC handling. Sorry I
can't help more.
>>>
>>> ______
>>> Bernard
>>>
>>>
------------------------------------------------------------
---------
>>> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
>>> For additional commands, e-mail: dev-helpapi.openoffice.org
>>>
>>>
> 

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org

Yes I am able to export it to word and the document is valid
in OO. I have
figured out what steps you have to take to make it working
in MS
word(manually) -
Right click on TOC entry->Select Update Field
This work around will make the hyperlinks working in MS Word
but is there
something which we can set programatically in order to avoid
this manual
step?

I have also tried creation of TOC manually via UI and when
we convert the
document to MS Word, we are required to follow the same
manual step of
updating the TOC so the result both manually and
programatically is same.



On 9/24/07, Juergen Schmidt <juergen.schmidtsun.com> wrote:
>
> Sandeep Raghuvanshi wrote:
> > Thank you very much Bernard for the solution in
the forum:
> > http://www.oooforum.org/forum/viewtopic.phtml?t=11415
> >
> > The only change I discovered was that we have to
use one set of square
> > bracket as TOC is Array of Array of PropertyValue
> >
> > Now I have another problem(sorry guys but the
solution has to work in MS
>
> > Word also)
> > When I convert this document to MS Word format,
all of the hyperlinks
> are
> > pointing to the first page of the document instead
of the actual page
> > number.
> > Any idea about this strange behavior? Is this an
issue with the
> OpenOffice
>
> and the document is valid when loading it in OO.org,
right? If yes i
> would assume that it is no problem with the API. Have
you tried to
> create a simple document with a TOC with links via the
UI and have you
> export it then?
>
> Juergen
>
>
> > API?
> >
> > Please guide,
> >
> > thanks & regards,
> > Sandeep
> >
> > On 9/21/07, Sandeep Raghuvanshi <
sandyraghavgmail.com> wrote:
> >> Thanks Bernard,
> >> May be by looking at the error message you get
some idea:
> >>
> >> *Error: [automation bridge] unexpected
exception in
> >>
UnoConversionUtilities<T>::convertValueObject !
Message : [automation
> >>
bridge]UnoConversionUtilities<T>::createOleObjectWrapp
er
> >> The variant does not contain an object type!
*
> >>
> >>
> >> Thanks for the help so far,
> >>
> >> regards,
> >> Sandeep
> >>
> >> On 9/21/07, Bernard Marcelly <marcellyclub-internet.fr> wrote:
> >>> Message de Sandeep Raghuvanshi  date
2007-09-21 09:07 :
> >>>> Hi Bernard,
> >>>> Thank you for your kind response. I
have tried the logic suggested by
> >>>> you but still there is an automation
error getting generated when I
> >>>> tried to update the TOC.
> >>>>
> >>>> Here is my modified code and the error
screen shot is attached:
> >>> The screenshot was discarded by the
mailing list. You should have
> >>> described the error message.
> >>>
> >>> I have no knowledge about ToC handling.
Sorry I can't help more.
> >>>
> >>> ______
> >>> Bernard
> >>>
> >>>
------------------------------------------------------------
---------
> >>> To unsubscribe, e-mail:
dev-unsubscribeapi.openoffice.org
> >>> For additional commands, e-mail:
dev-helpapi.openoffice.org
> >>>
> >>>
> >
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> For additional commands, e-mail: dev-helpapi.openoffice.org
>
>

Sandeep Raghuvanshi wrote:
> Yes I am able to export it to word and the document is
valid in OO. I have
> figured out what steps you have to take to make it
working in MS
> word(manually) -
> Right click on TOC entry->Select Update Field
> This work around will make the hyperlinks working in MS
Word but is there
> something which we can set programatically in order to
avoid this manual
> step?
> 
> I have also tried creation of TOC manually via UI and
when we convert the
> document to MS Word, we are required to follow the same
manual step of
> updating the TOC so the result both manually and
programatically is same.

i have assumed that. So it is no API issue (at least no real
API issue). 
I suggest that you create a example document and submit an
issue for 
this problem to the writer component.

Juergen

> 
> 
> 
> On 9/24/07, Juergen Schmidt <juergen.schmidtsun.com> wrote:
>> Sandeep Raghuvanshi wrote:
>>> Thank you very much Bernard for the solution in
the forum:
>>> http://www.oooforum.org/forum/viewtopic.phtml?t=11415
>>>
>>> The only change I discovered was that we have
to use one set of square
>>> bracket as TOC is Array of Array of
PropertyValue
>>>
>>> Now I have another problem(sorry guys but the
solution has to work in MS
>>> Word also)
>>> When I convert this document to MS Word format,
all of the hyperlinks
>> are
>>> pointing to the first page of the document
instead of the actual page
>>> number.
>>> Any idea about this strange behavior? Is this
an issue with the
>> OpenOffice
>>
>> and the document is valid when loading it in
OO.org, right? If yes i
>> would assume that it is no problem with the API.
Have you tried to
>> create a simple document with a TOC with links via
the UI and have you
>> export it then?
>>
>> Juergen
>>
>>
>>> API?
>>>
>>> Please guide,
>>>
>>> thanks & regards,
>>> Sandeep
>>>
>>> On 9/21/07, Sandeep Raghuvanshi <
sandyraghavgmail.com> wrote:
>>>> Thanks Bernard,
>>>> May be by looking at the error message you
get some idea:
>>>>
>>>> *Error: [automation bridge] unexpected
exception in
>>>>
UnoConversionUtilities<T>::convertValueObject !
Message : [automation
>>>>
bridge]UnoConversionUtilities<T>::createOleObjectWrapp
er
>>>> The variant does not contain an object
type! *
>>>>
>>>>
>>>> Thanks for the help so far,
>>>>
>>>> regards,
>>>> Sandeep
>>>>
>>>> On 9/21/07, Bernard Marcelly
<marcellyclub-internet.fr> wrote:
>>>>> Message de Sandeep Raghuvanshi  date
2007-09-21 09:07 :
>>>>>> Hi Bernard,
>>>>>> Thank you for your kind response. I
have tried the logic suggested by
>>>>>> you but still there is an
automation error getting generated when I
>>>>>> tried to update the TOC.
>>>>>>
>>>>>> Here is my modified code and the
error screen shot is attached:
>>>>> The screenshot was discarded by the
mailing list. You should have
>>>>> described the error message.
>>>>>
>>>>> I have no knowledge about ToC handling.
Sorry I can't help more.
>>>>>
>>>>> ______
>>>>> Bernard
>>>>>
>>>>>
------------------------------------------------------------
---------
>>>>> To unsubscribe, e-mail:
dev-unsubscribeapi.openoffice.org
>>>>> For additional commands, e-mail:
dev-helpapi.openoffice.org
>>>>>
>>>>>
>>
------------------------------------------------------------
---------
>> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
>> For additional commands, e-mail: dev-helpapi.openoffice.org
>>
>>
> 

------------------------------------------------------------
---------
To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
For additional commands, e-mail: dev-helpapi.openoffice.org

Thanks Juergen, I will do this now.


On 9/28/07, Juergen Schmidt <juergen.schmidtsun.com> wrote:
>
> Sandeep Raghuvanshi wrote:
> > Yes I am able to export it to word and the
document is valid in OO. I
> have
> > figured out what steps you have to take to make it
working in MS
> > word(manually) -
> > Right click on TOC entry->Select Update Field
> > This work around will make the hyperlinks working
in MS Word but is
> there
> > something which we can set programatically in
order to avoid this manual
> > step?
> >
> > I have also tried creation of TOC manually via UI
and when we convert
> the
> > document to MS Word, we are required to follow the
same manual step of
> > updating the TOC so the result both manually and
programatically is
> same.
>
> i have assumed that. So it is no API issue (at least no
real API issue).
> I suggest that you create a example document and submit
an issue for
> this problem to the writer component.
>
> Juergen
>
> >
> >
> >
> > On 9/24/07, Juergen Schmidt
<juergen.schmidtsun.com> wrote:
> >> Sandeep Raghuvanshi wrote:
> >>> Thank you very much Bernard for the
solution in the forum:
> >>> http://www.oooforum.org/forum/viewtopic.phtml?t=11415
> >>>
> >>> The only change I discovered was that we
have to use one set of square
> >>> bracket as TOC is Array of Array of
PropertyValue
> >>>
> >>> Now I have another problem(sorry guys but
the solution has to work in
> MS
> >>> Word also)
> >>> When I convert this document to MS Word
format, all of the hyperlinks
> >> are
> >>> pointing to the first page of the document
instead of the actual page
> >>> number.
> >>> Any idea about this strange behavior? Is
this an issue with the
> >> OpenOffice
> >>
> >> and the document is valid when loading it in
OO.org, right? If yes i
> >> would assume that it is no problem with the
API. Have you tried to
> >> create a simple document with a TOC with links
via the UI and have you
> >> export it then?
> >>
> >> Juergen
> >>
> >>
> >>> API?
> >>>
> >>> Please guide,
> >>>
> >>> thanks & regards,
> >>> Sandeep
> >>>
> >>> On 9/21/07, Sandeep Raghuvanshi <
sandyraghavgmail.com> wrote:
> >>>> Thanks Bernard,
> >>>> May be by looking at the error message
you get some idea:
> >>>>
> >>>> *Error: [automation bridge] unexpected
exception in
> >>>>
UnoConversionUtilities<T>::convertValueObject !
Message : [automation
> >>>>
bridge]UnoConversionUtilities<T>::createOleObjectWrapp
er
> >>>> The variant does not contain an object
type! *
> >>>>
> >>>>
> >>>> Thanks for the help so far,
> >>>>
> >>>> regards,
> >>>> Sandeep
> >>>>
> >>>> On 9/21/07, Bernard Marcelly
<marcellyclub-internet.fr> wrote:
> >>>>> Message de Sandeep Raghuvanshi 
date 2007-09-21 09:07 :
> >>>>>> Hi Bernard,
> >>>>>> Thank you for your kind
response. I have tried the logic suggested
> by
> >>>>>> you but still there is an
automation error getting generated when I
> >>>>>> tried to update the TOC.
> >>>>>>
> >>>>>> Here is my modified code and
the error screen shot is attached:
> >>>>> The screenshot was discarded by
the mailing list. You should have
> >>>>> described the error message.
> >>>>>
> >>>>> I have no knowledge about ToC
handling. Sorry I can't help more.
> >>>>>
> >>>>> ______
> >>>>> Bernard
> >>>>>
> >>>>>
>
------------------------------------------------------------
---------
> >>>>> To unsubscribe, e-mail:
dev-unsubscribeapi.openoffice.org
> >>>>> For additional commands, e-mail:
dev-helpapi.openoffice.org
> >>>>>
> >>>>>
> >>
------------------------------------------------------------
---------
> >> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> >> For additional commands, e-mail: dev-helpapi.openoffice.org
> >>
> >>
> >
>
>
------------------------------------------------------------
---------
> To unsubscribe, e-mail: dev-unsubscribeapi.openoffice.org
> For additional commands, e-mail: dev-helpapi.openoffice.org
>
>