Forum Discussion

Gert_VCC's avatar
Gert_VCC
New Contributor III
6 months ago

Can you use Parameters with the Excel Add-in or in Spreadsheet

I am trying to build a quick view where the Member Filter refers to a parameter but E#|!prm_Entity!| produces this error in Excel: #ERROR - The member filter contains unresolved parameters.   ...
Excel Add In
EGalanzovsky's avatar
EGalanzovsky
New Contributor III
21 days ago

Hello Gert,

QuickView can not read parameters, but QuickView can read XFBR.

So you can not pass the parameters into XFBR bt you can call XFBR without passing the parameters.

XFBR(Workspace.VCG_STP_Blend.VCG_STP_Blend.ParamHelper, GetSelectedEntity)

But that one does not work

XFBR(Workspace.VCG_STP_Blend.VCG_STP_Blend.ParamHelper, GetSelectedEntity, SelectedEntity=|!cv_SelectedEntity!|)