nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating Hyperlink in excelsheet report for few cells

PriyaK

Hi All,
 
I have requirement in which I have to create hyperlink to only those data in excelsheet for which associated tab is available.
 
For Example refer sample excelsheet report attached.
 
In this excelsheet report there is mainpage and two linked sheets.
 
In Mainpage you can see hyperlink for two cells data in AUTH_OPT_VAL column because its corresponding sheets are available for these two values, and rest of the other values there is no hyperlink.
 
So to achieve this I have set hyperlink property of AUTH_OPT_VAL to "#"+row["AUTH_OPT_VAL"]+"!A1"
But due to this I can see whole data in this column is hyperlinked and whenever I clicked on other data, I am getting error â€œreference is not validâ€
So please let me know is there any way we can create hyperlink only to those data for which sheets are available.
I am using BIRT 4.5.0 version.

Find more posts tagged with

Comments

JFreeman

With the way your script is setup, it will apply that formula to every row no matter what which is why you are seeing this behavior. To get around this you are going to need to add some conditional code around your script to determine row by row if there will be a need for a link and then only apply your script if there should be a link.

PriyaK

Thanks @JFreeman but Can you give me any sample for this.
 
Also one more question when I am exporting report as XLS or XLS_SPUDSOFT , hyperlink are not generating in excel report using below code.
"#"+row["AUTH_OPT_VAL"]+"!A1"
 
But when I am exporting report as a XLSX its generating fine.
 
Can anyone know how to fix this.