IWorksheetManager.GetRowPositionsInNativeSheet Method

NOTE: This member is now obsolete. Instead, use GetOverheadSheetInformation method and read the returned OverheadSheetInfo.Areas.

Gets the row numbers of various sheet areas in an overhead worksheet.
<Obsolete("Instead, use GetOverheadSheetInformation method and read the returned OverheadSheetInfo.Areas.")> _ 
Function GetRowPositionsInNativeSheet( _ 
ByVal Sheet As IWorksheet
) As Dictionary(Of PositionInNativeSheet, Integer)
This language is not supported or no code example is available.
[Obsolete("Instead, use GetOverheadSheetInformation method and read the returned OverheadSheetInfo.Areas.")] 
Dictionary<PositionInNativeSheet, int> GetRowPositionsInNativeSheet( 
IWorksheet Sheet 
)
This language is not supported or no code example is available.

Parameters

Sheet
IWorksheet

The worksheet to investigate. It must be in an overhead workbook.

Return Value

Dictionary<PositionInNativeSheet, int>

Pairs of sheet areas and their corresponding row numbers. null reference (Nothing in Visual Basic) when the areas are not applicable to the sheet.

Remarks
 
There can be three main areas in an overhead worksheet - Core estimate, Overhead task and Optional area.

The positions of the core area and the options area are always set. If the estimate contains an overhead minute, also the positions for the overhead minute area are correctly set. Otherwise the positions are -1 for the overhead minute area.

The method works only with the following worksheet types:

NativeSheetType.Currencies
NativeSheetType.Material_Set_Of_Field,  
NativeSheetType.Workforce_Set_Of_Field
NativeSheetType.Families,  
NativeSheetType.Manufacturers,  
NativeSheetType.Suppliers
NativeSheetType.Custom_Columns,  
NativeSheetType.User_Defined_Fields,  
NativeSheetType.Planner
NativeSheetType.List_Box,  
NativeSheetType.Material_Time_Frame
NativeSheetType.Workforce_Time_Frame

Version
 
Available since QDV 7.13.0001.

.NET Framework

Supported in: 4.8, 4.7, 4.6, 4.5.2

In this article

Definition