Eclipse Community Forums - RDF feed
https://www.eclipse.org/forums/
Eclipse Community ForumsHyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/778831/#msg_778831
This works fine for html, pdf, and doc outputs. However, for the xls (Excel) output, when the user clicks on the link, it says the link is invalid.
Is this supported?
If required, I can post a design and a data source.
Please help!
Thanks,
Joseph]]>Joseph Yeh2012-01-13T23:00:47-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780375/#msg_780375
Can you open a bugzilla entry for this? As a work around try using the
bookmark and table of contents expressions for the target. I have
created and example that works in xls and attached it. The grey
background data item has the hyperlink and the target data item is in
red and uses a bookmark and table of contents expression.
Jason
On 1/13/2012 6:00 PM, Joseph Yeh wrote:
> Hi, I have a report design that contains several tables. And I have
> created bookmarks and hyperlinks so that the user can navigate from one
> cell of a table to another cell in another table.
> This works fine for html, pdf, and doc outputs. However, for the xls
> (Excel) output, when the user clicks on the link, it says the link is
> invalid.
>
> Is this supported?
> If required, I can post a design and a data source.
>
> Please help!
>
> Thanks,
> Joseph]]>Jason Weathersby2012-01-17T17:20:51-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780377/#msg_780377
Can you open a bugzilla entry for this? As a work around try using the
bookmark and table of contents expressions for the target. I have
created and example that works in xls and attached it. The grey
background data item has the hyperlink and the target data item is in
red and uses a bookmark and table of contents expression.
Jason
On 1/13/2012 6:00 PM, Joseph Yeh wrote:
> Hi, I have a report design that contains several tables. And I have
> created bookmarks and hyperlinks so that the user can navigate from one
> cell of a table to another cell in another table.
> This works fine for html, pdf, and doc outputs. However, for the xls
> (Excel) output, when the user clicks on the link, it says the link is
> invalid.
>
> Is this supported?
> If required, I can post a design and a data source.
>
> Please help!
>
> Thanks,
> Joseph]]>Jason Weathersby2012-01-17T17:20:51-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780423/#msg_780423
Thanks for your reply.
I have tried your workaround suggestion, but the xls output does not work in my excel. I have a 2002 and a 2003 excel. It still says the reference is not valid when I click on the link. Am I making some mistakes somewhere?
Joseph ]]>Joseph Yeh2012-01-17T19:58:52-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780424/#msg_780424
I did run your example and the references in the XLS output are invalid still.
Thanks,
Joseph]]>Joseph Yeh2012-01-17T20:01:44-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780432/#msg_780432
Jason
On 1/17/2012 3:01 PM, Joseph Yeh wrote:
> Jason,
> I did run your example and the references in the XLS output are invalid
> still.
>
> Thanks,
> Joseph]]>Jason Weathersby2012-01-17T20:34:56-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780433/#msg_780433
<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.22" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 2.6.2.r262_v20110209 Build <2.6.2.v20110214-1523></property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
]]>Joseph Yeh2012-01-17T21:04:37-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780435/#msg_780435
Joseph Yeh2012-01-17T21:08:43-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780468/#msg_780468
Now the question is, will it be possible to make the workaround work for XLS for our versions of BIRT?
Thanks,
Joseph]]>Joseph Yeh2012-01-18T07:29:42-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780596/#msg_780596
That was an issue in the 2.6 series xls emitter. The only way I know to
work around this issue is to change the xls emitter code. The issue is
the way the range tag is generated. In 2.6 this was emitted.
On 1/18/2012 2:29 AM, Joseph Yeh wrote:
> Hi Jason, it looks that the workaround does not work on the version of
> BIRT we are using. I tried it on BIRT 3.7.1 and it worked. In fact, we
> did use the table-of-contents workaround to make the links work for the
> DOC files on our current BIRT version. It is just the XLS file that the
> links don't work. I have also tried our design on 3.7.1 and now I can
> see the links also working in the XLS file.
>
> Now the question is, will it be possible to make the workaround work for
> XLS for our versions of BIRT?
>
> Thanks,
> Joseph]]>Jason Weathersby2012-01-18T17:51:42-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780620/#msg_780620
Thanks for the answers. Do you suggest that I open a bugzilla entry against BIRT 2.6.2 to change the xls emitter as you pointed out? Or will it be a small change to some code in BIRT 2.6.2 that a patch can be created for? Would it be possible that you send me such a patch including the source code? I guess there is no other way to work around this issue, right?
Thanks,
Joseph]]>Joseph Yeh2012-01-18T19:34:12-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/780869/#msg_780869
appear to all be in ExcelXmlWriter.java
On 1/18/2012 2:34 PM, Joseph Yeh wrote:
> Hi Jason,
>
> Thanks for the answers. Do you suggest that I open a bugzilla entry
> against BIRT 2.6.2 to change the xls emitter as you pointed out? Or will
> it be a small change to some code in BIRT 2.6.2 that a patch can be
> created for? Would it be possible that you send me such a patch
> including the source code? I guess there is no other way to work around
> this issue, right?
>
> Thanks,
> Joseph]]>Jason Weathersby2012-01-19T18:34:58-00:00Re: Hyperlinks created in xls file are invalid
https://www.eclipse.org/forums/index.php/mv/msg/276091/783477/#msg_783477
Joseph]]>Joseph Yeh2012-01-25T19:41:33-00:00