Spread 8.0 Documentation
ActiveX
Support Options

Glossary Item Box

ActiveX


To return formatted data

You can return formatted data using different properties or methods, depending on the data you want to return. For more detailed information about each of these properties and methods, see the property or method topic in the ActiveX Reference.

Cell type Method or Property Use to return . . .
Button, Check box, Combo box, Date, Edit, PIC, Static Text, Time Clip Block of data
Text Data for cell, column, row, or sheet as specified using Col and Row properties
GetText Data for cell, column, row, or sheet as specified using Col and Row parameters
Currency, Number, Percent Clip Block of data
Text Data for cell, column, row, or sheet as specified using Col and Row properties

Note: For the Text property and the GetText method, if you set the data in the sheet by setting the Col or Row property or the Col or Row parameters to –1, this property and method will return the text for the entire column, row, or sheet you specify. If you did not set the data with the Col or Row property or Col or Row parameter set to –1, and then attempt to return data by setting the Col or Row property or the Col or Row parameter to –1, the property or method will not return a value.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.