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; } } }

Hyperlinks - Excel using Spudoft emmiter is invalid reference

grather

I am struggling with getting an internal hyperlink to work correctly. I have tried various ways. One just creating a href html tag.<a href="#sheet1!A!">sheet1</a> This when rendered in excel gets changedWhen mouse over the link I get sheet1_A1 not sheet!A1 as expected. The same thing happens when I have a bookmarkAnd I create a hyperlink in the properties.I end up with the same issue.When looking at in excel I endup with sheet1_A1 which is invalid reference. I have tried escaping the ! no luckEven played with some EventAdapters. But I am stuck. I can get the HYPERLINK("sheet1","sheet1") to work but it does not end up highlighted as a link. Anyone else had success? I can't figure out what I am doing wrong.Obviously something. Gary

Find more posts tagged with

Comments

Yaytay

Using HTML shouldn't work, so give up on that. The <a data-ipb='nomediaparse' href='https://bitbucket.org/yaytay/spudsoft-birt-excel-emitters/src/23ed51b1ade9308d40124825a8ab14ca11bfcc8b/SpudSoft BIRT Excel Emitters Tests/src/uk/co/spudsoft/birt/emitters/excel/tests/Hyperlinks.rptdesign?at=default'>Hyperlinks test file</a> shows how to create links using bookmarks.I have to admit that I haven't tried creating a link to a raw cell address, and given the available options I can't see any way it could work.BIRT gives three Hyperlink options:<ul class='bbc'><li>URI</li><li>Internal Bookmark</li><li>Drillthrough</li></ul>The first and the last have to support http URLs, the middle has to support BIRT bookmarks.I could possibly add some code to make the first recognise something as an Excel reference, but unless/until I do that your only option is to create a bookmark on the target range. This can be done in BIRT (again, demonstrated in that file) or in an Excel template file. Jim