I have some code which needs to set hyperlinks in an Excel document and
I want the text displayed to be different from the actual link address.
The following code works just fine for me:
$worksheet->Hyperlinks->Add({ Anchor =>
$worksheet->Cells($row, $col),
Address =>
"http://bugs/$bugID <http://nvbugs/$bugID>",
});
$worksheet->Cells($row, $col)->{Value} = $bugID;
But if I do:
$worksheet->Hyperlinks->Add({ Anchor => $worksheet->Cells($row,
$col),
Address =>
"http://nvbugs/$bugID";,
TextToDisplay => $bugID,
});
I get:
OLE Error Win32::OLE(0.1709) error 0x80070057: "The parameter is
incorrect"
in METHOD/PROPERTYGET "Add" ....
but it did do what I wanted (the link was added correctly)
anyone know why I get the error message, or how to debug this
Mark
_______________________________________________
Perl-Win32-Users mailing list
[email protected]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
