bool TabValidateFormulaArgument(TabSheetId tTabSheet, string arg)
tTabSheet. Table moniker.
arg. A list of arguments that should be checked if it should be used in functions.
The TabValidateFormulaArgument operation checks arguments used in functions.
To execute the operation, in the tTabSheet field specify table moniker, and in the arg field specify the list of arguments to be checked. The moniker can be based on the moniker of opened object instance, the table of which is worked with, following the rules:
'Express report instance moniker'!Tab. Express report table (if express report has one sheet).
'Express report instance moniker'!Sheets!'Sheet key'!Tab. table of specified express report sheet (if express report has several sheets).
'Workbook instance moniker'!Tab. Workbook table (if workbook has one sheet).
'Workbook instance moniker'!Sheets!'Sheet key'!Tab. Table of specified workbook sheet (if workbook has several sheets).
'Workbook instance moniker'!CorrTab. Table with correlation matrix.
'Workbook instance moniker'!CoeffTab. Table with equation coefficients.
'Workbook instance moniker'!WeightsTab. Table with weight matrix.
'Regular report instance moniker'!Sheet key. Table of specified regular report sheet.
The operation results in the logical True if arguments can be used in functions, and False if the list of arguments is incorrect.
Below is the example of checking arguments that can be sent to functions. The request contains the table moniker and the list of arguments. The response contains whether arguments can be used in functions.
{
"TabValidateFormulaArgument" :
{
"tTabSheet" :
{
"id" : "PIHBEDBNELDPFOAEFEDCEMJBFINKCAOEMIHGHJAAHDLLJOHF!M!S!PLFPLFNBNELDPFOAEFCLGLLHBNEKHIFKEJIADGEJBNAOOBCCB!1"
},
"arg" : "A0:A5"
}
}
{
"TabValidateFormulaArgumentResult" : "1"
}
public static bool ValidateArgument(string moniker, string arguments)
{
var somClient = new SomPortTypeClient(); // Proxy object for operation execution
// Operation execution parameters
var tVal = new TabValidateFormulaArgument()
{
arg = arguments,
tTabSheet = new TabSheetId() { id = moniker }
};
// Check arguments
var result = somClient.TabValidateFormulaArgument(tVal);
return result;
}
See also: