Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Replacing Mouseover URL in Excel

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Replacing Mouseover URL in Excel
 Login/Join
 
Marie
Member
posted
Hi,

Does anyone know if you can "replace" the mouseover URL text that you see in Excel when you hover over a drilldown? My user would like to see somthing like the description of the drilldown as opposed to all the parameters.

I should also add that this is coded as a multi drill, which of course only works in HTML, but at least allows drilling to the top report in Excel.

Thanks, Marie
WebFOCUS 7.1.6 on Win 2K SP2 - Self Service


WebFOCUS 7.1.6 on Win 2K SP2 - Self Service, Informix SQL Passthru
 
Posts: 14 | Location: Seattle, WA | Registered: June 15, 2005Report This Post
Kerry
Expert
posted Hide Post
Hi Marie,

Please contact Information Builders' Customer Support Services and submit a New Feature Request (NFR). You may either call at 1-800-736-6130, or access the online system InfoResponse. Here is a list of information to be ready when you call: http://techsupport.ibi.com/before_you_call.jsp.

Hope this helps. Smiler

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.
 
Posts: 1948 | Location: New York | Registered: November 16, 2004Report This Post
<JG>
posted
Marie, For what you need to do you must use EXL2K TEMPLATE

Using a macro you can assign custom tips to the hyperlinks

here's an example

create an excel template file and and add the following macro code


  
Public Sub Auto_open()
Dim nm As Name
Dim Row As Long
Dim LastRow As Long
Dim Country As String
On Error Resume Next

Set nm = ThisWorkbook.Names("myflag")
If Not nm Is Nothing Then
Exit Sub
End If
ThisWorkbook.Names.Add Name:="myflag", RefersTo:="=1", Visible:=False
 ActiveWorkbook.Sheets("Sheet1").Activate
  LastRow = Cells(Rows.Count, 1).End(xlUp).Row
  For Row = 2 To LastRow Step 1
   If Row <= LastRow Then
    Range(Cells(Row, 1), Cells(Row, 1)).Select
    Country = Cells(Row, 1).Value
    Selection.Hyperlinks(1).ScreenTip = "Details for country " & Country
    Else
    Exit Sub
   End If
   Next Row
End Sub


The focexec to go with it looks like this

TABLE FILE CAR
SUM
DEALER_COST RETAIL_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT EXL2K TEMPLATE custom_tip SHEETNUMBER 1
ON TABLE SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.000000,
RIGHTMARGIN=0.000000,
TOPMARGIN=0.000000,
BOTTOMMARGIN=0.000000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=DATA,COLUMN=N1,
FOCEXEC=CARINST(COUNTRY=COUNTRY),
$
ENDSTYLE
END

This message has been edited. Last edited by: <JG>,
 
Report This Post
Marie
Member
posted Hide Post
Thanks JG,

I will give that a try.

Marie


WebFOCUS 7.1.6 on Win 2K SP2 - Self Service, Informix SQL Passthru
 
Posts: 14 | Location: Seattle, WA | Registered: June 15, 2005Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Replacing Mouseover URL in Excel

Copyright © 1996-2020 Information Builders