FarPoint's Spread for Windows Forms Product Tour

You can divide up the display into separately scrollable viewports. You may have a row of viewports (viewport row) or a column of viewports (viewport column) or both. For an end user to create a viewport, the end user can simply click on the split box and drag it to the desired location. The end user can create multiple viewports in either direction.

// Add and initialize a viewport

							fpSpread1.AddViewport(1, 2);

							fpSpread1.SetViewportLeftColumn(1, 3);

							fpSpread1.SetViewportTopRow(0, 6);

							fpSpread1.SetViewportPreferredHeight(0, 100);

							fpSpread1.SetViewportPreferredWidth(0, 100);

							

							' Add and initialize a viewport

							fpSpread1.AddViewport(1, 2)

							fpSpread1.SetViewportLeftColumn(1, 3)

							fpSpread1.SetViewportTopRow(0, 6)

							fpSpread1.SetViewportPreferredHeight(0, 100)

play video

Customizing Split Boxes
You can determine the display and alignment of the split boxes for allowing the user to add viewports. By default, the split boxes are shown and appear at the leading edge of the scroll bar. `fpSpread1.ColumnSplitBoxAlignment = FarPoint.Win.Spread.SplitBoxAlignment.Leading; fpSpread1.ColumnSplitBoxAlignment = FarPoint.Win.Spread.SplitBoxAlignment.Leading`

Customizing the Position in the Display
You can control the position of the spread sheet in the display by choosing a row, column, or cell, and moving it to a particular position in the displayed portion of the spread sheet in the control. Use the ShowRow, ShowColumn, ShowCell, or ShowActiveCell methods in the FpSpread class, and the HorizontalPosition and VerticalPosition enumerations. These methods scroll the display until the specified item is displayed in the specified location.

Placing Child Controls on a Sheet
You can place controls, including other 3rd party controls, on a sheet (not just the FpSpread component but a specific sheet) to provide more interaction with the user. Use the AddControl method for the Spread control or the sheet. Anything that can be derived from the Control class in the .NET framework can be hosted on a sheet in FarPoint Spread. The control resides on a separate control layer to provide more interaction with the user. This is in addition to the data area where cells are and drawing layer where shapes and other graphical elements are located