Can I Add a Folder to a Workbook?
By default, when results are automatically added to a workbook, they are included in a folder that identifies from what analysis they came; however, you can add as many folders (and levels) to a workbook as you want. This allows you to easily organize all of the items in your workbook, including spreadsheets, reports, and non-STATISTICA documents that are placed as sibling in the first level of the workbook by default. As with all items you can add to a workbook, folders can be inserted as either a sibling or a child to current workbook items.
Folders are added to the workbook tree via the Insert Workbook Item dialog. Right-click on the first folder in the workbook tree to display a shortcut menu, and select Insert to display this dialog.
You can also select Insert from the Workbook menu or press the INSERT key on your keyboard
When the Insert Workbook Item dialog is displayed, select the Workbook folder option button in the Item group and As first child in the Placement group. Note that the sibling options in this box are disabled because we are adding an item to the root level of the workbook tree and it cannot have siblings. Click the OK button to add the folder to the workbook tree. Although folders can be added to any part of the workbook tree, this example adds a new folder to the first folder in the tree. Note that when the folder is initially added to the tree, its name is selected. You can rename the folder at this time by entering a new name.
To rename the folder at a later time, double-click on the name New Folder, and enter a new name.
How Do I Add a New ActiveX Document to a Workbook?
New ActiveX documents (e.g., STATISTICA Spreadsheets and Graphs, Excel spreadsheets, Word documents) are added to the tree via the Insert Workbook Item dialog. To display this dialog, select Insert from the Workbook menu. You can also right-click in the tree and select Insert from the workbook tree shortcut menu or press INSERT on your keyboard. The example below adds a new Word document as a child to the new folder created in Can I Add a Folder to a Workbook? (above).
Right-click on the New Folder and select Insert from the shortcut menu. Note that you can always move or copy the item to a new location later (using drag-and-drop features), so the exact location is not critical (even for this example). On the Insert Workbook Item dialog, select the ActiveX Document Object option button in the Item box and the As first child option button in the Placement box. Then click the OK button to display the Insert ActiveX Document Object dialog.
You can create your ActiveX document object using a new document or a previously saved document. For this example, select the Create New option button and select Microsoft Word Document in the Object Type box. Note that if you do not have Microsoft Word installed on your computer, you can select any appropriate file type from this box. Finally, click the OK button to add the new document to your workbook.
How Do I Add a Previously Saved Object to a Workbook?
Previously saved ActiveX documents (e.g., STATISTICA Spreadsheets and Graphs, Excel spreadsheets, Word documents) are added to the tree via the Insert Workbook Item dialog. To display this dialog, select Insert from the Workbook menu. You can also right-click in the tree and select Insert from the workbook tree shortcut menu or press INSERT on your keyboard. You can add a variety of file types to a workbook, a feature that allows you to easily organize all of the files associated with a topic. As with all items you can add to a workbook, files can be inserted as a sibling or as a child to current workbook items.
Follow these steps to add a previously saved file as the next sibling to the first item in the current workbook:
Select the first item in the current workbook, and then display the Insert Workbook Item dialog by selecting Insert from the Workbook menu.
In the Item group, select the ActiveX Document Object option button, and in the Placement group, select the As next sibling option button. Click the OK button to display the Insert ActiveX Document Object dialog.
In the ActiveX Document Object dialog, select the Create from File option button and then click the Browse button to display the Browse dialog.
Use the Look in list box to locate the file you want to add. Double-click on the file to enter it in the File box on the Insert ActiveX Document Object dialog. Click the OK button to add the file to your workbook. Note that if you select a file type that is not supported by this feature, STATISTICA prompts you to select a different file.
How Do I Add the Current Item to a Workbook?
You can add any STATISTICA object to a workbook including graphs, reports, macros, and spreadsheets. The most direct way to add the current STATISTICA object (i.e., the document that currently has focus) to a workbook is to click the Add to Workbook toolbar button. A list of currently available workbooks is displayed, allowing you to select in which workbook to include the item.
You can also add the item to a New Workbook.
By default, the item is appended at the end of the workbook tree one level below the root node (i.e., it is not placed as a sibling to any existing items in the workbook). You can relocate the object using the workbook's extensive drag-and-drop facilities.
You can also add currently open STATISTICA documents to the workbook using the Insert command from either the Workbook menu or the workbook tree shortcut menu. Select Insert to display the Insert Workbook Item dialog, and then select STATISTICA Document in the Item group of the Insert Workbook Item dialog.
Click the OK button in the Insert Workbook Item dialog to display the Document type dialog.
In this dialog, select the Create from window option button and specify which document to add using the Window box. Click the OK button to add the selected document to your workbook. Note that if you want to add all open STATISTICA documents to your workbook, select the All Windows option button on the Insert Workbook Item dialog and then click the OK button.
You can also add currently open ActiveX documents (e.g., Word documents or Excel files) to your workbook using the Clipboard. To add an open Word document, select the entire document (or a portion of it), copy it to the Clipboard (press CTRL+C), and then paste the contents of the Clipboard into the workbook (press CTRL+V or select Paste from the Workbook menu). STATISTICA automatically creates the appropriate type of document in the workbook and includes the contents of the Clipboard in that document.
How Do I Add a Saved STATISTICA Document to a Workbook?
You can add a saved STATISTICA document to your workbook (e.g., a spreadsheet, graph, report, or macro) by selecting Insert from the Workbook menu or workbook tree shortcut menu.
For example, to add the Adstudy.sta sample datafile to the current workbook, open a workbook and click on any item in the workbook tree. Now, press the INSERT key on your keyboard to display the Insert Workbook Item dialog. (You could also select Insert from the Workbook menu or the workbook tree shortcut menu to display this dialog.)
In the Insert Workbook Item dialog, select the STATISTICA Document option button in the Item box and the As next sibling option button in the Placement box. Click the OK button to display the Document type dialog.
Select the Create from file option button in the Document type dialog, and then click the Browse button to display the Browse dialog.
Adstudy.sta is located in the Examples/Datasets subfolder of your STATISTICA installation folder. Use the Look in box to locate this file. Double-click on the file to enter it into the File box on the Document type dialog (as shown above). Click the OK button to add the file to your workbook.
How Do I Add a New STATISTICA Document to a Workbook?
In addition to adding current and previously saved STATISTICA documents to a workbook, you can also add new (blank) documents to a workbook, including spreadsheets, reports, and macros. When the new document is added, you must specify where to place the item in the workbook tree (either as a sibling to or as a child to another item in the workbook) and which type of item to create.
One way to add a new STATISTICA document is to determine an appropriate location in the workbook tree and right-click another item in that location. You can always move or copy the item to a new location later using drag-and-drop features, so the exact location is not critical.
From the workbook tree shortcut menu, select Insert to display the Insert Workbook Item dialog.
Select the STATISTICA Document option button in the Item group and the tree location (either As last child, As first child, As next sibling, or As prior sibling) option button in the Placement group. Click the OK button to display the Document type dialog.
Use this dialog to create a new document, locate a previously saved document, or select an open document. For this example, select the Select new option button and select a Spreadsheet, Report, or Macro in the Type box. Then, click the OK button to add the new document to your workbook.
How Do I Delete Items from a Workbook?
Commands for deleting workbook items are available from the Workbook menu, as well as from the workbook tree shortcut menu (accessed by right-clicking in the workbook tree). You can also delete an item by selecting it and pressing the DELETE key on your keyboard.
Note that when you delete an item that has children, all of its children will also be deleted.
How Do I Rename Workbook Items?
Commands for renaming workbook items are available from the Workbook menu as well as from the workbook tree shortcut menu (accessibly by right-clicking in the workbook tree). You can also select a workbook item and press F2.
Can I Rearrange the Workbook Tree with Drag-and-Drop?
Yes. The STATISTICA Workbook supports an entire range of drag-and-drop features within the workbook tree. By right-clicking on an item in the workbook tree, you can drag that item to a new location within the tree. In fact, since the drag-and-drop features support parent/child relationships, you can use these features to rearrange large portions of the workbook tree.
To select the parent node and all of its children, simply click on the parent node (or press CTRL while clicking on the parent node and each of its children). To make discontinuous selections (i.e., select some of the children, but not all of them), hold down the CTRL key while clicking on each item you want to select. You can also make discontinuous selections across nodes using the CTRL key.
Follow these steps to move a folder (and its contents) to a new location in the workbook tree:
1. Click on the folder to select it and all of its children.
2. Right-click on the folder, and drag the folder to a new location in the tree.
3. Release the right mouse button, and a shortcut menu is displayed, giving you options to either copy or move the dragged item. You can place the item before, after, or as a child to the newly selected item in the tree. For this example, select Move After from the shortcut menu.
How Do I Use Copy and Paste in a Workbook?
In addition to using drag-and-drop features to rearrange workbook items, you can use the Copy and Paste commands. Commands for cutting, copying, and pasting are available from the Workbook menu, the workbook tree shortcut menu, and the Standard toolbar.
Can I Select Discontinuous Items in the Workbook Tree?
You can select one or more items in the workbook tree using the standard Windows SHIFT+click and CTRL+click conventions to select ranges and discontinuous lists of variables, respectively. Additionally, you can select and deselect tree items using the keyboard navigation keys (e.g., HOME, END, PAGE UP, PAGE DOWN, and arrow keys). You can delete an entire selection by pressing the DELETE key. Press the INSERT key to display the Insert Workbook Item dialog for the currently selected item.
Note that to select discontinuous items of a particular node, you will need to expand the node (by clicking on the plus sign adjacent to the node).
Can I Print More Than One Item From a Workbook Without Printing the Entire Workbook?
Yes. When printing from within a workbook, only the currently displayed (active) item is printed when the Print button is clicked, but if the Print dialog is used, multiple selections from the workbook can be printed by using the Selection option on the Print dialog. Note that STATISTICA supports the standard Windows SHIFT+click and CTRL+click conventions to select ranges and discontinuous lists of items, respectively. Thus to print a range of graphs from a workbook, select the range of graphs, select Print from the File menu to display the Print dialog, select the Selection option button in that dialog, and click the OK button.
In the illustration shown above, the four selected graphs will be printed when the OK button is clicked on the Print dialog.
| Back to Top |
| Request Quote |
| StatSoft Home Page |
![[StatSoft]](../../images/sssmall.gif)
2300 East 14th Street, Tulsa, OK 74104
Phone: (918) 749-1119; Fax: (918) 749-2217
![[StatSoft]](../../images/emailed.gif){kind=small}
e-mail: info@statsoft.com
©Copyright StatSoft, Inc., 1984-2005.
StatSoft, StatSoft logo, STATISTICA, SEWSS, SEDAS, Data Miner, SEPATH and GTrees are trademarks of StatSoft, Inc.