com.extentech.ExtenXLS.eventui
Class ExtenXLSTable

java.lang.Object
  extended by java.awt.Component
      extended by java.awt.Container
          extended by javax.swing.JComponent
              extended by javax.swing.JTable
                  extended by com.extentech.swingtools.DraggableTable
                      extended by com.extentech.ExtenXLS.eventui.ExtenXLSTable
All Implemented Interfaces:
SheetTable, java.awt.dnd.DragGestureListener, java.awt.dnd.DragSourceListener, java.awt.dnd.DropTargetListener, java.awt.image.ImageObserver, java.awt.MenuContainer, java.io.Serializable, java.util.EventListener, javax.accessibility.Accessible, javax.swing.event.CellEditorListener, javax.swing.event.ListSelectionListener, javax.swing.event.RowSorterListener, javax.swing.event.TableColumnModelListener, javax.swing.event.TableModelListener, javax.swing.Scrollable
Direct Known Subclasses:
ExtenXLSRowTable

public class ExtenXLSTable
extends com.extentech.swingtools.DraggableTable
implements SheetTable

See Also:
Serialized Form

Nested Class Summary
 
Nested classes/interfaces inherited from class javax.swing.JTable
javax.swing.JTable.DropLocation, javax.swing.JTable.PrintMode
 
Nested classes/interfaces inherited from class javax.swing.JComponent
javax.swing.JComponent.AccessibleJComponent
 
Nested classes/interfaces inherited from class java.awt.Component
java.awt.Component.BaselineResizeBehavior
 
Field Summary
 int lastcol
          do the mouseover row/col cursor
 int lastrow
          do the mouseover row/col cursor
 ExtenXLSCellRenderer renda
           
static int ROW_HEADER_WIDTH
           
 
Fields inherited from class com.extentech.swingtools.DraggableTable
DEBUG, dragSource
 
Fields inherited from class javax.swing.JTable
AUTO_RESIZE_ALL_COLUMNS, AUTO_RESIZE_LAST_COLUMN, AUTO_RESIZE_NEXT_COLUMN, AUTO_RESIZE_OFF, AUTO_RESIZE_SUBSEQUENT_COLUMNS
 
Fields inherited from class javax.swing.JComponent
TOOL_TIP_TEXT_KEY, 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
 
Constructor Summary
ExtenXLSTable(WorkBookModel model)
           
 
Method Summary
 void addEditEndListener(EditEndListener listener)
           
 void addEditStartListener(EditStartListener listener)
           
 void columnMarginChanged(javax.swing.event.ChangeEvent e)
           
 double convertPixelsToTwips(double pixels)
          Converts pixels to Excel row height units (twips).
 double convertPixelsToZeros(double pixels)
          Converts pixels to Excel column width units.
 double convertTwipsToPixels(double twips)
          Converts Excel row height units (twips) to pixels.
 double convertZerosToPixels(double zeros)
          Converts Excel column width units to pixels.
 void dragOver(java.awt.dnd.DropTargetDragEvent de)
           
 javax.swing.table.TableCellEditor getCellEditor(int row, int column)
          Returns an appropriate editor for the specified cell.
 java.awt.Rectangle getCellRect(int row, int column, boolean includeSpacing)
           
 javax.swing.table.TableCellRenderer getCellRenderer(int row, int column)
          Returns an appropriate renderer for the specified cell.
 int getColWidthInTableUnits(int width)
           
 int getColWidthInXLSUnits(int width)
           
 javax.swing.table.TableCellEditor getDefaultEditor(java.lang.Class columnClass)
          Returns the default editor for the specified class.
 javax.swing.table.TableCellRenderer getDefaultRenderer(java.lang.Class columnClass)
          Returns the default renderer for the specified class.
 ExtenXLSCellRenderer getExtenXLSCellRenderer()
           
 int getLeftCol()
           
 int getRowHeight(int row)
           
 int getRowHeightInTableUnits(int height)
           
 int getRowHeightInXLSUnits(int height)
           
 int getRowMargin()
           
 int getTopRow()
           
 double getZoom()
           
 void initCharts()
          display charts
 void initColumnSizes()
          This method picks good column sizes.
 void initPopups()
           
 void initUI()
           
 void removeEditEndListener(EditEndListener listener)
           
 void removeEditStartListener(EditStartListener listener)
           
 void setRowMargin(int i)
           
 void setZoom(int zoom)
           
 
Methods inherited from class com.extentech.swingtools.DraggableTable
dragDropEnd, dragEnter, dragEnter, dragExit, dragExit, dragGestureRecognized, dragOver, drop, dropActionChanged, dropActionChanged, getDragSource
 
Methods inherited from class javax.swing.JTable
addColumn, addColumnSelectionInterval, addNotify, addRowSelectionInterval, changeSelection, clearSelection, columnAdded, columnAtPoint, columnMoved, columnRemoved, columnSelectionChanged, convertColumnIndexToModel, convertColumnIndexToView, convertRowIndexToModel, convertRowIndexToView, createDefaultColumnsFromModel, createScrollPaneForTable, doLayout, editCellAt, editCellAt, editingCanceled, editingStopped, getAccessibleContext, getAutoCreateColumnsFromModel, getAutoCreateRowSorter, getAutoResizeMode, getCellEditor, getCellSelectionEnabled, getColumn, getColumnClass, getColumnCount, getColumnModel, getColumnName, getColumnSelectionAllowed, getDragEnabled, getDropLocation, getDropMode, getEditingColumn, getEditingRow, getEditorComponent, getFillsViewportHeight, getGridColor, getIntercellSpacing, getModel, getPreferredScrollableViewportSize, getPrintable, getRowCount, getRowHeight, getRowSelectionAllowed, getRowSorter, getScrollableBlockIncrement, getScrollableTracksViewportHeight, getScrollableTracksViewportWidth, getScrollableUnitIncrement, getSelectedColumn, getSelectedColumnCount, getSelectedColumns, getSelectedRow, getSelectedRowCount, getSelectedRows, getSelectionBackground, getSelectionForeground, getSelectionModel, getShowHorizontalLines, getShowVerticalLines, getSurrendersFocusOnKeystroke, getTableHeader, getToolTipText, getUI, getUIClassID, getUpdateSelectionOnSort, getValueAt, isCellEditable, isCellSelected, isColumnSelected, isEditing, isRowSelected, moveColumn, prepareEditor, prepareRenderer, print, print, print, print, print, removeColumn, removeColumnSelectionInterval, removeEditor, removeNotify, removeRowSelectionInterval, rowAtPoint, selectAll, setAutoCreateColumnsFromModel, setAutoCreateRowSorter, setAutoResizeMode, setCellEditor, setCellSelectionEnabled, setColumnModel, setColumnSelectionAllowed, setColumnSelectionInterval, setDefaultEditor, setDefaultRenderer, setDragEnabled, setDropMode, setEditingColumn, setEditingRow, setFillsViewportHeight, setGridColor, setIntercellSpacing, setModel, setPreferredScrollableViewportSize, setRowHeight, setRowHeight, setRowSelectionAllowed, setRowSelectionInterval, setRowSorter, setSelectionBackground, setSelectionForeground, setSelectionMode, setSelectionModel, setShowGrid, setShowHorizontalLines, setShowVerticalLines, setSurrendersFocusOnKeystroke, setTableHeader, setUI, setUpdateSelectionOnSort, setValueAt, sizeColumnsToFit, sizeColumnsToFit, sorterChanged, tableChanged, updateUI, valueChanged
 
Methods inherited from class javax.swing.JComponent
addAncestorListener, addVetoableChangeListener, computeVisibleRect, contains, createToolTip, disable, enable, firePropertyChange, firePropertyChange, firePropertyChange, getActionForKeyStroke, getActionMap, getAlignmentX, getAlignmentY, getAncestorListeners, getAutoscrolls, getBaseline, getBaselineResizeBehavior, getBorder, getBounds, getClientProperty, 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, getTopLevelAncestor, getTransferHandler, getVerifyInputWhenFocusTarget, getVetoableChangeListeners, getVisibleRect, getWidth, getX, getY, grabFocus, isDoubleBuffered, isLightweightComponent, isManagingFocus, isOpaque, isOptimizedDrawingEnabled, isPaintingForPrint, isPaintingTile, isRequestFocusEnabled, isValidateRoot, paint, paintImmediately, paintImmediately, print, printAll, putClientProperty, registerKeyboardAction, registerKeyboardAction, removeAncestorListener, removeVetoableChangeListener, repaint, repaint, requestDefaultFocus, requestFocus, requestFocus, 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, setVerifyInputWhenFocusTarget, setVisible, unregisterKeyboardAction, update
 
Methods inherited from class java.awt.Container
add, add, add, add, add, addContainerListener, addPropertyChangeListener, addPropertyChangeListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, 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, remove, remove, removeAll, removeContainerListener, setComponentZOrder, setFocusCycleRoot, setFocusTraversalPolicy, setFocusTraversalPolicyProvider, setLayout, transferFocusBackward, transferFocusDownCycle, validate
 
Methods inherited from class java.awt.Component
action, add, addComponentListener, addFocusListener, addHierarchyBoundsListener, addHierarchyListener, addInputMethodListener, addKeyListener, addMouseListener, addMouseMotionListener, addMouseWheelListener, bounds, checkImage, checkImage, contains, createImage, createImage, createVolatileImage, createVolatileImage, dispatchEvent, enable, enableInputMethods, 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, 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, transferFocusUpCycle
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

lastrow

public int lastrow
do the mouseover row/col cursor


lastcol

public int lastcol
do the mouseover row/col cursor


renda

public ExtenXLSCellRenderer renda

ROW_HEADER_WIDTH

public static int ROW_HEADER_WIDTH
Constructor Detail

ExtenXLSTable

public ExtenXLSTable(WorkBookModel model)
Method Detail

addEditStartListener

public void addEditStartListener(EditStartListener listener)

removeEditStartListener

public void removeEditStartListener(EditStartListener listener)

addEditEndListener

public void addEditEndListener(EditEndListener listener)

removeEditEndListener

public void removeEditEndListener(EditEndListener listener)

convertTwipsToPixels

public double convertTwipsToPixels(double twips)
Converts Excel row height units (twips) to pixels. Twips are widely used as a distance unit by Excel, especially for row heights. They are defined as one twentieth of a typographic point.

Parameters:
twips - a value in twips
Returns:
the given value in pixels
See Also:
convertPixelsToTwips(double)

convertPixelsToTwips

public double convertPixelsToTwips(double pixels)
Converts pixels to Excel row height units (twips). Twips are widely used as a distance unit by Excel, especially for row heights. They are defined as one twentieth of a typographic point.

Parameters:
pixels - a value in pixels
Returns:
the given value in twips
See Also:
convertTwipsToPixels

convertZerosToPixels

public double convertZerosToPixels(double zeros)
Converts Excel column width units to pixels. Excel column units are defined as the advance width of the zero character in the default font.

Parameters:
zeros - a value in Excel column units
Returns:
the given value in pixels
See Also:
convertPixelsToZeros(double)

convertPixelsToZeros

public double convertPixelsToZeros(double pixels)
Converts pixels to Excel column width units. Excel column units are defined as the advance width of the zero character in the default font.

Parameters:
zeros - a value in pixels
Returns:
the given value in Excel column units
See Also:
convertZerosToPixels(double)

dragOver

public void dragOver(java.awt.dnd.DropTargetDragEvent de)
Specified by:
dragOver in interface java.awt.dnd.DropTargetListener
Overrides:
dragOver in class com.extentech.swingtools.DraggableTable

getExtenXLSCellRenderer

public ExtenXLSCellRenderer getExtenXLSCellRenderer()
Specified by:
getExtenXLSCellRenderer in interface SheetTable

initUI

public void initUI()
Overrides:
initUI in class com.extentech.swingtools.DraggableTable

initCharts

public void initCharts()
display charts


initColumnSizes

public void initColumnSizes()
This method picks good column sizes. If all column heads are wider than the column's cells' contents, then you can just use column.sizeWidthToFit().


getDefaultEditor

public javax.swing.table.TableCellEditor getDefaultEditor(java.lang.Class columnClass)
Returns the default editor for the specified class. This implementation always returns the value of editor, thereby avoiding several hash table lookups per call and improving performance.

Overrides:
getDefaultEditor in class javax.swing.JTable

getCellEditor

public javax.swing.table.TableCellEditor getCellEditor(int row,
                                                       int column)
Returns an appropriate editor for the specified cell. This implementation always returns the value of editor, thereby avoiding several hash table lookups per call and improving performance.

Overrides:
getCellEditor in class javax.swing.JTable

getDefaultRenderer

public javax.swing.table.TableCellRenderer getDefaultRenderer(java.lang.Class columnClass)
Returns the default renderer for the specified class. This implementation always returns the value of renda, thereby avoiding several hash table lookups per call and improving performance.

Overrides:
getDefaultRenderer in class javax.swing.JTable

getCellRenderer

public javax.swing.table.TableCellRenderer getCellRenderer(int row,
                                                           int column)
Returns an appropriate renderer for the specified cell. This implementation always returns the value of renda, thereby avoiding several hash table lookups per call and improving performance.

Overrides:
getCellRenderer in class javax.swing.JTable

setRowMargin

public void setRowMargin(int i)
Overrides:
setRowMargin in class javax.swing.JTable

getRowMargin

public int getRowMargin()
Overrides:
getRowMargin in class javax.swing.JTable

getLeftCol

public int getLeftCol()

getTopRow

public int getTopRow()

getRowHeightInTableUnits

public int getRowHeightInTableUnits(int height)

getRowHeightInXLSUnits

public int getRowHeightInXLSUnits(int height)

getColWidthInTableUnits

public int getColWidthInTableUnits(int width)

getColWidthInXLSUnits

public int getColWidthInXLSUnits(int width)

getRowHeight

public int getRowHeight(int row)
Overrides:
getRowHeight in class javax.swing.JTable

getCellRect

public java.awt.Rectangle getCellRect(int row,
                                      int column,
                                      boolean includeSpacing)
Overrides:
getCellRect in class javax.swing.JTable

getZoom

public double getZoom()
Returns:
Returns the zoom.

setZoom

public void setZoom(int zoom)
Parameters:
zoom - The zoom to set.

initPopups

public void initPopups()

columnMarginChanged

public void columnMarginChanged(javax.swing.event.ChangeEvent e)
Specified by:
columnMarginChanged in interface javax.swing.event.TableColumnModelListener
Overrides:
columnMarginChanged in class javax.swing.JTable


Copyright © 2011 Extentech Inc. All Rights Reserved.