Spread 8.0 Documentation
|
|
ActiveX
|
Support Options
|
ActiveX
To display an ellipsis in a cell
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Set the Col, Col2, Row, and Row2 properties as appropriate.
- If you are selecting a block of cells, set the BlockMode property to True.
- Set the CellType property for the type of cell.
- Allow the cell to display the ellipsis for long text by setting the TypeEllipses property to True.
- If you set the CellType property to 12 (Currency), 13 (Number), or 14 (Percent) in step 3, set the TypeHAlign property to 0 (Left).
- If you selected a block of cells, set the BlockMode property back to False.