VSTO-like APIs

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