Spread 8.0 Documentation
Creating Button Cells
Support Options
User's Guide > Setting Up the Control > Setting the Cell Type > Creating Button Cells

Glossary Item Box

Creating Button Cells


Button cells look and act like rectangular buttons in your sheet, as shown in the following figure.

By default, button cells act like push buttons, which you can press by pressing your left mouse button, and which do not stay pressed when you release your mouse button. If you prefer, button cells can act like toggle, or two-state, buttons, which stay pressed when you click them using your left mouse button. Buttons are false when they are not pressed, and true when they are pressed.

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.

You can customize the colors in button cells, including the color of the border, text, and background. In addition, button cells can display a three-dimensional appearance, and you can customize the colors of the highlight and shadow in the appearance.

For a description of how button cells validate data, see Data Validation.

In summary, you can use the following properties to customize button cells. The italicized properties are unique to this cell type. For more information on remembered properties, refer to Cell Type Settings Remembered.

TypeButtonAlign TypeButtonLightColor TypeButtonText
TypeButtonBorderColor TypeButtonPicture TypeButtonTextColor
TypeButtonColor TypeButtonPictureDown TypeButtonType
TypeButtonDarkColor TypeButtonShadowSize

The following methods can be used to load or save pictures in the cell.






Copyright © GrapeCity, inc. All rights reserved.