Hello togehter,
I am trying to implemented a report which exports attributes and other information for each model, which is selcted.
The information is exportet to Excel.
I am working with the "standard?" ooutfile templates:
ooutfile.DefineF("Tabelleninhalt", "Arial",10, Constants.C_BLACK, Constants.C_TRANSPARENT, Constants.FMT_LEFT, 0, 0, 0, 0, 0, 0);
...
ooutfile.TableCellF(link_string, 20, "Tabelleninhalt");
All content ist shown in Excel as plain text.
Is it somehow possible to convert a text explicitely to a link somehow. So that Excel shows it in light-blue and you can klick on it?
I tried arround with Constants.FMT_LINKTARGET, this didnt help.
I added the "Formula" as text "=HYPERLINK(....)" but Exel showend me then the formula as text...
Can anybody help?
Thank you,
Levin Brunner
Amol Patil on
Hello Levin,
Use the method OutputLink(), if you are using standard output API.
However, for excel output it is always better to use the excel workbook API.
Regards,
Amol Patil