3.1.4.2 CalculateA1

  • Article

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

The following is the WSDL port type specification of the CalculateA1 WSDL operation.

 <wsdl:operation name="CalculateA1" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">
   <wsdl:input message="tns:CalculateA1SoapIn"/>
   <wsdl:output message="tns:CalculateA1SoapOut"/>
 </wsdl:operation>

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

  1. If the protocol determines that the workbook does not need to be calculated, it MUST succeed the operation and it MUST ignore the sheetName and rangeName parameters.

  2. sheetName MUST be present and MUST NOT be empty, if rangeName is not empty. If sheetName is not present or is empty, the whole workbook MUST be calculated.

  3. rangeName MUST be present. If rangeName is empty, and sheetName is present and not 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.

  5. If there was an application error on the protocol server during the operation, the protocol server MUST return a SOAP fault response, which SHOULD contain one of the following subcodes or any other subcodes specified in section 2.2.9.2, but MAY instead contain any subcode specified in section 2.2.9.1 or any other subcode.

    Subcode

    DiscontiguousRangeNotSupported

    EcsInvalidNamedObject

    InvalidSheetName

    RangeDefinitionError

    RangeParseError

    RangeRequestAreaExceeded

    SheetRangeMismatch