CXllApp::SetHideArgumentBoxForNoArgs

Set the behavior of the Excel Formula Wizard for functions with no arguments

void SetHideArgumentBoxForNoArgs(
   bool hide
);

Parameters

hide

If hide is true, then the extra argument box that appears in the Excel Formula Wizard for functions which in fact have no arguments will be suppressed. As a side-effect, the help text for the function will not appear.

If hide is false, then the extra argument box will continue to appear. However, the help text for the function will appear.

Remarks

There is a problem with the Excel Formula Wizard when displaying functions that have no arguments. Either the Wizard displays an argument box for a non-existent argument, or the help text for the function is not displayed.

The table below shows the behavior of the Wizard when displaying a zero-argument function, for different values of hide.

The default value for this setting is false. If you want to change it, call SetHideArgumentBoxForNoArgs(true) during CXllApp::InitInstance() or CXllApp::OnXllOpenEx().

Requirements

Header: xllplus.h

See Also

CXllApp Class | CXllApp Methods | CXllApp::GetHideArgumentBoxForNoArgs()