Click or drag to resize

AreaRetrieval Methods

The AreaRetrieval type exposes the following members.

Methods
 NameDescription
Public methodStatic memberGetAreaType Creates area information from worksheet coordinates.
Public methodStatic memberGetColumnNumber Retrieves the column number clicked onto
Public methodStatic memberGetColumnWidthResizingPositions Get a list of horizontal positions, where the cursor should switch to a horizontal resizing cursor.
Public methodStatic memberGetCoordinatesOfDataCell Gets the coordinates of a data cell.
Public methodStatic memberGetCoordinatesOfPropertyCell Gets the coordinates of a property cell.
Public methodStatic memberGetFirstAndNumberOfVisibleColumn Gets the first visible data column and the number of visible columns.
Public methodStatic memberGetFirstVisibleColumnForLastVisibleColumn Gets the first visible column required to show a given last visible column.
Public methodStatic memberGetFirstVisiblePropertyColumn(WorksheetLayout, Int32) Gets the first visible property column.
Public methodStatic memberGetFirstVisiblePropertyColumn(Double, WorksheetLayout, Int32) Gets the first visible property column below the specified top coordinate.
Public methodStatic memberGetFirstVisibleTableRow(WorksheetLayout, Int32) Gets the first table row that is visible.
Public methodStatic memberGetFirstVisibleTableRow(Double, WorksheetLayout, Int32) Gets the first table row that is visible under the coordinate top.
Public methodStatic memberGetFullyVisibleColumns Gets the number of fully visible data columns.
Public methodStatic memberGetFullyVisiblePropertyColumns(WorksheetLayout, Int32, Double) Gets the number of fully visible property columns in the full table area, i.e. between the y coordinates 0 to TableAreaHeight.
Public methodStatic memberGetFullyVisiblePropertyColumns(Double, Double, WorksheetLayout, Int32) Gets the number of fully visible property columns between two vertical coordinates.
Public methodStatic memberGetFullyVisibleTableRows Gets the number of fully visible table rows between two vertical coordinates.
Public methodStatic memberGetLastFullyVisibleColumn Gets the last fully visible data column.
Public methodStatic memberGetLastFullyVisiblePropertyColumn Gets the last fully visible property column.
Public methodStatic memberGetLastFullyVisibleTableRow Gets the last fully visible table row.
Public methodStatic memberGetLastVisibleTableRow Gets the last visible table row.
Public methodStatic memberGetRemainingEnabledPropertyColumnsReturns the remaining number of property columns that could be shown below the current scroll position.
Public methodStatic memberGetRowNumber Returns the row number of the clicked cell.
Public methodStatic memberGetTopCoordinateOfPropertyColumn Gets the top coordinate of the specified property column.
Public methodStatic memberGetTopCoordinateOfTableRow Gets the top coordinate of the specified table row.
Public methodStatic memberGetTotalEnabledPropertyColumns Gets the number of enabled property columns.
Public methodStatic memberGetVerticalPositionOfFirstVisibleDataRow This returns the vertical position of the first visible data row.;
Public methodStatic memberGetVisibleColumns Gets the number of visible data columns.
Public methodStatic memberGetVisiblePropertyColumns Gets the number of visible property columns between two vertical coordinates.
Public methodStatic memberGetVisibleTableRows How many data rows are visible between top and bottom?
Public methodStatic memberGetXCoordinatesOfColumn Gets the horizontal position and the width of a data column.
Top
See Also