FarPoint Technologies
(800) 645-5913
fpsales@fpoint.com
|
|
You can save data from the fpSpread control into many different
file formats. Also, depending on how you want to save the data, you might have
a choice to save the data only, or to save the data and formatting.
Specify Which Elements Users Can
Select | Specify the Operation
Mode | Use Virtual
Mode Back to Top
You can let the user select only columns,
rows, blocks, all cells, or any combination of these.
In addition to
this setting, the operation mode of the spreadsheet affects which elements
users can select. For example, in single-selection mode, users can only select
one row in the spreadsheet at a time, similar to the behavior of a
single-selection list box.
The following example lets the user select
both rows and blocks of cells only.
fpSpread1.SelectBlockOptions = SS_SELBLOCKOPT_ROWS OR SS_SELBLOCKOPT_BLOCKS |
 |
|
Back to Top
Operation modes control how the spreadsheet
reacts to user interaction and the types of user interaction available.
The following choices are available:
| Normal |
Default operation |
| Read Only |
Places spreadsheet in read-only mode (Within this mode,
there is no current active cell). |
| Row |
Clicking a row moves the focus to that row.
Double-clicking a cell moves the focus to that cell. |
| Single-selection |
Operates similarly to a single-selection list box.
|
| Multiple-selection |
Operates similarly to a multiple-selection list
box. |
| Extended-selection |
Operates similarly to a extended-selection list box
|
The following example sets the spreadsheet to
operate like a multiple-selection list box.
fpSpread1.OperationMode = SS_OP_MODE_MULTI_SELECT |
 |
|
Back to Top
Use virtual mode to increase fpSpread
control responsiveness when working with large amounts of data. You can use
virtual mode for a spreadsheet with a large number of rows or for a spreadsheet
bound to a large database
In virtual mode, the spreadsheet reads ahead
only when needed to display additional rows and retrieves records from a buffer
area for faster response. You can specify characteristics of virtual mode, such
as how many rows are read into the buffer area at a time. In addition, you can
display a special vertical scroll bar to use with virtual mode.
The
following example sets the maximum number of rows to 1000 and the number of
rows in the virtual buffer to 100. The number of virtual rows is 10 and special
scroll bars are displayed.
fpSpread1.VirtualMaxRows = 1000
fpSpread1.VirtualOverlap = 100
fpSpread1.VirtualRows = 10
fpSpread1.VirtualMode = True
fpSpread1.VirtualScrollBuffer = True
fpSpread1.VScrollSpecial = True
fpSpread1.VScrollSpecialType=
SS_VSCROLLSPECIAL_NO_PAGE_UP_DOWN |
 |
|
 |
|
 |
|
|
| Have a question? |
|
 |
|