DefaultSpreadsheetPanel (Snifflib API)

java.lang.Object
- java.awt.Component
- - java.awt.Container
  - - javax.swing.JComponent
    - - javax.swing.JPanel
      - com.mockturtlesolutions.snifflib.spreadsheets.DefaultSpreadsheetPanel

All Implemented Interfaces:

DOMStorable, RepositoryStorage, RepositoryStorageTransfer, MyrtleStorage, MyrtleSheetAPI, RangeGrabListener, SpreadsheetPanel, java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable, java.util.EventListener, javax.accessibility.Accessible, javax.swing.event.TableModelListener
```
public class DefaultSpreadsheetPanel
extends javax.swing.JPanel
implements MyrtleSheetAPI
```
Panel containing one or more DefaultSpreadsheetTable instances.

See Also:
Serialized Form

Nested Class Summary

Nested Classes
Modifier and Type	Class and Description
`class`	`DefaultSpreadsheetPanel.FillSelectionFrame`
`class`	`DefaultSpreadsheetPanel.GroovyFileFilter`
`protected class`	`DefaultSpreadsheetPanel.GroovyLibraryAction`
`protected class`	`DefaultSpreadsheetPanel.IMAGE_STACK`
`class`	`DefaultSpreadsheetPanel.ImportFileFilter`
`class`	`DefaultSpreadsheetPanel.JPGFileFilter`
`class`	`DefaultSpreadsheetPanel.LinkLabel`
`protected class`	`DefaultSpreadsheetPanel.LinksTextArea`
`class`	`DefaultSpreadsheetPanel.ManageSelectionBookmarksFrame`
`class`	`DefaultSpreadsheetPanel.NewBookmarkEntryFrame`
`class`	`DefaultSpreadsheetPanel.PNGFileFilter`
`protected class`	`DefaultSpreadsheetPanel.RegisterLinksTextFrame`
`protected class`	`DefaultSpreadsheetPanel.ReservedFunctionLibraryAction`
`class`	`DefaultSpreadsheetPanel.ScriptButton`
`class`	`DefaultSpreadsheetPanel.ScriptEditor`
`class`	`DefaultSpreadsheetPanel.ScriptHashSet`
`class`	`DefaultSpreadsheetPanel.SetOperationFrame`
`protected class`	`DefaultSpreadsheetPanel.SheetDescriptionTextArea`
`protected class`	`DefaultSpreadsheetPanel.SheetDescriptionTextFrame`
`class`	`DefaultSpreadsheetPanel.SortRangeFrame`
`protected class`	`DefaultSpreadsheetPanel.SpreadsheetScrollPane`
`class`	`DefaultSpreadsheetPanel.SubsetMarksCategoryModel`

Nested classes/interfaces inherited from class javax.swing.JPanel
javax.swing.JPanel.AccessibleJPanel

Nested classes/interfaces inherited from class javax.swing.JComponent
javax.swing.JComponent.AccessibleJComponent

Nested classes/interfaces inherited from class java.awt.Container
java.awt.Container.AccessibleAWTContainer

Nested classes/interfaces inherited from class java.awt.Component
java.awt.Component.AccessibleAWTComponent, java.awt.Component.BaselineResizeBehavior, java.awt.Component.BltBufferStrategy, java.awt.Component.FlipBufferStrategy

Field Summary

Fields
Modifier and Type Field and Description

protected MyrtleConnectivity Connection
- Fields inherited from class javax.swing.JComponent
  accessibleContext, listenerList, TOOL_TIP_TEXT_KEY, ui, UNDEFINED_CONDITION, WHEN_ANCESTOR_OF_FOCUSED_COMPONENT, WHEN_FOCUSED, WHEN_IN_FOCUSED_WINDOW
- Fields inherited from class java.awt.Component
  BOTTOM_ALIGNMENT, CENTER_ALIGNMENT, LEFT_ALIGNMENT, RIGHT_ALIGNMENT, TOP_ALIGNMENT
- Fields inherited from interface java.awt.image.ImageObserver
  ABORT, ALLBITS, ERROR, FRAMEBITS, HEIGHT, PROPERTIES, SOMEBITS, WIDTH

Fields
Modifier and Type	Field and Description
`protected MyrtleConnectivity`	`Connection`

Constructor Summary

Constructors
Constructor and Description

DefaultSpreadsheetPanel()

Constructors
Constructor and Description
`DefaultSpreadsheetPanel()`

Method Summary

Methods
Modifier and Type	Method and Description
`void`	`addBookmark(java.lang.String bmname, java.lang.String range)`
`void`	`addBookmark(java.lang.String bmname, java.lang.String range, boolean yestoall)`
`void`	`addBookmark(java.lang.String gory, java.lang.String bmname, java.lang.String range)` Adds a bookmark for the given range under the named bookmark category folder.
`void`	`addBookmark(java.lang.String gory, java.lang.String bmname, java.lang.String range, boolean yestoall)` Adds a bookmark for the given range under the named bookmark category folder.
`void`	`addBookmarkFolder(java.lang.String cat)`
`void`	`addNewProcedure()`
`void`	`addNewProcedure(int pos)`
`void`	`addNewUndoEvent(SpreadsheetUndoEvent undoevt)`
`void`	`addProc(SpreadsheetProcedure newScript)` Adds the given procedure and docks it into the scripting frame.
`void`	`addRangeGrabListener(RangeGrabListener l)` Adds a listener for changes in the selected (highlighted) ranges within a spreadsheet.
`void`	`addRegisteredLink(java.lang.String linklabel, java.lang.String linkurl)`
`void`	`addRepositoryListener(RepositoryListener listen)`
`void`	`addScriptAt(int pos)`
`void`	`addSelectionBookmark()` Allows a user to interactively add a new bookmark.
`void`	`addSheet(java.lang.String title)`
`DefaultSpreadsheetTable`	`addSheetAfter()` Adds a new sheet positioned subsequent to the current one.
`void`	`addSheetAfterCopyAll()` Adds a new sheet after the current one and copies the current sheet's contents to that one.
`DefaultSpreadsheetTable`	`addSheetBefore()` Adds and returns a new sheet positioned before the currently selected sheet.
`void`	`addSheetBeforeCopyAll()` Adds a new sheet before the current one and copies the current sheet's contents to that one.
`DefaultSpreadsheetTable`	`addSheetNoSideEffects(int j, java.lang.String title)`
`void`	`addSpreadsheetPanelListener(SpreadsheetPanelListener l)` Adds the given SpreadsheetPanelListener.
`void`	`afterCopyStorage()`
`void`	`afterTransferStorage()`
`void`	`applyPreferences(SpreadsheetPreferences prefs)`
`void`	`archiveSelectedProcs()`
`void`	`beforeCopyStorage()`
`void`	`beforeTransferStorage()`
`void`	`browseSelectedLinks()`
`void`	`copyAllToClipboard()` Selects and then copies all of the contents of the current sheet to the clipboard.
`void`	`copySelectedToClipboard()` Copies the contents of the current sheet's selected range to the clipboard.
`void`	`copyStorage(RepositoryStorage x)`
`void`	`copyStorageCommands(RepositoryStorage x)`
`SpreadsheetTable`	`createNewSheet()` Creates a new sheet as a SpreadsheetTable.
`void`	`csvExportOneFilePerSheet()` Exports each sheet as a separate CSV file.
`void`	`csvExportSheet()` Exports the current sheet as a CSV file.
`void`	`deleteCurrentSheet()` Deletes the currently selected sheet.
`void`	`deleteSelectedProcs()` Deletes the currently selected procedures from the scripting frame.
`DefaultSpreadsheetTable`	`deleteSheetNoSideEffects(int j)`
`java.util.LinkedHashMap`	`dummyCoding(java.lang.String a)`
`void`	`editPreferences()`
`void`	`editSelectedLinkLabels()` Edits/Browses the selected registered links.
`void`	`editSelectedScripts()` Edits/Browses the selected procedures.
`java.lang.Object`	`evalFunction(java.lang.String fun, java.lang.Object[] args, DefaultSpreadsheetPanel p, DefaultSpreadsheetTable t)`
`void`	`evaluateSelectedProcedures()` Evaluates the currently selected procedures in the scripting frame.
`void`	`exitAll()` Exits the entire project.
`void`	`fillRange(DefaultSpreadsheetTable tabl, java.lang.String range, java.lang.String startValue, java.lang.String stopValue)` Fills the indicated range in the indicated table.
`void`	`fillRange(java.lang.String range, java.lang.String startValue, java.lang.String stopValue)` Fills the indicated range in the currently selected table.
`void`	`fillSelection()`
`protected java.awt.Frame`	`findActiveFrame()`
`void`	`fireSpreadsheetPanelChange(SpreadsheetPanelEvent ev)` Inform all SpreadsheetPanelListeners that a change has occured.
`protected ReservedFunction`	`get_function(java.lang.String cobj)`
`java.util.LinkedHashMap`	`getAllBookmarks()`
`java.util.Vector`	`getAllEntries(java.lang.String title)` Gets all the entries for a particular sheet.
`java.lang.String[]`	`getAllRanges(java.lang.String sarg)`
`java.util.Vector`	`getAllRegisteredLinks()`
`BernoulliDistribution`	`getBernoulliDistribution()`
`BinomialDistribution`	`getBinomialDistribution()`
`java.lang.String`	`getBookmarkForRange(java.lang.String range)` Returns a bookmark name if one exists for the given range.
`ChiSqDistribution`	`getChiSqDistribution()`
`int`	`getColumnCountForSheet(java.lang.String title)`
`java.lang.String`	`getComment()` Gets the descriptive comment for this Wedge inverse problem as a whole.
`java.lang.String`	`getCreatedBy()`
`java.lang.String`	`getCreatedOn()`
`java.lang.String`	`getCurrentPreferenceSet()`
`DefaultSpreadsheetTable`	`getCurrentSheet()`
`java.lang.String`	`getCurrentSheetTitle()` Gets the currently selected sheet's title.
`DblMatrix`	`getDblMatrixFor(java.lang.String range)` Extracts a range of sheet cells' values interpreted as double's.
`DblMatrix`	`getDblMatrixForBookmark(java.lang.String mark)` Extracts a range of sheet cells' values interpreted as double's.
`DblMatrix`	`getDblMatrixForRange(java.lang.String range)` Extracts a range of sheet cells' values interpreted as double's.
`java.lang.Class`	`getDefaultGraphicalEditorClass()`
`java.lang.String`	`getDefaultOutputDirectory()`
`DiscreteUniformDistribution`	`getDiscreteUniformDistribution()`
`java.lang.Class`	`getDOMStorageClass()`
`java.lang.String`	`getEnabled()` Gets the state of the (possibly remote) storage.
`java.lang.String`	`getEntryFunctionAt(java.lang.String title, int row, int col)`
`java.lang.String`	`getEntryValueAt(java.lang.String title, int row, int col)`
`FDistribution`	`getFDistribution()`
`GammaDistribution`	`getGammaDistribution()`
`java.util.HashMap`	`getGetFunctionLibrary()` Returns the current reserved function library as a HashMap.
`GroovyScriptReservedFunction`	`getGroovyScriptReservedFunctionFor(java.lang.String cobj, DefaultSpreadsheetPanel parentPanel, DefaultSpreadsheetTable parentTable, DefaultSpreadsheetEntry entry)` Returns a reserved function having the indicated name and associates it with the indicated panel, table, and spreadsheet cell.
`HypergeometricDistribution`	`getHypergeometricDistribution()`
`java.lang.String`	`getNickname()` Gets the project name for this Wedge inverse problem.
`NormalDistribution`	`getNormalDistribution()`
`int`	`getPersistentSheetCounter()`
`PoissonDistribution`	`getPoissonDistribution()`
`MyrtlePrefs`	`getPreferences()`
`java.lang.String`	`getPreferenceValue(java.lang.String str)`
`java.lang.String`	`getPrintExportFormat()` Gets the user's preferred print/export format.
`java.lang.String`	`getPrintProcExportFormat()`
`java.lang.String`	`getRangeForBookmark(java.lang.String mark)` Returns the spreadsheet cell range having the given bookmark.
`int`	`getRowCountForSheet(java.lang.String title)`
`java.lang.String`	`getScriptContents(int pos)`
`int`	`getScriptCount()`
`java.lang.String`	`getScriptLabel(int pos)`
`DefaultSpreadsheetPanel.LinkLabel`	`getSelectedLink()`
`DefaultSpreadsheetPanel.LinkLabel`	`getSelectedRegisteredLink()` Returns the first selected registered link (image).
`java.util.Vector`	`getSelectedRegisteredLinks()`
`SpreadsheetTable`	`getSheet(java.lang.String title)` Returns the named sheet as a SpreadsheetTable.
`SpreadsheetTable`	`getSheetAt(int j)` Returns the sheet at the given index as a SpreadsheetTable.
`java.lang.String`	`getSheetComment(int sheet)` Returns the description for the named spreadsheet.
`int`	`getSheetCount()` Returns the total number of sheets.
`java.lang.String`	`getSheetDescription(java.lang.String title)`
`java.lang.String`	`getSheetLabel(int sht)`
`java.lang.Class`	`getStorageTransferAgentClass()`
`TDistribution`	`getTDistribution()`
`java.lang.String`	`getTimeStamp()`
`java.lang.String`	`getTitleOfTable(DefaultSpreadsheetTable t)` Returns the title of the current sheet.
`UniformDistribution`	`getUniformDistribution()`
`void`	`goToFirstSheet()`
`void`	`goToNextSheet()` Makes the subsequent sheet the current one.
`void`	`goToPreviousSheet()` Makes the previous sheet the current one.
`void`	`goToSheet()` Allows user to interactively select a sheet and make it current.
`void`	`goToSheet(java.lang.String title)` Makes the names sheet current.
`void`	`htmlExportOneFilePerSheet()` Exports each sheet as a separate HTML web page.
`void`	`htmlExportOneFilePerSheetMerged()` Exports each sheet as a single merged HTML web page.
`void`	`htmlExportSheet()` Exports the current sheet as a HTML web page.
`void`	`importCSVFile(java.io.File csvfile)` Imports the named CSV file.
`void`	`importProc()` Imports and docks a new script interactively into the scripting frame.
`void`	`importProc(java.net.URL url)` Imports and docks a new script at the given URL into the scripting frame.
`void`	`importSheets()` Allows user to interactively import spreadsheets (e.g.
`void`	`intersect()`
`void`	`intersect(java.lang.String a, java.lang.String b, java.lang.String dest)`
`void`	`jpgExportLink()`
`void`	`jpgExportLink(DefaultSpreadsheetPanel.LinkLabel l)`
`void`	`jpgExportOneFilePerLink()`
`void`	`latexExportOneFilePerSheet()` Exports each sheet as a single merged LaTeX document.
`void`	`latexExportOneFilePerSheetMerged()` Exports each sheet as a separate LaTeX document.
`void`	`linkFigureAsPNG(SLFigure fig, java.lang.String label)`
`void`	`linkFigureAsPNG(SLFigure fig, java.lang.String label, java.lang.String fname)`
`Script`	`loadArchivedProcedure(java.lang.String nn)` Loads an existing script storage by nickname.
`void`	`manageSelectionBookmarks()` Allows a user to interactively manage their bookmarks.
`java.lang.String`	`nameOf(java.lang.String range)` Returns the name (if any) of the first bookmark having the indicated spreadsheet cell range.
`void`	`openProject()`
`DblMatrix`	`parseDblMatrix(java.lang.Object arg0)`
`java.lang.String[][]`	`parseStringMatrix(java.lang.Object arg0)`
`void`	`pasteClipboardAt(int r, int c)` Pastes the contents of the clipboard beginning at the indicated row and column of the current sheet.
`void`	`pasteDblMatrixAt(DblMatrix X, int startrow, int startcol)`
`void`	`pasteDblMatrixAt(DefaultSpreadsheetTable tabl, DblMatrix X, int startrow, int startcol)`
`void`	`pasteMatrixAt(SpreadsheetEntryMatrix pastesrc, int startrow, int startcol)`
`void`	`pngExportLink()`
`void`	`pngExportLink(DefaultSpreadsheetPanel.LinkLabel l)`
`void`	`pngExportOneFilePerLink()`
`void`	`printJPG(java.io.File jpgfile)`
`void`	`printLink()`
`void`	`printLink(DefaultSpreadsheetPanel.LinkLabel l, boolean interactive)`
`void`	`printOneFilePerLink()`
`void`	`printOneFilePerSheet()` Prints separately for each sheet.
`void`	`printSheet()` Prints the currently selected sheet.
`void`	`rangeGrabAction(RangeGrabEvent e)` Executes and updates for the given RangeGrabEvent.
`java.lang.String`	`rangeOf(java.lang.String mark)` Returns the spreadsheet cell range having the given bookmark.
`void`	`redo()`
`void`	`refreshLink(java.lang.String x)` Updates the images or files for the named registered links.
`void`	`refreshLink(java.net.URL x)` Updates the images or files for links whose URL is given.
`void`	`refreshListeners()`
`void`	`refreshSelectedLinks()` Updates the images or files for all selected registered links.
`void`	`registerFigure(java.lang.String label, SLFigure x)`
`void`	`registerLink(java.lang.String link)` Registers the named link into the results frame.
`void`	`registerLink(java.lang.String label, java.lang.String linkin)`
`void`	`registerLinks(java.lang.String linksList)` Registster a newline-delimited list of links.
`void`	`removeAllBookmarks()`
`void`	`removeAllRegisteredLinks()`
`void`	`removeAllScripts()`
`void`	`removeAllSheets()`
`void`	`removeRangeGrabListener(RangeGrabListener l)` Removes a listener for changes in the selected (highlighted) ranges within a spreadsheet.
`void`	`removeRepositoryListener(RepositoryListener listen)`
`void`	`removeScriptAt(int pos)`
`void`	`removeSheet(java.lang.String title)`
`void`	`removeSpreadsheetPanelListener(SpreadsheetPanelListener l)` Removes the given SpreadsheetPanelListener.
`void`	`saveOneFilePerProc()` Saves/exports each procedure to a file.
`void`	`saveProcAs()` Allows user to saves the selected procedures interactively.
`void`	`saveProcAs(SpreadsheetProcedure selected, java.io.File fid)` Saves the indicated procedure to the given file.
`void`	`saveProject()`
`void`	`selectAll()` Selects all of the contents of the current sheet.
`void`	`selectAllProcs()` Selects all of the procedurs that are currently docked into the scripting frame.
`void`	`setColumnCountForSheet(java.lang.String title, int cols)`
`void`	`setComment(java.lang.String com)`
`void`	`setCreatedBy(java.lang.String com)`
`void`	`setCreatedOn(java.lang.String com)`
`void`	`setCurrentPreferenceSet(java.lang.String set)`
`void`	`setdiff()`
`void`	`setdiff(java.lang.String a, java.lang.String b, java.lang.String dest)` Returns values in first argument that are not in the second argument.
`void`	`setEnabled(java.lang.String s)` Sets the enabled state of the (possibly remote) storage instance.
`void`	`setEntryFunctionAt(java.lang.String title, int row, int col, java.lang.String strrep)`
`void`	`setEntryValueAt(java.lang.String title, int row, int col, java.lang.String strval)`
`void`	`setMask()`
`void`	`setMask(java.lang.String a, java.lang.String b, java.lang.String dest)` Returns values in first argument where the values in the second argument equal 1.0.
`void`	`setMaskColumns()`
`void`	`setMaskColumns(java.lang.String a, java.lang.String b, java.lang.String dest)` Returns columns of the region in the first argument where the values in the second argument equal 1.0.
`void`	`setMaskRows()`
`void`	`setMaskRows(java.lang.String a, java.lang.String b, java.lang.String dest)` Returns rows of the region in the first argument where the values in the second argument equal 1.0.
`void`	`setNickname(java.lang.String s)` Sets the project name for this Wedge inverse problem.
`void`	`setPersistentSheetCounter(int shts)`
`void`	`setRowCountForSheet(java.lang.String title, int rows)`
`void`	`setScriptContents(int pos, java.lang.String s)`
`void`	`setScriptLabel(int pos, java.lang.String s)`
`void`	`setSheetComment(int sheet, java.lang.String com)` Sets the description for the named spreadsheet.
`void`	`setSheetDescription(java.lang.String title, java.lang.String desc)`
`void`	`showMessageDialog(java.lang.String s)` Shows a message to the user.
`void`	`showProcedureStackTrace(java.lang.String script, java.lang.Throwable e)` Allows user to view and debug failed scripts by showing the stack trace which lead up to the script failing.
`void`	`showStackTrace(java.lang.Throwable e)` Allows user to view and debug by showing the stack trace.
`void`	`sortRange()`
`protected static java.lang.String`	`stack2string(java.lang.Throwable e)`
`void`	`tableChanged(javax.swing.event.TableModelEvent ev)` This method get's called if any of the table's entries are modified...
`void`	`transferStorage(RepositoryStorage that)`
`void`	`transferStorageCommands(RepositoryStorage x)`
`void`	`undo()`
`void`	`union()`
`void`	`union(java.lang.String a, java.lang.String b, java.lang.String dest)`
`java.util.Vector`	`uniqueValues(java.lang.String a)`
`boolean`	`unRegisterLink(DefaultSpreadsheetPanel.LinkLabel x)`
`boolean`	`unRegisterLink(java.lang.String x)` Unregisters the named registered links (image or file) from the results frame.
`boolean`	`unRegisterLink(java.net.URL x)` Unregisters the registered links (image or file) whose URL is given.
`void`	`unRegisterSelectedLinks()` Unregisters all selected registered links (image or file) from the results frame.

Methods inherited from class javax.swing.JPanel
getAccessibleContext, getUI, getUIClassID, paramString, setUI, updateUI

Methods inherited from class javax.swing.JComponent
addAncestorListener, addNotify, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, fireVetoableChange, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBaseline, getBaselineResizeBehavior, getBorder, getBounds, getClientProperty, getComponentGraphics, getComponentPopupMenu, getConditionForKeyStroke, getDebugGraphicsOptions, getDefaultLocale, getFontMetrics, getGraphics, getHeight, getInheritsPopupMenu, getInputMap, getInputMap, getInputVerifier, getInsets, getInsets, getListeners, getLocation, getMaximumSize, getMinimumSize, getNextFocusableComponent, getPopupLocation, getPreferredSize, getRegisteredKeyStrokes, getRootPane, getSize, getToolTipLocation, getToolTipText, getToolTipText, getTopLevelAncestor, getTransferHandler, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingOrigin, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintBorder, paintChildren, paintComponent, paintImmediately, paintImmediately, print, printAll, printBorder, printChildren, printComponent, processComponentKeyEvent, processKeyBinding, processKeyEvent, processMouseEvent, processMouseMotionEvent, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeNotify, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, requestFocusInWindow, requestFocusInWindow, resetKeyboardActions, reshape, revalidate, scrollRectToVisible, setActionMap, setAlignmentX, setAlignmentY, setAutoscrolls, setBackground, setBorder, setComponentPopupMenu, setDebugGraphicsOptions, setDefaultLocale, setDoubleBuffered, setEnabled, setFocusTraversalKeys, setFont, setForeground, setInheritsPopupMenu, setInputMap, setInputVerifier, setMaximumSize, setMinimumSize, setNextFocusableComponent, setOpaque, setPreferredSize, setRequestFocusEnabled, setToolTipText, setTransferHandler, setUI, setVerifyInputWhenFocusTarget, setVisible, unregisterKeyboardAction, update

Methods inherited from class java.awt.Container
add, add, add, add, add, addContainerListener, addImpl, addPropertyChangeListener, addPropertyChangeListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, doLayout, findComponentAt, findComponentAt, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getComponentZOrder, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, getMousePosition, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicyProvider, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, processContainerEvent, processEvent, remove, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusCycleRoot, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setLayout, transferFocusDownCycle, validate, validateTree

Methods inherited from class java.awt.Component
action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, bounds, checkImage, checkImage, coalesceEvents, contains, createImage, createImage, createVolatileImage, createVolatileImage, disableEvents, dispatchEvent, enable, enableEvents, enableInputMethods, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, firePropertyChange, getBackground, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getForeground, getGraphicsConfiguration, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMousePosition, getMouseWheelListeners, getName, getParent, getPeer, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getToolkit, getTreeLock, gotFocus, handleEvent, hasFocus, hide, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isEnabled, isFocusable, isFocusOwner, isFocusTraversable, isFontSet, isForegroundSet, isLightweight, isMaximumSizeSet, isMinimumSizeSet, isPreferredSizeSet, isShowing, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, postEvent, prepareImage, prepareImage, processComponentEvent, processFocusEvent, processHierarchyBoundsEvent, processHierarchyEvent, processInputMethodEvent, processMouseWheelEvent, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, resize, resize, setBounds, setBounds, setComponentOrientation, setCursor, setDropTarget, setFocusable, setFocusTraversalKeysEnabled, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, show, show, size, toString, transferFocus, transferFocusBackward, transferFocusUpCycle

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - Connection
```
protected MyrtleConnectivity Connection
```
- Constructor Detail
  - DefaultSpreadsheetPanel
```
public DefaultSpreadsheetPanel()
```
- Method Detail
  - browseSelectedLinks
```
public void browseSelectedLinks()
```
  - get_function
```
protected ReservedFunction get_function(java.lang.String cobj)
```
  - setCurrentPreferenceSet
```
public void setCurrentPreferenceSet(java.lang.String set)
```
  - getCurrentPreferenceSet
```
public java.lang.String getCurrentPreferenceSet()
```
  - applyPreferences
```
public void applyPreferences(SpreadsheetPreferences prefs)
```
  - editPreferences
```
public void editPreferences()
```
  - evalFunction
```
public java.lang.Object evalFunction(java.lang.String fun,
                            java.lang.Object[] args,
                            DefaultSpreadsheetPanel p,
                            DefaultSpreadsheetTable t)
```
  - addNewProcedure
```
public void addNewProcedure()
```
  - addNewProcedure
```
public void addNewProcedure(int pos)
```
  - evaluateSelectedProcedures
```
public void evaluateSelectedProcedures()
```
    Description copied from interface: MyrtleSheetAPI
    
    Evaluates the currently selected procedures in the scripting frame.
    
    Specified by:
    
    evaluateSelectedProcedures in interface MyrtleSheetAPI
  - linkFigureAsPNG
```
public void linkFigureAsPNG(SLFigure fig,
                   java.lang.String label)
```
  - linkFigureAsPNG
```
public void linkFigureAsPNG(SLFigure fig,
                   java.lang.String label,
                   java.lang.String fname)
```
  - getTimeStamp
```
public java.lang.String getTimeStamp()
```
  - getDefaultOutputDirectory
```
public java.lang.String getDefaultOutputDirectory()
```
  - getPreferenceValue
```
public java.lang.String getPreferenceValue(java.lang.String str)
```
  - getPreferences
```
public MyrtlePrefs getPreferences()
```
  - addSelectionBookmark
```
public void addSelectionBookmark()
```
    Description copied from interface: MyrtleSheetAPI
    
    Allows a user to interactively add a new bookmark.
    
    Specified by:
    
    addSelectionBookmark in interface MyrtleSheetAPI
  - fillSelection
```
public void fillSelection()
```
  - sortRange
```
public void sortRange()
```
  - manageSelectionBookmarks
```
public void manageSelectionBookmarks()
```
    Description copied from interface: MyrtleSheetAPI
    
    Allows a user to interactively manage their bookmarks.
    
    Specified by:
    
    manageSelectionBookmarks in interface MyrtleSheetAPI
  - getNormalDistribution
```
public NormalDistribution getNormalDistribution()
```
  - getFDistribution
```
public FDistribution getFDistribution()
```
  - getDiscreteUniformDistribution
```
public DiscreteUniformDistribution getDiscreteUniformDistribution()
```
  - getBernoulliDistribution
```
public BernoulliDistribution getBernoulliDistribution()
```
  - getPoissonDistribution
```
public PoissonDistribution getPoissonDistribution()
```
  - getUniformDistribution
```
public UniformDistribution getUniformDistribution()
```
  - getGammaDistribution
```
public GammaDistribution getGammaDistribution()
```
  - getHypergeometricDistribution
```
public HypergeometricDistribution getHypergeometricDistribution()
```
  - getTDistribution
```
public TDistribution getTDistribution()
```
  - getChiSqDistribution
```
public ChiSqDistribution getChiSqDistribution()
```
  - getBinomialDistribution
```
public BinomialDistribution getBinomialDistribution()
```
  - getGetFunctionLibrary
```
public java.util.HashMap getGetFunctionLibrary()
```
    Description copied from interface: MyrtleSheetAPI
    
    Returns the current reserved function library as a HashMap. The keys of the HashMap are common names of the functions.
    
    Specified by:
    
    getGetFunctionLibrary in interface MyrtleSheetAPI
  - addRangeGrabListener
```
public void addRangeGrabListener(RangeGrabListener l)
```
    Description copied from interface: MyrtleSheetAPI
    
    Adds a listener for changes in the selected (highlighted) ranges within a spreadsheet.
    
    Specified by:
    
    addRangeGrabListener in interface MyrtleSheetAPI
  - removeRangeGrabListener
```
public void removeRangeGrabListener(RangeGrabListener l)
```
    Description copied from interface: MyrtleSheetAPI
    
    Removes a listener for changes in the selected (highlighted) ranges within a spreadsheet.
    
    Specified by:
    
    removeRangeGrabListener in interface MyrtleSheetAPI
  - deleteSelectedProcs
```
public void deleteSelectedProcs()
```
    Description copied from interface: MyrtleSheetAPI
    
    Deletes the currently selected procedures from the scripting frame.
    
    Specified by:
    
    deleteSelectedProcs in interface MyrtleSheetAPI
  - refreshListeners
```
public void refreshListeners()
```
  - archiveSelectedProcs
```
public void archiveSelectedProcs()
```
  - addBookmark
```
public void addBookmark(java.lang.String bmname,
               java.lang.String range,
               boolean yestoall)
```
  - addBookmark
```
public void addBookmark(java.lang.String bmname,
               java.lang.String range)
```
  - addBookmark
```
public void addBookmark(java.lang.String gory,
               java.lang.String bmname,
               java.lang.String range,
               boolean yestoall)
```
    Adds a bookmark for the given range under the named bookmark category folder. Note: If the bookmark category is null then the default (General) category will be assumed. If the bookmark category does not already exist, it will be created. If the yestoall flag is set then the bookmark is created without prompting user for confirmation.
  - loadArchivedProcedure
```
public Script loadArchivedProcedure(java.lang.String nn)
```
    Description copied from interface: MyrtleSheetAPI
    
    Loads an existing script storage by nickname. Example: String proc = "com.mockturtlesolutions.LinearRegression"; Script script = ParentPanel.loadArchivedProcedure(proc);
    
    Specified by:
    
    loadArchivedProcedure in interface MyrtleSheetAPI
  - addBookmark
```
public void addBookmark(java.lang.String gory,
               java.lang.String bmname,
               java.lang.String range)
```
    Adds a bookmark for the given range under the named bookmark category folder. Note: If the bookmark category is null then the default (General) category will be assumed. If the bookmark category does not already exist, it will be created.
    
    Specified by:
    
    addBookmark in interface MyrtleStorage
    
    Specified by:
    
    addBookmark in interface MyrtleSheetAPI
  - pasteDblMatrixAt
```
public void pasteDblMatrixAt(DblMatrix X,
                    int startrow,
                    int startcol)
```
  - pasteDblMatrixAt
```
public void pasteDblMatrixAt(DefaultSpreadsheetTable tabl,
                    DblMatrix X,
                    int startrow,
                    int startcol)
```
  - fillRange
```
public void fillRange(java.lang.String range,
             java.lang.String startValue,
             java.lang.String stopValue)
```
    Description copied from interface: MyrtleSheetAPI
    
    Fills the indicated range in the currently selected table. This convenience method fills the indicated range (e.g. "A1:B10") from a starting value (e.g. "0.231") to a stopping value (e.g. "100.021"). The number of steps incrementing between the start and stop values is equal to the number of elements in the range. Note: If the range has a sheet designation in it (e.g. "Sheet9!A1:B10") then that sheet will be filled instead of the currently selected one. Example: fillRange("A1:B10","1","10");
    
    Specified by:
    
    fillRange in interface MyrtleSheetAPI
  - fillRange
```
public void fillRange(DefaultSpreadsheetTable tabl,
             java.lang.String range,
             java.lang.String startValue,
             java.lang.String stopValue)
```
    Description copied from interface: MyrtleSheetAPI
    
    Fills the indicated range in the indicated table. Fills the indicated range (e.g. "A1:A10") of the table from a starting value (e.g. "0.231") to a stopping value (e.g. "100.021"). The number of steps incrementing between the start and stop values is equal to the number of elements in the range. Note: If the range has a sheet designation in it (e.g. "Sheet9!A1:B10") then that sheet will be filled instead of the one indicated. Example: fillRange(table,"A1:B10","1","10");
    
    Specified by:
    
    fillRange in interface MyrtleSheetAPI
  - saveProject
```
public void saveProject()
```
  - refreshLink
```
public void refreshLink(java.lang.String x)
```
    Description copied from interface: MyrtleSheetAPI
    
    Updates the images or files for the named registered links. This can be useful if, for example, the image may have been altered by a third party and the user would like to update to those changes.
    
    Specified by:
    
    refreshLink in interface MyrtleSheetAPI
  - refreshSelectedLinks
```
public void refreshSelectedLinks()
```
    Description copied from interface: MyrtleSheetAPI
    
    Updates the images or files for all selected registered links. This can be useful if, for example, the image may have been altered by a third party and the user would like to update to those changes.
    
    Specified by:
    
    refreshSelectedLinks in interface MyrtleSheetAPI
  - refreshLink
```
public void refreshLink(java.net.URL x)
```
    Description copied from interface: MyrtleSheetAPI
    
    Updates the images or files for links whose URL is given. This can be useful if, for example, the image may have been altered by a third party and the user would like to update to those changes.
    
    Specified by:
    
    refreshLink in interface MyrtleSheetAPI
  - getDblMatrixForRange
```
public DblMatrix getDblMatrixForRange(java.lang.String range)
```
    Description copied from interface: MyrtleSheetAPI
    
    Extracts a range of sheet cells' values interpreted as double's. If the value can not be parsed as a double then the result will be an NaN. Note that this method requires that the input String be a cell reference range.
    
    Specified by:
    
    getDblMatrixForRange in interface MyrtleSheetAPI
    
    See Also:
    MyrtleSheetAPI.getDblMatrixFor(String str), MyrtleSheetAPI.getDblMatrixForBookmark(String str)
  - getDblMatrixFor
```
public DblMatrix getDblMatrixFor(java.lang.String range)
```
    Description copied from interface: MyrtleSheetAPI
    
    Extracts a range of sheet cells' values interpreted as double's. If the value can not be parsed as a double then the result will be an NaN. Note that this is a convenience method which first determines whether the input String represents a bookmarked range or a cell referenced range and then calls the appropriate method.
    
    Specified by:
    
    getDblMatrixFor in interface MyrtleSheetAPI
    
    See Also:
    MyrtleSheetAPI.getDblMatrixForRange(String str), MyrtleSheetAPI.getDblMatrixForBookmark(String str)
  - getDblMatrixForBookmark
```
public DblMatrix getDblMatrixForBookmark(java.lang.String mark)
```
    Description copied from interface: MyrtleSheetAPI
    
    Extracts a range of sheet cells' values interpreted as double's. If the value can not be parsed as a double then the result will be an NaN. Note that this method requires that the input String be a bookmark reference and so should start with the "#" character.
    
    Specified by:
    
    getDblMatrixForBookmark in interface MyrtleSheetAPI
    
    See Also:
    MyrtleSheetAPI.getDblMatrixFor(String str), MyrtleSheetAPI.getDblMatrixForRange(String str)
  - getBookmarkForRange
```
public java.lang.String getBookmarkForRange(java.lang.String range)
```
    Returns a bookmark name if one exists for the given range. Note that results may not be unique if more than one bookmark exist for the same range.
    
    Specified by:
    
    getBookmarkForRange in interface MyrtleSheetAPI
  - getRangeForBookmark
```
public java.lang.String getRangeForBookmark(java.lang.String mark)
```
    Returns the spreadsheet cell range having the given bookmark. Note that results may not be unique if a bookmark with the same name exists in separate bookmark categories.
    
    Specified by:
    
    getRangeForBookmark in interface MyrtleSheetAPI
  - rangeOf
```
public java.lang.String rangeOf(java.lang.String mark)
```
    Returns the spreadsheet cell range having the given bookmark. Note that results may not be unique if a bookmark with the same name exists in separate bookmark categories.
  - getAllRanges
```
public java.lang.String[] getAllRanges(java.lang.String sarg)
```
  - nameOf
```
public java.lang.String nameOf(java.lang.String range)
```
    Returns the name (if any) of the first bookmark having the indicated spreadsheet cell range. Note that it is not guaranteed that mark = nameOf(rangeOf(mark)) since the same range can be referenced by multiple bookmarks. Equality is also not met, of course, if no bookmark by that name exists.
    
    See Also:
    rangeOf(String mark)
  - unRegisterLink
```
public boolean unRegisterLink(java.lang.String x)
```
    Description copied from interface: MyrtleSheetAPI
    
    Unregisters the named registered links (image or file) from the results frame.
    
    Specified by:
    
    unRegisterLink in interface MyrtleSheetAPI
  - unRegisterSelectedLinks
```
public void unRegisterSelectedLinks()
```
    Description copied from interface: MyrtleSheetAPI
    
    Unregisters all selected registered links (image or file) from the results frame.
    
    Specified by:
    
    unRegisterSelectedLinks in interface MyrtleSheetAPI
  - unRegisterLink
```
public boolean unRegisterLink(DefaultSpreadsheetPanel.LinkLabel x)
```
  - unRegisterLink
```
public boolean unRegisterLink(java.net.URL x)
```
    Description copied from interface: MyrtleSheetAPI
    
    Unregisters the registered links (image or file) whose URL is given.
    
    Specified by:
    
    unRegisterLink in interface MyrtleSheetAPI
  - registerFigure
```
public void registerFigure(java.lang.String label,
                  SLFigure x)
```
  - registerLink
```
public void registerLink(java.lang.String label,
                java.lang.String linkin)
```
  - registerLink
```
public void registerLink(java.lang.String link)
```
    Description copied from interface: MyrtleSheetAPI
    
    Registers the named link into the results frame.
    
    Specified by:
    
    registerLink in interface MyrtleSheetAPI
  - registerLinks
```
public void registerLinks(java.lang.String linksList)
```
    Registster a newline-delimited list of links.
    
    Specified by:
    
    registerLinks in interface MyrtleSheetAPI
  - getSelectedLink
```
public DefaultSpreadsheetPanel.LinkLabel getSelectedLink()
```
  - setSheetComment
```
public void setSheetComment(int sheet,
                   java.lang.String com)
```
    Description copied from interface: MyrtleSheetAPI
    
    Sets the description for the named spreadsheet.
    
    Specified by:
    
    setSheetComment in interface MyrtleSheetAPI
  - getSheetComment
```
public java.lang.String getSheetComment(int sheet)
```
    Description copied from interface: MyrtleSheetAPI
    
    Returns the description for the named spreadsheet.
    
    Specified by:
    
    getSheetComment in interface MyrtleSheetAPI
  - importSheets
```
public void importSheets()
```
    Description copied from interface: MyrtleSheetAPI
    
    Allows user to interactively import spreadsheets (e.g. .csv files).
    
    Specified by:
    
    importSheets in interface MyrtleSheetAPI
  - importCSVFile
```
public void importCSVFile(java.io.File csvfile)
```
    Description copied from interface: MyrtleSheetAPI
    
    Imports the named CSV file.
    
    Specified by:
    
    importCSVFile in interface MyrtleSheetAPI
  - htmlExportSheet
```
public void htmlExportSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exports the current sheet as a HTML web page.
    
    Specified by:
    
    htmlExportSheet in interface MyrtleSheetAPI
  - csvExportSheet
```
public void csvExportSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exports the current sheet as a CSV file.
    
    Specified by:
    
    csvExportSheet in interface MyrtleSheetAPI
  - htmlExportOneFilePerSheet
```
public void htmlExportOneFilePerSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exports each sheet as a separate HTML web page.
    
    Specified by:
    
    htmlExportOneFilePerSheet in interface MyrtleSheetAPI
  - latexExportOneFilePerSheetMerged
```
public void latexExportOneFilePerSheetMerged()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exports each sheet as a separate LaTeX document.
    
    Specified by:
    
    latexExportOneFilePerSheetMerged in interface MyrtleSheetAPI
  - htmlExportOneFilePerSheetMerged
```
public void htmlExportOneFilePerSheetMerged()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exports each sheet as a single merged HTML web page.
    
    Specified by:
    
    htmlExportOneFilePerSheetMerged in interface MyrtleSheetAPI
  - latexExportOneFilePerSheet
```
public void latexExportOneFilePerSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exports each sheet as a single merged LaTeX document.
    
    Specified by:
    
    latexExportOneFilePerSheet in interface MyrtleSheetAPI
  - getCurrentSheet
```
public DefaultSpreadsheetTable getCurrentSheet()
```
  - goToFirstSheet
```
public void goToFirstSheet()
```
  - getCurrentSheetTitle
```
public java.lang.String getCurrentSheetTitle()
```
    Description copied from interface: MyrtleSheetAPI
    
    Gets the currently selected sheet's title.
    
    Specified by:
    
    getCurrentSheetTitle in interface MyrtleSheetAPI
  - csvExportOneFilePerSheet
```
public void csvExportOneFilePerSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exports each sheet as a separate CSV file.
    
    Specified by:
    
    csvExportOneFilePerSheet in interface MyrtleSheetAPI
  - getPrintExportFormat
```
public java.lang.String getPrintExportFormat()
```
    Description copied from interface: MyrtleSheetAPI
    
    Gets the user's preferred print/export format.
    
    Specified by:
    
    getPrintExportFormat in interface MyrtleSheetAPI
  - getPrintProcExportFormat
```
public java.lang.String getPrintProcExportFormat()
```
  - addSheetNoSideEffects
```
public DefaultSpreadsheetTable addSheetNoSideEffects(int j,
                                            java.lang.String title)
```
  - addSheetBefore
```
public DefaultSpreadsheetTable addSheetBefore()
```
    Description copied from interface: MyrtleSheetAPI
    
    Adds and returns a new sheet positioned before the currently selected sheet.
    
    Specified by:
    
    addSheetBefore in interface MyrtleSheetAPI
  - addNewUndoEvent
```
public void addNewUndoEvent(SpreadsheetUndoEvent undoevt)
```
  - undo
```
public void undo()
```
  - redo
```
public void redo()
```
  - exitAll
```
public void exitAll()
```
    Description copied from interface: MyrtleSheetAPI
    
    Exits the entire project.
    
    Specified by:
    
    exitAll in interface MyrtleSheetAPI
  - addSheetAfterCopyAll
```
public void addSheetAfterCopyAll()
```
    Description copied from interface: MyrtleSheetAPI
    
    Adds a new sheet after the current one and copies the current sheet's contents to that one.
    
    Specified by:
    
    addSheetAfterCopyAll in interface MyrtleSheetAPI
  - addSheetBeforeCopyAll
```
public void addSheetBeforeCopyAll()
```
    Description copied from interface: MyrtleSheetAPI
    
    Adds a new sheet before the current one and copies the current sheet's contents to that one.
    
    Specified by:
    
    addSheetBeforeCopyAll in interface MyrtleSheetAPI
  - deleteSheetNoSideEffects
```
public DefaultSpreadsheetTable deleteSheetNoSideEffects(int j)
```
  - deleteCurrentSheet
```
public void deleteCurrentSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Deletes the currently selected sheet.
    
    Specified by:
    
    deleteCurrentSheet in interface MyrtleSheetAPI
  - copyAllToClipboard
```
public void copyAllToClipboard()
```
    Description copied from interface: MyrtleSheetAPI
    
    Selects and then copies all of the contents of the current sheet to the clipboard.
    
    Specified by:
    
    copyAllToClipboard in interface MyrtleSheetAPI
  - copySelectedToClipboard
```
public void copySelectedToClipboard()
```
    Description copied from interface: MyrtleSheetAPI
    
    Copies the contents of the current sheet's selected range to the clipboard.
    
    Specified by:
    
    copySelectedToClipboard in interface MyrtleSheetAPI
  - selectAll
```
public void selectAll()
```
    Description copied from interface: MyrtleSheetAPI
    
    Selects all of the contents of the current sheet.
    
    Specified by:
    
    selectAll in interface MyrtleSheetAPI
  - pasteMatrixAt
```
public void pasteMatrixAt(SpreadsheetEntryMatrix pastesrc,
                 int startrow,
                 int startcol)
```
  - pasteClipboardAt
```
public void pasteClipboardAt(int r,
                    int c)
```
    Description copied from interface: MyrtleSheetAPI
    
    Pastes the contents of the clipboard beginning at the indicated row and column of the current sheet.
    
    Specified by:
    
    pasteClipboardAt in interface MyrtleSheetAPI
  - getTitleOfTable
```
public java.lang.String getTitleOfTable(DefaultSpreadsheetTable t)
```
    Description copied from interface: MyrtleSheetAPI
    
    Returns the title of the current sheet.
    
    Specified by:
    
    getTitleOfTable in interface MyrtleSheetAPI
  - addSheetAfter
```
public DefaultSpreadsheetTable addSheetAfter()
```
    Description copied from interface: MyrtleSheetAPI
    
    Adds a new sheet positioned subsequent to the current one.
    
    Specified by:
    
    addSheetAfter in interface MyrtleSheetAPI
  - fireSpreadsheetPanelChange
```
public void fireSpreadsheetPanelChange(SpreadsheetPanelEvent ev)
```
    Description copied from interface: MyrtleSheetAPI
    
    Inform all SpreadsheetPanelListeners that a change has occured.
    
    Specified by:
    
    fireSpreadsheetPanelChange in interface MyrtleSheetAPI
  - addSpreadsheetPanelListener
```
public void addSpreadsheetPanelListener(SpreadsheetPanelListener l)
```
    Description copied from interface: MyrtleSheetAPI
    
    Adds the given SpreadsheetPanelListener.
    
    Specified by:
    
    addSpreadsheetPanelListener in interface MyrtleSheetAPI
  - removeSpreadsheetPanelListener
```
public void removeSpreadsheetPanelListener(SpreadsheetPanelListener l)
```
    Description copied from interface: MyrtleSheetAPI
    
    Removes the given SpreadsheetPanelListener.
    
    Specified by:
    
    removeSpreadsheetPanelListener in interface MyrtleSheetAPI
  - goToSheet
```
public void goToSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Allows user to interactively select a sheet and make it current.
    
    Specified by:
    
    goToSheet in interface MyrtleSheetAPI
  - goToSheet
```
public void goToSheet(java.lang.String title)
```
    Description copied from interface: MyrtleSheetAPI
    
    Makes the names sheet current.
    
    Specified by:
    
    goToSheet in interface MyrtleSheetAPI
  - goToNextSheet
```
public void goToNextSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Makes the subsequent sheet the current one.
    
    Specified by:
    
    goToNextSheet in interface MyrtleSheetAPI
  - goToPreviousSheet
```
public void goToPreviousSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Makes the previous sheet the current one.
    
    Specified by:
    
    goToPreviousSheet in interface MyrtleSheetAPI
  - getSheet
```
public SpreadsheetTable getSheet(java.lang.String title)
```
    Description copied from interface: MyrtleSheetAPI
    
    Returns the named sheet as a SpreadsheetTable.
    
    Specified by:
    
    getSheet in interface MyrtleSheetAPI
  - getSheetCount
```
public int getSheetCount()
```
    Description copied from interface: MyrtleSheetAPI
    
    Returns the total number of sheets.
    
    Specified by:
    
    getSheetCount in interface MyrtleStorage
    
    Specified by:
    
    getSheetCount in interface MyrtleSheetAPI
  - getSheetAt
```
public SpreadsheetTable getSheetAt(int j)
```
    Description copied from interface: MyrtleSheetAPI
    
    Returns the sheet at the given index as a SpreadsheetTable.
    
    Specified by:
    
    getSheetAt in interface MyrtleSheetAPI
  - rangeGrabAction
```
public void rangeGrabAction(RangeGrabEvent e)
```
    Description copied from interface: MyrtleSheetAPI
    
    Executes and updates for the given RangeGrabEvent.
    
    Specified by:
    
    rangeGrabAction in interface MyrtleSheetAPI
    
    Specified by:
    
    rangeGrabAction in interface RangeGrabListener
  - tableChanged
```
public void tableChanged(javax.swing.event.TableModelEvent ev)
```
    This method get's called if any of the table's entries are modified...
    
    Specified by:
    
    tableChanged in interface MyrtleSheetAPI
    
    Specified by:
    
    tableChanged in interface javax.swing.event.TableModelListener
  - createNewSheet
```
public SpreadsheetTable createNewSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Creates a new sheet as a SpreadsheetTable.
    
    Specified by:
    
    createNewSheet in interface MyrtleSheetAPI
  - printOneFilePerSheet
```
public void printOneFilePerSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Prints separately for each sheet.
    
    Specified by:
    
    printOneFilePerSheet in interface MyrtleSheetAPI
  - printSheet
```
public void printSheet()
```
    Description copied from interface: MyrtleSheetAPI
    
    Prints the currently selected sheet.
    
    Specified by:
    
    printSheet in interface MyrtleSheetAPI
  - printJPG
```
public void printJPG(java.io.File jpgfile)
```
  - pngExportOneFilePerLink
```
public void pngExportOneFilePerLink()
```
  - jpgExportOneFilePerLink
```
public void jpgExportOneFilePerLink()
```
  - pngExportLink
```
public void pngExportLink()
```
  - pngExportLink
```
public void pngExportLink(DefaultSpreadsheetPanel.LinkLabel l)
```
  - jpgExportLink
```
public void jpgExportLink()
```
  - jpgExportLink
```
public void jpgExportLink(DefaultSpreadsheetPanel.LinkLabel l)
```
  - printLink
```
public void printLink(DefaultSpreadsheetPanel.LinkLabel l,
             boolean interactive)
```
  - printOneFilePerLink
```
public void printOneFilePerLink()
```
  - printLink
```
public void printLink()
```
  - getGroovyScriptReservedFunctionFor
```
public GroovyScriptReservedFunction getGroovyScriptReservedFunctionFor(java.lang.String cobj,
                                                              DefaultSpreadsheetPanel parentPanel,
                                                              DefaultSpreadsheetTable parentTable,
                                                              DefaultSpreadsheetEntry entry)
```
    Description copied from interface: MyrtleSheetAPI
    
    Returns a reserved function having the indicated name and associates it with the indicated panel, table, and spreadsheet cell.
    
    Specified by:
    
    getGroovyScriptReservedFunctionFor in interface MyrtleSheetAPI
  - addBookmarkFolder
```
public void addBookmarkFolder(java.lang.String cat)
```
    Specified by:
    
    addBookmarkFolder in interface MyrtleStorage
  - getAllBookmarks
```
public java.util.LinkedHashMap getAllBookmarks()
```
    Specified by:
    
    getAllBookmarks in interface MyrtleStorage
  - removeAllBookmarks
```
public void removeAllBookmarks()
```
    Specified by:
    
    removeAllBookmarks in interface MyrtleStorage
  - selectAllProcs
```
public void selectAllProcs()
```
    Description copied from interface: MyrtleSheetAPI
    
    Selects all of the procedurs that are currently docked into the scripting frame.
    
    Specified by:
    
    selectAllProcs in interface MyrtleSheetAPI
  - importProc
```
public void importProc(java.net.URL url)
```
    Description copied from interface: MyrtleSheetAPI
    
    Imports and docks a new script at the given URL into the scripting frame.
    
    Specified by:
    
    importProc in interface MyrtleSheetAPI
  - importProc
```
public void importProc()
```
    Description copied from interface: MyrtleSheetAPI
    
    Imports and docks a new script interactively into the scripting frame.
    
    Specified by:
    
    importProc in interface MyrtleSheetAPI
  - saveOneFilePerProc
```
public void saveOneFilePerProc()
```
    Description copied from interface: MyrtleSheetAPI
    
    Saves/exports each procedure to a file.
    
    Specified by:
    
    saveOneFilePerProc in interface MyrtleSheetAPI
  - saveProcAs
```
public void saveProcAs(SpreadsheetProcedure selected,
              java.io.File fid)
```
    Description copied from interface: MyrtleSheetAPI
    
    Saves the indicated procedure to the given file.
    
    Specified by:
    
    saveProcAs in interface MyrtleSheetAPI
  - editSelectedLinkLabels
```
public void editSelectedLinkLabels()
```
    Description copied from interface: MyrtleSheetAPI
    
    Edits/Browses the selected registered links.
    
    Specified by:
    
    editSelectedLinkLabels in interface MyrtleSheetAPI
  - editSelectedScripts
```
public void editSelectedScripts()
```
    Description copied from interface: MyrtleSheetAPI
    
    Edits/Browses the selected procedures.
    
    Specified by:
    
    editSelectedScripts in interface MyrtleSheetAPI
  - saveProcAs
```
public void saveProcAs()
```
    Description copied from interface: MyrtleSheetAPI
    
    Allows user to saves the selected procedures interactively.
    
    Specified by:
    
    saveProcAs in interface MyrtleSheetAPI
  - addProc
```
public void addProc(SpreadsheetProcedure newScript)
```
    Description copied from interface: MyrtleSheetAPI
    
    Adds the given procedure and docks it into the scripting frame.
    
    Specified by:
    
    addProc in interface MyrtleSheetAPI
  - showProcedureStackTrace
```
public void showProcedureStackTrace(java.lang.String script,
                           java.lang.Throwable e)
```
    Description copied from interface: MyrtleSheetAPI
    
    Allows user to view and debug failed scripts by showing the stack trace which lead up to the script failing.
    
    Specified by:
    
    showProcedureStackTrace in interface MyrtleSheetAPI
  - showStackTrace
```
public void showStackTrace(java.lang.Throwable e)
```
    Description copied from interface: MyrtleSheetAPI
    
    Allows user to view and debug by showing the stack trace.
    
    Specified by:
    
    showStackTrace in interface MyrtleSheetAPI
  - findActiveFrame
```
protected java.awt.Frame findActiveFrame()
```
  - stack2string
```
protected static java.lang.String stack2string(java.lang.Throwable e)
```
  - setComment
```
public void setComment(java.lang.String com)
```
    Specified by:
    
    setComment in interface RepositoryStorage
  - getComment
```
public java.lang.String getComment()
```
    Description copied from interface: RepositoryStorage
    
    Gets the descriptive comment for this Wedge inverse problem as a whole.
    
    Specified by:
    
    getComment in interface RepositoryStorage
  - setCreatedOn
```
public void setCreatedOn(java.lang.String com)
```
    Specified by:
    
    setCreatedOn in interface RepositoryStorage
  - getCreatedOn
```
public java.lang.String getCreatedOn()
```
    Specified by:
    
    getCreatedOn in interface RepositoryStorage
  - setCreatedBy
```
public void setCreatedBy(java.lang.String com)
```
    Specified by:
    
    setCreatedBy in interface RepositoryStorage
  - getCreatedBy
```
public java.lang.String getCreatedBy()
```
    Specified by:
    
    getCreatedBy in interface RepositoryStorage
  - setNickname
```
public void setNickname(java.lang.String s)
```
    Description copied from interface: RepositoryStorage
    
    Sets the project name for this Wedge inverse problem.
    
    Specified by:
    
    setNickname in interface RepositoryStorage
  - getNickname
```
public java.lang.String getNickname()
```
    Description copied from interface: RepositoryStorage
    
    Gets the project name for this Wedge inverse problem.
    
    Specified by:
    
    getNickname in interface RepositoryStorage
  - setEnabled
```
public void setEnabled(java.lang.String s)
```
    Description copied from interface: RepositoryStorage
    
    Sets the enabled state of the (possibly remote) storage instance. Typically a storage is backed by static information stored in a database.
    
    Specified by:
    
    setEnabled in interface RepositoryStorage
  - getEnabled
```
public java.lang.String getEnabled()
```
    Description copied from interface: RepositoryStorage
    
    Gets the state of the (possibly remote) storage. For example, dis-enabled storages may be slated for deletion from some repostories. Typically a storage is backed by static information stored in a database.
    
    Specified by:
    
    getEnabled in interface RepositoryStorage
  - transferStorage
```
public void transferStorage(RepositoryStorage that)
```
    Specified by:
    
    transferStorage in interface RepositoryStorageTransfer
  - transferStorageCommands
```
public void transferStorageCommands(RepositoryStorage x)
```
    Specified by:
    
    transferStorageCommands in interface RepositoryStorageTransfer
  - copyStorageCommands
```
public void copyStorageCommands(RepositoryStorage x)
```
    Specified by:
    
    copyStorageCommands in interface RepositoryStorageTransfer
  - copyStorage
```
public void copyStorage(RepositoryStorage x)
```
    Specified by:
    
    copyStorage in interface RepositoryStorageTransfer
  - beforeTransferStorage
```
public void beforeTransferStorage()
```
    Specified by:
    
    beforeTransferStorage in interface RepositoryStorageTransfer
  - afterTransferStorage
```
public void afterTransferStorage()
```
    Specified by:
    
    afterTransferStorage in interface RepositoryStorageTransfer
  - beforeCopyStorage
```
public void beforeCopyStorage()
```
    Specified by:
    
    beforeCopyStorage in interface RepositoryStorageTransfer
  - afterCopyStorage
```
public void afterCopyStorage()
```
    Specified by:
    
    afterCopyStorage in interface RepositoryStorageTransfer
  - getDOMStorageClass
```
public java.lang.Class getDOMStorageClass()
```
    Specified by:
    
    getDOMStorageClass in interface DOMStorable
  - getStorageTransferAgentClass
```
public java.lang.Class getStorageTransferAgentClass()
```
  - removeRepositoryListener
```
public void removeRepositoryListener(RepositoryListener listen)
```
    Specified by:
    
    removeRepositoryListener in interface RepositoryStorage
  - addRepositoryListener
```
public void addRepositoryListener(RepositoryListener listen)
```
    Specified by:
    
    addRepositoryListener in interface RepositoryStorage
  - getDefaultGraphicalEditorClass
```
public java.lang.Class getDefaultGraphicalEditorClass()
```
    Specified by:
    
    getDefaultGraphicalEditorClass in interface RepositoryStorage
  - setPersistentSheetCounter
```
public void setPersistentSheetCounter(int shts)
```
    Specified by:
    
    setPersistentSheetCounter in interface MyrtleStorage
  - getPersistentSheetCounter
```
public int getPersistentSheetCounter()
```
    Specified by:
    
    getPersistentSheetCounter in interface MyrtleStorage
  - addSheet
```
public void addSheet(java.lang.String title)
```
    Specified by:
    
    addSheet in interface MyrtleStorage
  - removeSheet
```
public void removeSheet(java.lang.String title)
```
    Specified by:
    
    removeSheet in interface MyrtleStorage
  - setSheetDescription
```
public void setSheetDescription(java.lang.String title,
                       java.lang.String desc)
```
    Specified by:
    
    setSheetDescription in interface MyrtleStorage
  - getSheetDescription
```
public java.lang.String getSheetDescription(java.lang.String title)
```
    Specified by:
    
    getSheetDescription in interface MyrtleStorage
  - setEntryFunctionAt
```
public void setEntryFunctionAt(java.lang.String title,
                      int row,
                      int col,
                      java.lang.String strrep)
```
    Specified by:
    
    setEntryFunctionAt in interface MyrtleStorage
  - setEntryValueAt
```
public void setEntryValueAt(java.lang.String title,
                   int row,
                   int col,
                   java.lang.String strval)
```
    Specified by:
    
    setEntryValueAt in interface MyrtleStorage
  - getAllEntries
```
public java.util.Vector getAllEntries(java.lang.String title)
```
    Description copied from interface: MyrtleStorage
    
    Gets all the entries for a particular sheet.
    
    Specified by:
    
    getAllEntries in interface MyrtleStorage
  - getEntryFunctionAt
```
public java.lang.String getEntryFunctionAt(java.lang.String title,
                                  int row,
                                  int col)
```
    Specified by:
    
    getEntryFunctionAt in interface MyrtleStorage
  - getEntryValueAt
```
public java.lang.String getEntryValueAt(java.lang.String title,
                               int row,
                               int col)
```
    Specified by:
    
    getEntryValueAt in interface MyrtleStorage
  - getScriptCount
```
public int getScriptCount()
```
    Specified by:
    
    getScriptCount in interface MyrtleStorage
  - addScriptAt
```
public void addScriptAt(int pos)
```
    Specified by:
    
    addScriptAt in interface MyrtleStorage
  - removeScriptAt
```
public void removeScriptAt(int pos)
```
    Specified by:
    
    removeScriptAt in interface MyrtleStorage
  - setScriptContents
```
public void setScriptContents(int pos,
                     java.lang.String s)
```
    Specified by:
    
    setScriptContents in interface MyrtleStorage
  - getScriptContents
```
public java.lang.String getScriptContents(int pos)
```
    Specified by:
    
    getScriptContents in interface MyrtleStorage
  - setScriptLabel
```
public void setScriptLabel(int pos,
                  java.lang.String s)
```
    Specified by:
    
    setScriptLabel in interface MyrtleStorage
  - getScriptLabel
```
public java.lang.String getScriptLabel(int pos)
```
    Specified by:
    
    getScriptLabel in interface MyrtleStorage
  - getRowCountForSheet
```
public int getRowCountForSheet(java.lang.String title)
```
    Specified by:
    
    getRowCountForSheet in interface MyrtleStorage
  - getColumnCountForSheet
```
public int getColumnCountForSheet(java.lang.String title)
```
    Specified by:
    
    getColumnCountForSheet in interface MyrtleStorage
  - setRowCountForSheet
```
public void setRowCountForSheet(java.lang.String title,
                       int rows)
```
    Specified by:
    
    setRowCountForSheet in interface MyrtleStorage
  - setColumnCountForSheet
```
public void setColumnCountForSheet(java.lang.String title,
                          int cols)
```
    Specified by:
    
    setColumnCountForSheet in interface MyrtleStorage
  - removeAllScripts
```
public void removeAllScripts()
```
    Specified by:
    
    removeAllScripts in interface MyrtleStorage
  - removeAllSheets
```
public void removeAllSheets()
```
    Specified by:
    
    removeAllSheets in interface MyrtleStorage
  - getSheetLabel
```
public java.lang.String getSheetLabel(int sht)
```
    Specified by:
    
    getSheetLabel in interface MyrtleStorage
  - openProject
```
public void openProject()
```
  - addRegisteredLink
```
public void addRegisteredLink(java.lang.String linklabel,
                     java.lang.String linkurl)
```
    Specified by:
    
    addRegisteredLink in interface MyrtleStorage
  - getAllRegisteredLinks
```
public java.util.Vector getAllRegisteredLinks()
```
    Specified by:
    
    getAllRegisteredLinks in interface MyrtleStorage
  - removeAllRegisteredLinks
```
public void removeAllRegisteredLinks()
```
    Specified by:
    
    removeAllRegisteredLinks in interface MyrtleStorage
  - getSelectedRegisteredLink
```
public DefaultSpreadsheetPanel.LinkLabel getSelectedRegisteredLink()
```
    Returns the first selected registered link (image).
  - getSelectedRegisteredLinks
```
public java.util.Vector getSelectedRegisteredLinks()
```
  - union
```
public void union()
```
  - dummyCoding
```
public java.util.LinkedHashMap dummyCoding(java.lang.String a)
```
  - uniqueValues
```
public java.util.Vector uniqueValues(java.lang.String a)
```
  - union
```
public void union(java.lang.String a,
         java.lang.String b,
         java.lang.String dest)
```
  - intersect
```
public void intersect()
```
  - intersect
```
public void intersect(java.lang.String a,
             java.lang.String b,
             java.lang.String dest)
```
  - setdiff
```
public void setdiff()
```
  - setMask
```
public void setMask()
```
  - setMaskRows
```
public void setMaskRows()
```
  - setMaskColumns
```
public void setMaskColumns()
```
  - setdiff
```
public void setdiff(java.lang.String a,
           java.lang.String b,
           java.lang.String dest)
```
    Returns values in first argument that are not in the second argument.
  - setMask
```
public void setMask(java.lang.String a,
           java.lang.String b,
           java.lang.String dest)
```
    Returns values in first argument where the values in the second argument equal 1.0.
  - setMaskRows
```
public void setMaskRows(java.lang.String a,
               java.lang.String b,
               java.lang.String dest)
```
    Returns rows of the region in the first argument where the values in the second argument equal 1.0. The number of rows in the first argument must match the number of entries in the second argument.
  - setMaskColumns
```
public void setMaskColumns(java.lang.String a,
                  java.lang.String b,
                  java.lang.String dest)
```
    Returns columns of the region in the first argument where the values in the second argument equal 1.0. The number of columns in the first argument must match the number of entries in the second argument.
  - parseDblMatrix
```
public DblMatrix parseDblMatrix(java.lang.Object arg0)
```
  - parseStringMatrix
```
public java.lang.String[][] parseStringMatrix(java.lang.Object arg0)
```
  - showMessageDialog
```
public void showMessageDialog(java.lang.String s)
```
    Description copied from interface: MyrtleSheetAPI
    
    Shows a message to the user. This is a convenience method for showing a simple informative message to the user.
    
    Specified by:
    
    showMessageDialog in interface MyrtleSheetAPI

Class DefaultSpreadsheetPanel

Nested Class Summary

Nested classes/interfaces inherited from class javax.swing.JPanel

Nested classes/interfaces inherited from class javax.swing.JComponent

Nested classes/interfaces inherited from class java.awt.Container

Nested classes/interfaces inherited from class java.awt.Component

Field Summary

Fields inherited from class javax.swing.JComponent

Fields inherited from class java.awt.Component

Fields inherited from interface java.awt.image.ImageObserver

Constructor Summary

Method Summary

Methods inherited from class javax.swing.JPanel

Methods inherited from class javax.swing.JComponent

Methods inherited from class java.awt.Container

Methods inherited from class java.awt.Component

Methods inherited from class java.lang.Object

Field Detail

Connection

Constructor Detail

DefaultSpreadsheetPanel

Method Detail

browseSelectedLinks

get_function

setCurrentPreferenceSet

getCurrentPreferenceSet

applyPreferences

editPreferences

evalFunction

addNewProcedure

addNewProcedure

evaluateSelectedProcedures

linkFigureAsPNG

linkFigureAsPNG

getTimeStamp

getDefaultOutputDirectory

getPreferenceValue

getPreferences

addSelectionBookmark

fillSelection

sortRange

manageSelectionBookmarks

getNormalDistribution

getFDistribution

getDiscreteUniformDistribution

getBernoulliDistribution

getPoissonDistribution

getUniformDistribution

getGammaDistribution

getHypergeometricDistribution

getTDistribution

getChiSqDistribution

getBinomialDistribution

getGetFunctionLibrary

addRangeGrabListener

removeRangeGrabListener

deleteSelectedProcs

refreshListeners

archiveSelectedProcs

addBookmark

addBookmark

addBookmark

loadArchivedProcedure

addBookmark

pasteDblMatrixAt

pasteDblMatrixAt

fillRange

fillRange

saveProject

refreshLink

refreshSelectedLinks

refreshLink

getDblMatrixForRange

getDblMatrixFor

getDblMatrixForBookmark

getBookmarkForRange

getRangeForBookmark

rangeOf

getAllRanges

nameOf