Spread Windows Forms 15.0
Spread Windows Forms 15.0 Product Documentation / Developer's Guide / Cell Types / Working with Editable Cell Types / Setting a Percent Cell
In This Topic
    Setting a Percent Cell
    In This Topic

    You can use a percent cell for displaying values as percentages and restricting inputs to percentage numeric values.

    Example of precent cell in the spreadsheet

    You use the PercentCellType class to set the percent cell and its properties.

    Using Spin Buttons

    By default, no spin buttons are shown, but you can display spin buttons on the side of the cell when the cell is in edit mode. You can set various spin functions using the properties of the PercentCellType class that begin with the word Spin. Refer to Displaying Spin Buttons.

    Using the Calculator

    By default, in a percent cell, if you double-click on the cell in edit mode at run-time, a pop-up calculator appears. You can determine whether to allow this, and you can specify the text that displays in the OK and Cancel buttons. For more information, refer to Customizing the Pop-Up Calculator Control. To prohibit the popping up of the calculator, cancel the FpSpread SubEditorOpening event. Handle this event and set the Cancel argument of the SubEditorOpeningEventArgs to True.

    For more information on the properties and methods of this cell type, refer to the PercentCellType class.

    Using the Properties Window

    1. At design time, in the Properties window, select the Spread component.
    2. Select the Sheets property.
    3. Click the button to display the SheetView Collection Editor.
    4. In the Members list, select the sheet in which the cells appear.
    5. In the property list, select the Cells property and then click the button to display the Cell, Column, and Row Editor.
    6. Select the cells for which you want to set the cell type.
    7. In the property list, select the CellType property and choose the Percent cell type.
    8. Expand the list of properties under the CellType property. Select and set these specific properties as needed.
    9. Click OK to close the Cell, Column, and Row Editor.
    10. Click OK to close the SheetView Collection Editor.

    Using Code

    1. Define the percent cell by creating an instance of the PercentCellType class.
    2. Set properties for the class.
    3. Assign the percent cell type to a cell or range of cells by setting the CellType property for a cell, column, row, or style to the PercentCellType object.


    This example sets a cell to be a percent cell and displays an abbreviation (PRCNT) instead of the percent sign (%).

    Copy Code
    FarPoint.Win.Spread.CellType.PercentCellType prctcell = new FarPoint.Win.Spread.CellType.PercentCellType();
    prctcell.PercentSign = "PRCNT";
    prctcell.PositiveFormat = FarPoint.Win.Spread.CellType.PercentPositiveFormat.PercentBefore;
    fpSpread1.ActiveSheet.Cells[1, 1].CellType = prctcell;
    Copy Code
    Dim prctcell As New FarPoint.Win.Spread.CellType.PercentCellType()
    prctcell.PercentSign = "PRCNT"
    prctcell.PositiveFormat = FarPoint.Win.Spread.CellType.PercentPositiveFormat.PercentBefore
    fpSpread1.ActiveSheet.Cells(1, 1).CellType = prctcell

    Using the Spread Designer

    1. Select the cell or cells in the work area.
    2. In the property list, in the Misc category, select CellType. From the drop-down list, choose the Percent cell type. Now expand the CellType property and various properties are available that are specific to this cell type. Select and set those properties as needed.

      Or right-click on the cell or cells and select Cell Type. From the list, select Percent. In the CellType editor, set the properties you need. Click Apply.

    3. From the File menu choose Apply and Exit to apply your changes to the component and exit Spread Designer.
    See Also