You can quickly design a spreadsheet component using the Spread Designer. Whether you are prototyping a complete spreadsheet component or simply customizing some aspect of an existing spreadsheet component, the dedicated graphical interface offers many features to save time and effort. There are several ways to use the designer. You can use the designer in Visual Studio, as a stand-alone application, or you can load designer dialogs using code. You can start the Spread Designer from inside your Visual Studio .NET project by doing one of the following:

  • Right-click on the FpSpread component on your form and choose Spread Designer. SpreadWinSDrightclick Right-Click Option
  • Select the Spread Designer verb at the top right-edge of the Spread control. SpreadWinSDverb Spread Designer Verb

You can also run the Spread Designer outside of Visual Studio .NET as a stand-alone application. For many developers who want to create and share designs, this is a quick way to design FpSpread-based applications and save them as either XML or Excel-compatible files. Practically all of the functionality you expect from the Spread Designer is available in this stand-alone application except those features that involve applying to and reverting from the form in Visual Studio. Run the FarPoint.SpreadDesigner.EXE from the product bin folder to use the Spread Designer as a stand-alone application. You can use the Spread Designer in your project with code. Add the FarPoint.Win.Spread.Design dll to the list of references in your Visual Studio project. Then select the FpSpreadDesigner component from the Toolbox under the GrapeCity Spread section and drag it to the form. SpreadWinSDCode FpSpreadDesigner You can use one of the following API methods to display the designer:

Method

Description

Show

Displays the Spread Designer for the specific FpSpread control.

ShowDialog

Displays the Spread Designer as a modal dialog box for the specific FpSpread control.

This example displays the FpSpreadDesigner component at run time after it has been added to the form at design time. C#

fpSpreadDesigner1.Show(fpSpread1);

VB

FpSpreadDesigner1.Show(FpSpread1)

This example displays the FpSpreadDesigner component at run time after it has been added to the form at design time. C#

fpSpreadDesigner1.ShowDialog(fpSpread1);

VB

FpSpreadDesigner1.ShowDialog(FpSpread1)

This example loads the cell type editor. SpreadWinSDCells Cell Type Editor C#

FarPoint.Win.Spread.Design.ExternalDialogs.CellTypeEditor(fpSpread1);

VB

FarPoint.Win.Spread.Design.ExternalDialogs.CellTypeEditor(FpSpread1)

This example uses the border editor. SpreadWinSDBorder Border Editor C#

FarPoint.Win.Spread.Design.ExternalDialogs.BorderEditor(fpSpread1);

VB

FarPoint.Win.Spread.Design.ExternalDialogs.BorderEditor(FpSpread1)

This example uses ANNUAL_sample_csv.csv from https://www.ncdc.noaa.gov/cdo-web/datasets. Use the File tab and the Open menu to load the file. Use the default column delimiter and line feed for the row delimiter. SpreadWinSDloadfile Load File The first row of text in this example uses bold formatting. You can set other formatting options using the designer. SpreadWinSDboldtext Spread Designer Example