Hyperlinks to local paths do not work.
Posted: Fri Mar 22, 2013 2:52 pm
Hi!
I tried to create hyperlinks with the following code using XLS ReadWrite 5.10.07:
var
ExcelFile5 : TXLSReadWriteII5;
begin
ExcelFile5 := TXLSReadWriteII5.Create(nil);
ExcelFile5.Filename := 'D:\output.xlsx';
ExcelFile5.Sheets[0].MakeHyperlink(0,0,'C:\Windows', 'C:\Windows' );
ExcelFile5.Write;
end.
It seems that XLSReadWrite converts the address C:\Windows to ..\Windows (unit xlshyperlinks5; function setAddress).
If I open the excel file afterwards and try to click on the hyperlink, the path cannot be found.
If I try to add hyperlinks to an xls (Excel97) file, the hyperlink address is empty.
I tried to create hyperlinks with the following code using XLS ReadWrite 5.10.07:
var
ExcelFile5 : TXLSReadWriteII5;
begin
ExcelFile5 := TXLSReadWriteII5.Create(nil);
ExcelFile5.Filename := 'D:\output.xlsx';
ExcelFile5.Sheets[0].MakeHyperlink(0,0,'C:\Windows', 'C:\Windows' );
ExcelFile5.Write;
end.
It seems that XLSReadWrite converts the address C:\Windows to ..\Windows (unit xlshyperlinks5; function setAddress).
If I open the excel file afterwards and try to click on the hyperlink, the path cannot be found.
If I try to add hyperlinks to an xls (Excel97) file, the hyperlink address is empty.