This content has been marked as final. Show 1 reply
The only way that I know of 'officially' is to set the entire worksheet to show calculation status.
If you want to do something where you call a method for a given POV to determine it's status, I do not believe there is any way to accomplish that through API calls.
A couple thoughts
#1 - Create a hidden worksheet with all of the intersections you want status for and set that worksheet to cellstatus
#2 - Use some HFM API calls to get the direct information you want. Drawback is that you need to now link in COM DLLs from HFM with your smartview documents...
Declare Function HypSetSheetOption Lib "HsAddin.dll" (ByVal vtSheetName As Variant, ByVal vtItem As Variant, ByVal vtOption As Variant) As Long Sub SetSheetDisplayOption(strWorkSheetName) X=HypSetSheetOption(strWorkSheetName, 15, 1) If X=0 Then MsgBox("Calc Status Display Option set for " & strWorkSheetName) else if X > 0 then MsgBox("Calc Status Display Option could not be set for " & strWorkSheetName & " due to server error.") else MsgBox("Calc Status Display Option could not be set for " & strWorkSheetName & " due to local error.") end if end if End Sub
#3 - If you reverse engineer the communication between smartview and the ASP page it talks to, you can figure out how Smartview requests the cell status information and then you can make your own queries to get exactly what you want. A little more work and not out of the box.....
Edited by: beyerch2 on Jan 25, 2013 10:11 AM
Edited by: beyerch2 on Jan 25, 2013 10:14 AM