# VSTO-like APIs

undefined

## Content



Spread for Winforms features 26 New VSTO-like APIs for IRange and IWorksheet:

*   **IRange.AutoFill** – auto-fills the range to the specified target range
*   **IRange.HasRichDataType** – returns true if the range contains a rich cell data type object
*   **IRange.Resize** – resizes the range
*   **IRange.Width** – returns the width of the range in points
*   **IRange.Top** – returns the top coordinate of the range relative to the top of the worksheet in points
*   **IRange.Height** – returns the height of the range in points
*   **IRange.Left** – returns the left coordinate of the range relative to the left of the worksheet in points
*   **IRange.UseStandardWidth** – sets or returns whether the columns in the range use standard width
*   **IRange.UseStandardHeight** – sets or returns whether the rows in the range is the standard height
*   **IRange.ShowCard** – shows the data card for the rich cell data type object in the range
*   **IRange.Show** – scrolls the worksheet to show the specified cell (IRange must be one cell)
*   **IRange.Next** – emulates the TAB key to navigate to the next editable cell
*   **IRange.Previous** – emulates the SHIFT + TAB key to navigate to the previous editable cell
*   **IRange.FillDown** – fills the range down using the values in the top cells
*   **IRange.FillLeft** – fills the range left using the values in the right cells
*   **IRange.FillRight** – fills the range right using the values in the left cells
*   **IRange.FillUp** – fills the range up using the values in the bottom cells
*   **IRange.Dirty** – designates the cells in the range to be recalculated in the next calculation cycle
*   **IRange.BorderAround** – sets the specified borders around the cells in the range (outline border)
*   **IRange.Characters** – gets the Characters for applying formatting to part of the cell value
*   **IRange.SpecialCells** – gets the cells in the range of the specified type
*   **IWorksheet.UsedRange** – returns the range in the worksheet containing values
*   **IWorksheet.StandardWidth** – sets or returns the standard column width in the worksheet
*   **IWorksheet.StandardHeight** – sets or returns the standard row height in the worksheet
*   **IWorksheet.Next** – emulates the TAB key to navigate to the next editable cell
*   **IWorksheet.Previous** – emulates the SHIFT + TAB key to navigate to the previous editable cell