Share via


ConditionalFormatStyle.Val Property

Definition

Conditional Formatting Bit Mask

Represents the following attribute in the schema: w:val

[DocumentFormat.OpenXml.SchemaAttr(23, "val")]
public DocumentFormat.OpenXml.StringValue Val { get; set; }
public DocumentFormat.OpenXml.StringValue Val { get; set; }
[DocumentFormat.OpenXml.SchemaAttr(23, "val")]
public DocumentFormat.OpenXml.StringValue? Val { get; set; }
[DocumentFormat.OpenXml.SchemaAttr("w:val")]
public DocumentFormat.OpenXml.StringValue? Val { get; set; }
public DocumentFormat.OpenXml.StringValue? Val { get; set; }
member this.Val : DocumentFormat.OpenXml.StringValue with get, set
[<DocumentFormat.OpenXml.SchemaAttr(23, "val")>]
member this.Val : DocumentFormat.OpenXml.StringValue with get, set
[<DocumentFormat.OpenXml.SchemaAttr("w:val")>]
member this.Val : DocumentFormat.OpenXml.StringValue with get, set
Public Property Val As StringValue

Property Value

Returns StringValue.

Attributes

Remarks

The following information from the ECMA International Standard ECMA-376 can be useful when working with this class.

Specifies the set of conditional formatting properties that have been applied to this object.

These properties are expressed using a string serialization of a binary bitmask for each of the following properties (reading from the first character position right):

  • First Row - Is this the first row of the table?

  • Last Row - Is this the last row of the table?

  • First Column - Does this belong to the first column of the table?

  • Last Column - Does this belong to the last column of the table?

  • Band 1 Vertical - Does this belong to a column which should receive Band 1 formatting? This property specifies whether the cell should receive the formatting specified for odd-numbered columns (1, 3, 5, and so on).

  • Band 2 Vertical - Does this belong to a column which should receive Band 2 formatting? This property specifies whether the cell should receive the formatting specified for even-numbered columns (2, 4, 6, and so on).

  • Band 1 Horizontal - Does this receive Band 1 formatting? This property specifies whether the cell should receive the formatting specified for odd-numbered rows (1, 3, 5, and so on).

  • Band 2 Horizontal - Does this receive Band 2 formatting? This property specifies whether the cell should receive the formatting specified for even-numbered rows (2, 4, 6, and so on).

  • NE Cell - Is this part of the top-right corner of the table?

  • NW Cell - Is this part of the top-left corner of the table?

  • SE Cell - Is this part of the bottom-right corner of the table?

  • SW Cell - Is this part of the bottom-left corner of the table?

For each of these properties, a value of 1 in the specified character position in the string means that the value is true; and a value of 0 means false. All the values must be specified.

Consider a paragraph in the top-right corner of a table with a table style applied. This paragraph would need to specify the following WordprocessingML:

<w:p>  
  <w:pPr>  
    <w:cnfStyle w:val="101000000100" />  
    ...  
  </w:pPr>  
  ...  
</w:p>  

This paragraph specifies that it has the conditional properties from the table style for the first column, first row, and NW corner of the parent table by setting the appropriate bits in the val attribute.

The possible values for this attribute are defined by the ST_Cnf simple type.

Applies to