Element Details: Subpattern+Block
 Back


Available in: Logi Info Source code name: SubPatternBlock

The SubPatternBlock element establishes a region within its corresponding parent PatternBlock or SubPatternBlock region. Developers can specify pattern blocks within pattern blocks to work with hierarchical datasets. Choose the first and last row to establish the SubPatternBlock region area.

Note: The first and last row numbers must be relative to the parent pattern block.



ATTRIBUTES

Click attribute Name to drill down for more information.

NamePossible ValuesDescription
DisposableFirstRow
UserDefined
Developers can specify disposable regions to avoid writing complicated formulas to dynamically update formulas, charts, pivot tables and other Excel spreadsheet objects. A disposable row is equivalent to a dummy row of data - the row is removed from the final output after all datarows are added. Specify the first row for the disposable region that does not overlap with any row from the corresponding pattern block region.
DisposableLastRow
UserDefined
Developers can specify disposable regions to avoid writing complicated formulas to dynamically update formulas, charts, pivot tables and other Excel spreadsheet objects. A disposable row is equivalent to a dummy row of data - the row is removed from the final output after all datarows are added. Specify the last row for the disposable region that does not overlap with any row from the corresponding pattern block region.
FillMode
Overwrite
Insert
Set this attribute to specify template is filled with data. The two modes are "Insert" and "Overwrite". Insert Mode (default): The server will insert new rows into the Excel template for each row of data returned by the data layer. The number of rows inserted is equal to the total number of rows in the pattern block range. Overwrite Mode: The server will write data to existing rows in the Excel template. Data and formatting that exists in the template may get overwritten using this mode. NOTE: Use caution when mixing fill modes for pattern blocks defined in a single Template definition. Avoid undesirable results by choosing one fill mode for all pattern blocks.
FirstRow
UserDefined
(Required) Specify the first row for this pattern block. The row number must either correspond to a row from the Excel spreadsheet or a row from the parent pattern block.
ID
UserDefined
(Required) The ID attribute is a pervasive attribute that uniquely identifies an element within a definition file. The ID needs to be a unique value within the definition.
LastRow
UserDefined
(Required) Specify the last row for this pattern block. The last row must either correspond to a row from the Excel spreadsheet or a row from the parent pattern block. Note: Make the First Row and Last Row equal to specify a one row block.



PARENT ELEMENTS

Click element to drill down for more information.

Pattern Block Subpattern Block


CHILD ELEMENTS

Click element to drill down for more information.

Pattern Block Cell Subdata Layer Subpattern Block


 Back to top