Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
InputCells class
Collapse the table of content
Expand the table of content

InputCells class

Input Cells. When the object is serialized out as xml, its qualified name is x:inputCells.

Namespace:  DocumentFormat.OpenXml.Spreadsheet
Assembly:  DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)

public class InputCells : OpenXmlLeafElement

[ISO/IEC 29500-1 1st Edition]

inputCells (Input Cells)

This collection describes each input cell for the scenario.

Parent Elements

scenario (§18.3.1.75)

Attributes

Description

deleted (Deleted)

Input cell was deleted. This input cell shall be present in the file format, but shall not be presented to the user as part of the scenario inputs, nor run as part of the scenario.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

numFmtId (Number Format Id)

This number format Id is used only when displaying the scenario manager input UI, and is used to properly format for display the cached input values (see val attribute) for the scenario.

The possible values for this attribute are defined by the ST_NumFmtId simple type (§18.18.47).

r (Reference)

Cell reference indicating the input cell address.

The possible values for this attribute are defined by the ST_CellRef simple type (§18.18.7).

undone (Undone)

Cell's deletion was undone. When true the r (reference) value shall not adjust in response to the cell moving due to row / column insert or delete,or cell move.

The possible values for this attribute are defined by the W3C XML Schema boolean datatype.

val (Value)

Value that should be used for the cell when this scenario is run.

val does not need a corresponding data type, the value is put into the cell when the scenario is run.

The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19).

[Note: The W3C XML Schema definition of this element’s content model (CT_InputCells) is located in §A.2. end note]

© ISO/IEC29500: 2008.

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