FarPoint's Spread Developer Tour

Button Cell
Button cells can display text, pictures, or both. If they display pictures, you can choose that a different picture is displayed when the button is pressed. You can specify the alignment of text and pictures in button cells. Button cells can also act like toggle, or two-state, buttons, which stay pressed when you click them using your left mouse button. `fpSpread1.CellType = CellTypeButton`

Checkbox Cell
Check box cells provide a check box that can show two or three states. Check box cells can display text and a check box picture, which you can customize. `fpSpread1.CellType = CellTypeCheckBox`

Combobox Cell

Combo box cells can function as drop-down combo boxes or drop-down list boxes. By default, they function as drop-down list boxes, in which the user cannot edit the text in the cell. If you prefer, you can change the cell to act as a drop-down combo box, in which users can edit the text in the cell. The cell then acts as the edit field for the combo box.

Note: You can create a more powerful combo box cell by placing a List Pro control on the fpSpread control.

fpSpread1.CellType = CellTypeComboBox

Currency Cell
Currency cells display numbers in monetary formats and offer a variety of formatting options.You can customize the currency cell's formatting, as well as characteristics such as maximum and minimum values, data alignment and orientation, and spin buttons. `fpSpread1.CellType = CellTypeCurrency`

Date Cell
Date cells display date values using one of several date formats. You can limit the date values allowed in the date cell by setting the maximum and minimum date values to any dates between 01/01/1000 and 12/31/9999. If you double click a date cell when it is in edit mode, a pop-up calendar appears that easily enables your user to select a date value. `fpSpread1.CellType = CellTypeDate`

Edit Cell
You can specify that letters typed, pasted, or provided in code, or from a database to the cell, are displayed in all upper case, all lower case, or as they were provided. The text in the cell can be horizontally and vertically aligned in the cell. If you are using the ActiveX or VBX control, you can choose to have the edit field appear as a password field. `fpSpread1.CellType = CellTypeEdit`

Formatted PIC (Mask) Cell

PIC cells act as masks, limiting user entry for each item in the mask to characters sets that you specify. You can use the following characters to specify what type of data the user can type into the mask:

X: Any ASCII character
9: 0–9, decimal
A: A–Z, a–z plus any alphabetic character from larger character sets such as ANSI or Unicode
N: A–Z, a–z, 0–9, decimal
U: A–Z
L: a–z
H: (Hexadecimal) 0–9, a–f, A–F

fpSpread1.CellType = CellTypePic

Number Cell
Number cells display numbers in integer and decimal formats and offer a variety of formatting options. You can customize the number cell's formatting, as well as characteristics such as maximum and minimum values, data alignment and orientation, and spin buttons. `fpSpread1.CellType = CellTypeNumber`

Owner Drawn Cell
The owner drawn cell allows you to paint items directly into the cell using Windows API calls. `fpSpread1.CellType = CellTypeOwnerDrawn`

Percent Cell
Percent cells display numbers in percent formats and offer a variety of formatting options. You can customize the percent cell's formatting, as well as characteristics such as maximum and minimum values, data alignment and orientation, and spin buttons. `fpSpread1.CellType = CellTypePercent`

Picture Cell

Picture cells display pictures that you specify. The displayed picture can be either a bitmap or an icon. You can specify how the picture is displayed in the cell: centering it or stretching it to fit the cell. If you stretch the picture to fit the cell, the picture might become distorted if its proportions are changed. To prevent this, you can specify that pictures stretched to fit maintain their original proportions.

fpSpread1.CellType = CellTypePicture

Static Text Cell
Static text cells act as labels. Users cannot edit the cell, only see its contents. You can set the text’s horizontal and vertical alignment and specifying whether text can wrap in the cell. In addition, if you want to provide the appearance of providing a mnemonic character, you can underline one of the letters in the text. `fpSpread1.CellType = CellTypeStaticText`

.Back to Top

Time Cell
Time cells display time values. You can specify one of several time formats. You can set maximum and minimum values for the time values, and you can customize the available time formats. In addition, you can provide a spin button to let users quickly change time values. `fpSpread1.CellType = CellTypeTime`