Spread 8.0 Documentation
ActiveX
Support Options

Glossary Item Box

ActiveX


To add a formula to a sheet

At run time,

  1. Specify the Sheet if you have multiple sheets.
  2. Specify the cell or cells to which you want to add a formula with 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. Define the formula with the Formula property.
  5. If you selected a block of cells, set the BlockMode property back to False.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.