Operations on Blocks of Values

  • What are the drag-and-drop facilities?
    Statistica Spreadsheets support all standard spreadsheet (Excel-style) block drag-and-drop operations (copy, move, insert, etc.) and block extension operations, as well as mouse pointer-controlled column width, variable-speed scrolling, and split scrolling.
  • Can I rearrange blocks of data or ranges of cases and variables in a data file?
    You can use three types of operations to rearrange blocks of data or ranges of cases and variables in a data file:
  • What is the difference between copy and copy with headers?
  • Do Statistica Spreadsheets support split display?
    Yes. Spreadsheets can be split into up to four sections (panes) by dragging the split box (the black rectangle at the top of the vertical scrollbar or to the left of the horizontal scrollbar). This is useful if you have a large amount of information and you want to review results from different parts of the spreadsheet. When you guide the mouse pointer to the split box, the pointer changes to  (or ). Now, to position the split, click and drag the pointer to the desired position.
  • How can I expand a block in the spreadsheet outside the current screen?
    Blocks can be selected by (1) highlighting a block with the mouse pointer, (2) clicking in one corner of the block to be selected, scrolling to the desired opposite corner (the original cell remains selected), and SHIFT+click in that cell, or (3) pressing the SHIFT key while using the arrow keys on the keyboard. To expand a previously selected block, you can use the SHIFT+cursor key, or scroll the display with the mouse pointer and SHIFT+click in the desired corner of the block. To select a large block in "split-pane" mode (as shown below), click in a cell in one pane, and then scroll (in the same pane) to display the diagonally opposite corner of another pane and SHIFT+click to select the block.
  • Can I expand the data file using drag-and-drop?
    Yes. You can use drag-and-drop operations to increase the size of the spreadsheet by moving or copying a block [either all or some of the variable(s) or case(s)] beyond the current spreadsheet boundaries.