IOverhead.InsertRowsInOverheadSheet Method

Inserts the new rows in the specified selection in an overhead sheet. The number of inserted rows is usually the same as the number of rows in the selection.
Function InsertRowsInOverheadSheet( _ 
ByVal rangeToInsert As IRange
) As IRange
This language is not supported or no code example is available.
IRange InsertRowsInOverheadSheet( 
IRange rangeToInsert 
)
This language is not supported or no code example is available.

Parameters

rangeToInsert
IRange

The range containing the rows to be inserted in an overhead sheet. It doesn't matter which columns it contains, only the rows are important. This range must belong to some overhead sheet.

Return Value

IRange

The rows that were actually inserted. The number of inserted rows and their position may be adjusted in some cases. So the result is not always the same as rangeToInsert. Moreover, for native sheets, the inserted rows in all areas are returned - in Core, Overhead minute and Optional. These row groups are returned as separate areas in Areas.

Exception type Condition

QdvApiException

A problem occurred.

ArgumentNullException

The rangeToInsert argument is null reference (Nothing in Visual Basic).

ArgumentException

The rangeToInsert is not valid (too large, doesn't belong to any overhead sheet, etc.).

Remarks
 
Inserting rows in an overhead sheet may be a complex operation. This method takes care of all related tasks. For example, it duplicates the rows from Core area to Optional and Overhead areas in native sheets, recalculates dependent values, etc.
Version
 
Available since QDV 7.22.958.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition