3.1.4.22 RecalcA1

This operation is used to calculate a specified range in the workbook.

 <wsdl:operation name="RecalcA1">
     <wsdl:input message="RecalcA1SoapIn" />
     <wsdl:output message="RecalcA1SoapOut" />
 </wsdl:operation>

The protocol client sends a RecalcA1SoapIn request message, and the protocol server responds with a RecalcA1SoapOut response message, as follows:

  1. If the sheetName element is missing or the rangeName element is missing then the protocol server MUST return an ExcelServerMessage as specified in section 2.2.9.2, with the value of the id element of the ExcelServerMessage set to InternalError.

  2. sheetName MUST NOT be empty.

  3. If rangeName is empty, the whole sheet (2), which was specified in sheetName, MUST be calculated.

  4. If rangeName is not empty, the specified range MUST be calculated.

In the event of an application error on the protocol server during this operation, the protocol server MUST return an ExcelServerMessage as specified in section 2.2.9.2. The id element of the ExcelServerMessage MUST be one of the values specified in section 2.2.9.4, and SHOULD<37> be one of the following values.

Id

Description

InvalidOrTimedOutSession

See section 2.2.9.5.

RetryError

See section 2.2.9.5.

OperationCanceled

See section 2.2.9.5.

MultipleRequestsOnSession

See section 2.2.9.5.

MaxRequestDurationExceeded

See section 2.2.9.5.

InternalError

See section 2.2.9.5.

InvalidSheetName

No sheet (2) in the workbook was found with a name as specified in sheetName.

RangeParseError

rangeName was not found in the workbook.