共用方式為


CameraTool Class

Defines the CameraTool Class.This class is only available in Office2010.When the object is serialized out as xml, its qualified name is a14:cameraTool.

Inheritance Hierarchy

System.Object
  DocumentFormat.OpenXml.OpenXmlElement
    DocumentFormat.OpenXml.OpenXmlLeafElement
      DocumentFormat.OpenXml.Office2010.Drawing.CameraTool

Namespace:  DocumentFormat.OpenXml.Office2010.Drawing
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

Syntax

'Declaration
<OfficeAvailabilityAttribute(FileFormatVersions.Office2010)> _
Public Class CameraTool _
    Inherits OpenXmlLeafElement
'Usage
Dim instance As CameraTool
[OfficeAvailabilityAttribute(FileFormatVersions.Office2010)]
public class CameraTool : OpenXmlLeafElement

Remarks

2.3.1 cameraTool

Target namespace: https://schemas.microsoft.com/office/drawing/2007/7/7/main

A CT_CameraTool is an element that specifies that the picture, as defined by the pic element in [ISO/IEC-29500-1] section 20.2.2.5, is a camera object. A camera object is a picture that shows a live view of a cell range in the specified spreadsheet, including any graphic objects contained in the cell range and all formatting applied to the contents of the cell range. Updates to the contents of the cell range are reflected in the camera object. Shape properties, such as the position and size of the camera object, are defined by the parent pic element. The view of the cell range MUST be a rectangle. The view of the cell range SHOULD scale vertically and horizontally to fill the rectangle exactly.

See section 2.2.5.1 for how this element integrates with ISO/IEC-29500.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

<xsd:element name="cameraTool" type="CT_CameraTool"/>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

2.5.1 CT_CameraTool

Target namespace: https://schemas.microsoft.com/office/drawing/2007/7/7/main

Referenced by: cameraTool

A complex type that specifies camera tool properties.

Attributes:

cellRange : An xsd:string ([XMLSCHEMA2] section 3.2.1) which uses standard cell reference syntax as specified in [ISO/IEC-29500-1] section 18.17.2.3. This specifies the cell range of the camera tool. The cell range MUST use the A1 style reference instead of the R1C1 reference. The cell range MUST be used when defining the camera tool.

spid : An xsd:string ([XMLSCHEMA2] section 3.2.1) that specifies the shape ID of a legacy drawing object. The legacy drawing object MUST be deleted if the current drawing element is to be used. Otherwise two camera tool objects will be present.

This string has the following characteristics:

It begins with “_x0000_” followed by 1 character and a number that specifies the ID: _x0000_[c]<shape id>

The character [c] MUST be ‘s’.

Shape IDs MUST be between 1025 and 268435456.

Shape IDs are clustered together, and each cluster has 1024 values.  The first cluster ranges from 1025 to 2048.

Shape IDs within the same cluster SHOULD only exist in one worksheet.

It MUST NOT contain NCR (Numeric Character Reference) characters.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this complex type.

<xsd:complexType name="CT_CameraTool">

<xsd:attribute name="cellRange" type="xsd:string"/>

<xsd:attribute name="spid" use="optional" default="0" type="xsd:string"/>

</xsd:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1] section 2.1).

Thread Safety

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

See Also

Reference

CameraTool Members

DocumentFormat.OpenXml.Office2010.Drawing Namespace