BlockMode Property
Applies To
fpSpread control
Description
Sets or returns whether you can modify a block of cells. This property is available at run time only.
Syntax
BOOL CSpreadSheet::GetBlockMode( );
void CSpreadSheet::SetBlockMode(BOOL value);
[form.]fpSpread.BlockMode[ = boolean%]
Remarks
The BlockMode property lets you perform an action on, provide data for, or assign settings to a selected block of cells.
The default value for the BlockMode property is False, which means you can only modify individual cells.
This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.
Use the Col, Row, Col2, and Row2 properties to designate a block of cells in the sheet. When the BlockMode property is set to True, you can make modifications to the designated block of cells using the following properties:
- BackColor
- CellType and CellType-related properties
- Font and Font-related properties
- ForeColor
- Formula
- Lock
- Text
- Value
You can use the AllowMultiBlocks and the AddSelection method to select multiple discontiguous blocks.
| Note: When modifications to a block of cells are complete, the BlockMode property should be set to False. |
Spread Designer
If you select a block of cells in the Spread Designer, the BlockMode property is automatically set to True. By setting properties, you can then perform an action on, provide data for, or assign settings to the block of cells.
Once modifications are made to a property in the Spread Designer, the BlockMode property is automatically set back to False.
If you are using Learn Mode and work with a block of cells, the BlockMode property is set in the generated code.
Data Type
Integer (Boolean)
See Also
AllowMultiBlocks, BackColor, CellType, Col, Col2, Font, FontBold, FontItalic, FontName, FontSize, FontStrikethru, FontUnderline, ForeColor, Formula, Lock, Row, Row2, Sheet, Text, Value properties
AddSelection method