![]() For "long" (as in string length # chars), the Excel app shows the '=HYPERTEXT(.)' text, i.e. Then I read up on ods excel with the options(flow='tables'). However, if they "edit" that cell, change nothing, and resubmit the exact text, then Excel will "recognize" the =HYPERLINK() function and convert the cell to the (blue) hyperlink (as desired). I started with proc export dbms=xlsx, but when I opened the xlsx file in Excel app, it would show the "=HYPERLINK(.)" text and not the (blue) hyperlink with the link "hidden". If Excel sees '=HYPERLINK(.)' then it should create the link, right? ![]() I created a column in a dataset where the char content is '=HYPERLINK("","")'. I want to make hyperlinks in Excel - so that the user would open the spreadsheet and see some cells with (familiar) blue, underlined text which are hyperlinks to a URL HREF ( One click on the to the link, and the web browser opens up.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |