Spread 8.0 Documentation
ActiveX
Support Options

Glossary Item Box

ActiveX


To resize a cell based on the tallest data in that row

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. Return the minimum height necessary to display the tallest data in a specific row with the MaxTextRowHeight property (specify the row using the lRow parameter) and assign it to a variable.
  3. Set the RowHeight property for that row equal to the variable from step 1.
© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.