Spread 8.0 Documentation
ActiveX
Support Options

Glossary Item Box

ActiveX


To create a PIC cell

At run time,

  1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
  2. Set the Col, Col2, Row, and Row2 properties as appropriate.
  3. If you are selecting a block of cells, set the BlockMode property to True.
  4. Set the CellType property to 4 (PIC).
  5. Create the mask by providing the mask characters using the TypePicMask property.
    Use the following characters to specify what type of data the user can type into the mask:

    Mask Character Characters Allowed
    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

  6. Specify the text to display in an empty mask using the TypePicDefaultText property.
  7. Specify the horizontal and vertical text alignment in the cell by setting the TypeHAlign and TypeVAlign properties.
  8. Specify the text orientation of the data in the cell by setting the TypeTextOrient property.
  9. If you selected a block of cells, set the BlockMode property back to False.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.