com.iisc.jwc.jsheet
Class Sheet

java.lang.Object
  java.awt.Component
      java.awt.Container
          java.awt.Panel
              com.roguewave.blend.obbase.v2_0.OBBase
                  com.iisc.grid.GXCore
                      com.iisc.grid.GXCore1
                          com.iisc.grid.GXGridCore
                              com.iisc.jwc.jsheet.Sheet

All Implemented Interfaces:

javax.accessibility.Accessible, java.awt.event.AdjustmentListener, java.awt.datatransfer.ClipboardOwner, java.util.EventListener, java.awt.image.ImageObserver, com.iisc.jwc.jsheet.ISheet, java.awt.MenuContainer, java.io.Serializable

public class Sheet

extends com.iisc.grid.GXGridCore

implements com.iisc.jwc.jsheet.ISheet

Title:

Sheet.java

Description: The Sheet class is the visible grid component. It stores a reference to the Wingz Server sheet object. It creates the SheetObserver and SheetViewObserver callbacks so it can be notified of data and formatting changes to this sheet.

See Also:

Serialized Form

Field Summary

Fields inherited from class com.iisc.grid.GXGridCore

BUTTON, CHECKBOX, COMBOBOX, CURRENCYFIELD, DATEFIELD, LABEL, LISTBOX, MASKEDIT, MergeHorz, MergeVert, SPINNER, TIMEFIELD

Fields inherited from class com.iisc.grid.GXCore1

coDraggingCells, coDraggingCols, coDraggingDiagonalResizing, coDraggingHorizontalResizing, coDraggingHorizontalSelection, coDraggingRows, coDraggingSelection, coDraggingVerticalResizing, coDraggingVerticalSelection, coNoDragging, coNOP, coSelectedCurCell, coSelectedTable, escaped, TEXT

Fields inherited from class com.iisc.grid.GXCore

ALPHA_HEADINGS, DELETE, IMAGE, INSERT, MOVE, NUMERIC_HEADINGS

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

Sheet()

Sheet(com.iisc.jwc.orb.CSheet cSheet, JSClient target, com.iisc.jwc.jsheet.Book book)
Initilize the Sheet

Method Summary

com.iisc.jwc.jsheet.ObserverItems	addObserver(com.iisc.jwc.orb.CRange range, short nameID) Creates an Observers object for this range.
com.iisc.jwc.jsheet.ObserverItems	addObserver(com.iisc.jwc.orb.CRange range, short nameID, boolean cacheOnServer, int updateInterval) Creates an Observers object for this range.
void	addProtection(com.iisc.jwc.orb.CRange[] range, java.lang.String userOrGroup, int permission)
void	clearCells(Range[] ranges)
void	clearSelectedData()
void	dragAndDrop(int nRow, int nCol, boolean isCtrlDown)
void	draw(java.awt.Graphics g)
void	enableFeatures()
com.iisc.jwc.orb.CCell	getActiveCell() Returns the current active cell
com.iisc.jwc.jsheet.Book	getBook() Returns the book for this sheet
com.iisc.jwc.orb.CCellData	getCellData(Cell cell)
java.lang.String	getCellEntry(com.iisc.jwc.orb.CCell cell) Returns the value of the cell at row, col.
java.lang.String	getCellHTML(com.iisc.jwc.orb.CCell cell, int flags) Returns the HTML of the cell at row, col.
int	getCellProtection(com.iisc.jwc.orb.CCell cell)
com.iisc.jwc.orb.CValue	getCellValue(com.iisc.jwc.orb.CCell cell) Returns the value of the cell.
com.iisc.jwc.orb.CSheet	getCSheet() Returns the CORBA CSheet object
com.iisc.jwc.orb.CSheetView	getCSheetView() Returns the CORBA CSheetView object
com.iisc.jwc.orb.CStyle	getCStyle(com.iisc.jwc.orb.CCell cell) Returns the CStyle object of the specified cell
com.iisc.jwc.orb.CStyle	getCStyle(int idx) Returns the CStyle object for this index in the style array
com.iisc.jwc.jsheet.DataTracker	getDataTracker()
Cell	getGridSize() Shows or hides the grid lines
short	getIndex() Returns the index of this sheet in the book
short	getNameID() Returns the name id of this sheet
com.iisc.jwc.orb.CRange	getOneSelection()
com.iisc.jwc.orb.CProtection[]	getProtectionList()
com.iisc.jwc.orb.CRange[]	getSelection() Return the range for the currently selected range
JSClient	getTarget()
Range	getWorkArea()
Range	getWorkArea(boolean cached)
void	initJSheet()
boolean	isFocusable()
void	modifyObserver(com.iisc.jwc.jsheet.ObserverItems obs, com.iisc.jwc.orb.CRange range) Remove the observer managers
com.iisc.jwc.orb.CNumericStyle	newCNumericStyle(java.awt.Color negativeColor, java.lang.String customFormat, int formatType, int precision, int attr) Returns a new CNumericStyle object
void	print(java.awt.Graphics g) When printing to a postscript printer, we need double buffering to be off.
void	printSelected(java.lang.String name) Prints the selected grid sheet cells.
void	printSheet(java.lang.String name) Prints the grid sheet cells.
void	removeAllObservers(boolean clientOnly) Remove all of the observers
void	removeObserver(com.iisc.jwc.jsheet.ObserverItems obs) Remove the observer managers
void	removeProtection(com.iisc.jwc.orb.CRange[] range, java.lang.String userOrGroup, int permission)
void	setActivateObserver(boolean activate) Activate/deactivate the observer manager for this sheet
void	setActiveCell(com.iisc.jwc.orb.CCell cell) Returns the current active cell
void	setBGImage(java.awt.Image image)
void	setCellEntry(com.iisc.jwc.orb.CCell cell, java.lang.String text) Sets the text for this cell on the server
void	setCellEntry(java.lang.String text) Sets the cells value for the current cell.
void	setCellValue(com.iisc.jwc.orb.CCell cell, com.iisc.jwc.orb.CValue value) Sets the cells value.
boolean	setCStyle(com.iisc.jwc.orb.CStyle cstyle) Applys the style to the selected range
void	setFreezePaneCell(com.iisc.jwc.orb.CCell cell) Sheet Property attributes
void	setGridSize(int row, int col) Sets the maximum size of the entire grid
void	setNameID(short nmid) Sets the name id of this sheet in the book
void	setSelection(com.iisc.jwc.orb.CRange range) Sets the grid's selection range.
void	setSelection(com.iisc.jwc.orb.CRange[] ranges) Sets the grid's selection range.
void	setSelection(com.iisc.jwc.orb.CRange range, boolean clear) Sets the grid's selection range.
void	setStyle(com.iisc.jwc.orb.CStyle style) Sets the style for the current range
void	setVisibleGridLines(boolean set) Shows or hides the grid lines
void	setVisibleHeaders(boolean set) Shows or hides the grid headers
boolean	storeStyleRowCol(int nRow, int nCol, com.iisc.grid.GXStyle style, int mt, int nType) IGNORE
void	updateSheetProperties()

Methods inherited from class com.iisc.grid.GXGridCore

_canCut, _canPaste, _canPaste, _copy, _cut, _paste, calcCoverRect, canFloatCell, canMergeCell, canMergeCells, clearFloatCells, clearMergeCells, emptyRedoList, emptyUndoList, getBottomMargin, getClipboardContent, getColLabel, getColLabels, getCurColLabel, getCurRowLabel, getDraggingRectColor, getDragOffset, getFloatCellsMode, getFloatCellsPool, getFloatedCellRowCol, getFloatedCellRowCol, getGXCopyPasteImp, getGXDragDropImp, getGXFloatCellsImp, getGXMergeCellsImp, getGXPrintImp, getLeftMargin, getMergeCellsMode, getMergeCellsPool, getMergedCellRowCol, getMergedCellRowCol, getMergedCellRowCol, getRedoCount, getRedoMax, getRightMargin, getRowLabel, getRowLabels, getShowHScrollbar, getShowVScrollbar, getSpanCol, getTopMargin, getUndoCount, getUndoMax, insertCols, InsertCols, insertRows, InsertRows, invalidateRange, isMoveCells, isMoveCols, isMoveRows, lostOwnership, mergeCell, onPreparePrinting, onSelDragDrop, onSelDragMove, onSelDragStart, print, print, print, print, printSelection, redo, Redo, setBorder, setBottomMargin, setClipboard, setColLabel, setColLabels, setCover, setCurColLabel, setCurRowLabel, setDebugEnabled, setDefaultColWidth, setDefaultRowHeight, setDraggingRectColor, setFloatCellRowCol, setFloatCellsMode, setFloatedCellRowCol, setFreezePaneCell, setGXCopyPasteImp, setGXDragDropImp, setGXFloatCellsImp, setGXMergeCellsImp, setGXPrintImp, setLeftMargin, setMergeCellRowCol, setMergeCellsMode, setMergedCellRowCol, setMoveCells, setMoveCols, setMoveRows, setRedoMax, setRightMargin, setRowLabel, setRowLabels, setShowHScrollbar, setShowVScrollbar, setTopMargin, setUndoMax, uncover, undo, Undo, updateFloatedCell

Methods inherited from class com.iisc.grid.GXCore1

activateCurrentCell, addGXGridListener, applyStyleToCurrentRange, applyStyleToCurrentRange, calcRectFromRowCol, calcValidClientRowColFromPt, canSelectCurrentCell, clearSelection, deactiveCurrentCell, displayWarningText, focusGained, focusLost, getArrayWithColWidths, getArrayWithRowHeights, getAwtComponent, getCoveredCellRowCol, getCurrentCell, getCurrentCellStyle, getCursorType, getDragState, getFocusRectColor, getGXKeyListener, getGXMouseListener, getGXMouseMotionListener, getGXResizingImp, getGXSelectionImp, getInvertCurCellIfSelected, getModifiedFlag, getRangeAtRowCol, getSelectedCols, getSelectedRows, getSelectionMode, getSelectRange, getStyleRowCol, getToolTipText, getToolTipTextRowCol, getTopLeftCell, getTrackColID, getTrackColWidthMode, getTrackRowHeightMode, getTrackRowID, getValueRowCol, getWarningText, gotFocus, hasFocus, hideCols, hideRows, insertCols, insertRows, isAutoScroll, isCellBeSelected, isClickEditing, isColBeSelected, isCurrentCell, isDragCell, isDragDrop, isFocusTraversable, isReadOnly, isRowBeSelected, isSelectionEnabled, isSelectMultipleRows, isSizingOnlyHeaders, isTracking, isTrackingMove, isValidCell, lostFocus, moveCols, moveRows, moveTo, moveTo, moveToNextCell, nextCell, processGXGridEvent, registerControls, removeCols, removeGXGridListener, removeRows, removeSelectedRange, repaintRange, resizeColWidthsToFit, resizeRowHeightsToFit, scroll, scrollToView, selectCols, selectRange, selectRows, setAutoScroll, setClickEditing, setColWidth, setCoverCellsRowCol, setCurrentCell, setCurrentCell, setCurrentCellStyle, setCursor, setDefaultColWidth, setDefaultRowHeight, setDragCell, setDragDrop, setDragState, setFocusRectColor, setFrozenCols, setFrozenRows, setGXKeyListener, setGXMouseListener, setGXMouseMotionListener, setGXResizingImp, setGXSelectionImp, setInvertCurCellIfSelected, setModifiedFlag, setModifiedFlag, setProcessFocusEvent, setReadOnly, setRowHeight, setSelectionEnabled, setSelectionMode, setSelectMultipleRows, setSelectRange, setSelectRange, setSizingOnlyHeaders, setStyleRange, setStyleRange, setStyleRange, setStyleRange, setStyleRange, setStyleRange, setTopLeftCell, setTrackColID, setTrackColWidthMode, setTrackingMove, setTrackingState, setTrackRowHeightMode, setTrackRowID, setUncoverCellsRowCol, setWarningText, startAutoScroll, stopAutoScroll

Methods inherited from class com.iisc.grid.GXCore

addCover, addNotify, alphaHeading, calcCoverRect, calcRectFromRange, calcRectFromRowCol, clearCells, colHeaderStyle, composeStyleRowCol, doLayout, get3DButtons, getCellAddress, getCellChoice, getCellValue, getColCount, getColStyle, getColWidth, getControlColor, getControlDKShadowColor, getControlHighlightColor, getControlLtHighlightColor, getControlShadowColor, getControlTextColor, getCoverAt, getCoverCount, getDefaultColWidth, getDefaultRowHeight, getDrawHLine, getDrawVLine, getFrozenCols, getFrozenRows, getGridDimension, getGridLineColor, getGXCoverImp, getHAdjustable, getHeaderColor, getHeaderCols, getHeaderRows, getHeaderTextColor, getHeadingType, getHLineExtend, getHScrollbarHeight, getImage, getInsets, getLastVisibleCol, getLastVisibleRow, getLeftCol, getMarkCurCol, getMarkCurRow, getMaxLeftCol, getMaxTopRow, getMaxVisibleCols, getMaxVisibleRows, getMinimumSize, getParam, getPreferredSize, getRowCount, getRowHeight, getRowStyle, getSelectionRectColor, getShowFreezePane, getSizeLineColor, getStartCol, getStartRow, getStyleRowCol, getStyleRowCol, getTableStyle, getTopRow, getVAdjustable, getVLineExtend, getVScrollbarWidth, invalidateCell, invalidateCols, invalidateRows, invalidateTable, isBaseStyleUsed, isBorder, isCellBeCovered, isColHidden, isLockUpdate, isRowHidden, isThickFrame, isTransparentBackground, isVisibleCell, normalizeRange, registerControl, removeCover, rowHeaderStyle, set3DHeaders, setBaseStyleUsed, setBounds, setCellChoice, setCellChoice, setCellValue, setCellValue, setColCount, setColStyle, setColWidth, setControlColor, setControlDKShadowColor, setControlHighlightColor, setControlLtHighlightColor, setControlShadowColor, setControlTextColor, setCoverCellsRowCol, setDrawHLine, setDrawingTechnique, setDrawVLine, setFrozenCols, setFrozenRows, setGridLineColor, setGXCoverImp, setHeaderColor, setHeaderCols, setHeaderRows, setHeaderTextColor, setHeadingType, setImage, setLockUpdate, setMarkCurCol, setMarkCurRow, setParam, setRowCount, setRowHeight, setRowStyle, setSelectionRectColor, setShowFreezePane, setSizeLineColor, setTableStyle, setThickFrame, setTransparentBackground, setUncoverCellsRowCol, setValueRange, standardStyle, storeColWidth, storeColWidth, storeCoveredCellsRowCol, storeDefaultColWidth, storeDefaultRowHeight, storeInsertCols, storeInsertCols, storeInsertRows, storeInsertRows, storeMoveCols, storeMoveCols, storeMoveCols, storeMoveRows, storeMoveRows, storeMoveRows, storeRemoveCols, storeRemoveCols, storeRemoveRows, storeRemoveRows, storeRowHeight, storeRowHeight, storeStyleRowCol, storeStyleRowCol, unregisterControl, updateScrollbar

Methods inherited from class com.roguewave.blend.obbase.v2_0.OBBase

adjustmentValueChanged, getAlwaysShowScrollbars, getHScrollbar, getVScrollbar, hideHScrollbar, hideScrollbar, hideVScrollbar, isDoubleBuffering, paint, repaint, setAlwaysShowScrollbars, setDoubleBuffering, setHScrollbarHeight, setVScrollbarWidth, showHScrollbar, showScrollbar, showVScrollbar, update, update, update

Methods inherited from class java.awt.Panel

getAccessibleContext

Methods inherited from class java.awt.Container

add, add, add, add, add, addContainerListener, addPropertyChangeListener, addPropertyChangeListener, applyComponentOrientation, areFocusTraversalKeysSet, countComponents, deliverEvent, findComponentAt, findComponentAt, getAlignmentX, getAlignmentY, getComponent, getComponentAt, getComponentAt, getComponentCount, getComponents, getContainerListeners, getFocusTraversalKeys, getFocusTraversalPolicy, getLayout, getListeners, getMaximumSize, insets, invalidate, isAncestorOf, isFocusCycleRoot, isFocusCycleRoot, isFocusTraversalPolicySet, layout, list, list, locate, minimumSize, paintComponents, preferredSize, printComponents, remove, remove, removeAll, removeContainerListener, removeNotify, setFocusCycleRoot, setFocusTraversalKeys, setFocusTraversalPolicy, setFont, 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, contains, createImage, createImage, createVolatileImage, createVolatileImage, disable, dispatchEvent, enable, enable, enableInputMethods, getBackground, getBounds, getBounds, getColorModel, getComponentListeners, getComponentOrientation, getCursor, getDropTarget, getFocusCycleRootAncestor, getFocusListeners, getFocusTraversalKeysEnabled, getFont, getFontMetrics, getForeground, getGraphics, getGraphicsConfiguration, getHeight, getHierarchyBoundsListeners, getHierarchyListeners, getIgnoreRepaint, getInputContext, getInputMethodListeners, getInputMethodRequests, getKeyListeners, getLocale, getLocation, getLocation, getLocationOnScreen, getMouseListeners, getMouseMotionListeners, getMouseWheelListeners, getName, getParent, getPeer, getPropertyChangeListeners, getPropertyChangeListeners, getSize, getSize, getToolkit, getTreeLock, getWidth, getX, getY, gotFocus, handleEvent, hide, imageUpdate, inside, isBackgroundSet, isCursorSet, isDisplayable, isDoubleBuffered, isEnabled, isFocusOwner, isFontSet, isForegroundSet, isLightweight, isOpaque, isShowing, isValid, isVisible, keyDown, keyUp, list, list, list, location, lostFocus, mouseDown, mouseDrag, mouseEnter, mouseExit, mouseMove, mouseUp, move, nextFocus, paintAll, postEvent, prepareImage, prepareImage, printAll, remove, removeComponentListener, removeFocusListener, removeHierarchyBoundsListener, removeHierarchyListener, removeInputMethodListener, removeKeyListener, removeMouseListener, removeMouseMotionListener, removeMouseWheelListener, removePropertyChangeListener, removePropertyChangeListener, repaint, repaint, repaint, requestFocus, requestFocusInWindow, reshape, resize, resize, setBackground, setBounds, setComponentOrientation, setCursor, setDropTarget, setEnabled, setFocusable, setFocusTraversalKeysEnabled, setForeground, setIgnoreRepaint, setLocale, setLocation, setLocation, setName, setSize, setSize, setVisible, show, show, size, toString, transferFocus, transferFocusUpCycle

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

Sheet

public Sheet()

Sheet

public Sheet(com.iisc.jwc.orb.CSheet cSheet,
             JSClient target,
             com.iisc.jwc.jsheet.Book book)
      throws com.iisc.jwc.orb.CException

Initilize the Sheet

Parameters:

cSheet - the CORBA sheet object

target - the JSClient target

book - the Book object which holds this sheet

Throws:

com.iisc.jwc.orb.CException - ORB error.

Method Detail

addObserver

public com.iisc.jwc.jsheet.ObserverItems addObserver(com.iisc.jwc.orb.CRange range,
                                                     short nameID)
                                              throws com.iisc.jwc.orb.CException

Creates an Observers object for this range.

Specified by:

addObserver in interface com.iisc.jwc.jsheet.ISheet

Parameters:

range - the range to observe

Throws:

com.iisc.jwc.orb.CException - ORB error.

addObserver

public com.iisc.jwc.jsheet.ObserverItems addObserver(com.iisc.jwc.orb.CRange range,
                                                     short nameID,
                                                     boolean cacheOnServer,
                                                     int updateInterval)
                                              throws com.iisc.jwc.orb.CException

Creates an Observers object for this range.

Specified by:

addObserver in interface com.iisc.jwc.jsheet.ISheet

Parameters:

range - the range to observe

cacheOnServer - if true the server will only send values that have changed.

updateInterval - let a minimum of updateInterval seconds pass between updates of this observer.

Throws:

com.iisc.jwc.orb.CException - ORB error.

addProtection

public void addProtection(com.iisc.jwc.orb.CRange[] range,
                          java.lang.String userOrGroup,
                          int permission)
                   throws com.iisc.jwc.orb.CException

Specified by:

addProtection in interface com.iisc.jwc.jsheet.ISheet

Throws:

com.iisc.jwc.orb.CException

clearCells

public void clearCells(Range[] ranges)

clearSelectedData

public void clearSelectedData()

dragAndDrop

public void dragAndDrop(int nRow,
                        int nCol,
                        boolean isCtrlDown)

draw

public void draw(java.awt.Graphics g)

enableFeatures

public void enableFeatures()

getActiveCell

public com.iisc.jwc.orb.CCell getActiveCell()

Returns the current active cell

Specified by:

getActiveCell in interface com.iisc.jwc.jsheet.ISheet

getBook

public com.iisc.jwc.jsheet.Book getBook()

Returns the book for this sheet

getCellData

public com.iisc.jwc.orb.CCellData getCellData(Cell cell)
                                       throws com.iisc.jwc.orb.CException

Specified by:

getCellData in interface com.iisc.jwc.jsheet.ISheet

Throws:

com.iisc.jwc.orb.CException

getCellEntry

public java.lang.String getCellEntry(com.iisc.jwc.orb.CCell cell)
                              throws com.iisc.jwc.orb.CException

Returns the value of the cell at row, col.

Specified by:

getCellEntry in interface com.iisc.jwc.jsheet.ISheet

Parameters:

cell - the cell object

Throws:

com.iisc.jwc.orb.CException - ORB error.

getCellHTML

public java.lang.String getCellHTML(com.iisc.jwc.orb.CCell cell,
                                    int flags)
                             throws com.iisc.jwc.orb.CException

Returns the HTML of the cell at row, col.

Specified by:

getCellHTML in interface com.iisc.jwc.jsheet.ISheet

Parameters:

cell - the cell object

Throws:

com.iisc.jwc.orb.CException - ORB error.

getCellProtection

public int getCellProtection(com.iisc.jwc.orb.CCell cell)
                      throws com.iisc.jwc.orb.CException

Specified by:

getCellProtection in interface com.iisc.jwc.jsheet.ISheet

Throws:

com.iisc.jwc.orb.CException

getCellValue

public com.iisc.jwc.orb.CValue getCellValue(com.iisc.jwc.orb.CCell cell)
                                     throws com.iisc.jwc.orb.CException

Returns the value of the cell.

Specified by:

getCellValue in interface com.iisc.jwc.jsheet.ISheet

Parameters:

cell - the cell object

Throws:

com.iisc.jwc.orb.CException - ORB error.

getCSheet

public com.iisc.jwc.orb.CSheet getCSheet()

Returns the CORBA CSheet object

Specified by:

getCSheet in interface com.iisc.jwc.jsheet.ISheet

getCSheetView

public com.iisc.jwc.orb.CSheetView getCSheetView()

Returns the CORBA CSheetView object

Specified by:

getCSheetView in interface com.iisc.jwc.jsheet.ISheet

getCStyle

public com.iisc.jwc.orb.CStyle getCStyle(com.iisc.jwc.orb.CCell cell)
                                  throws com.iisc.jwc.orb.CException

Returns the CStyle object of the specified cell

Specified by:

getCStyle in interface com.iisc.jwc.jsheet.ISheet

Parameters:

cell - the cell object

Throws:

com.iisc.jwc.orb.CException - ORB error.

getCStyle

public com.iisc.jwc.orb.CStyle getCStyle(int idx)
                                  throws com.iisc.jwc.orb.CException

Returns the CStyle object for this index in the style array

Parameters:

idx - the index into the style array

Throws:

com.iisc.jwc.orb.CException - ORB error.

getDataTracker

public com.iisc.jwc.jsheet.DataTracker getDataTracker()

Specified by:

getDataTracker in interface com.iisc.jwc.jsheet.ISheet

getGridSize

public Cell getGridSize()

Shows or hides the grid lines

getIndex

public short getIndex()

Returns the index of this sheet in the book

Specified by:

getIndex in interface com.iisc.jwc.jsheet.ISheet

getNameID

public short getNameID()

Returns the name id of this sheet

getOneSelection

public com.iisc.jwc.orb.CRange getOneSelection()

getProtectionList

public com.iisc.jwc.orb.CProtection[] getProtectionList()
                                                 throws com.iisc.jwc.orb.CException

Specified by:

getProtectionList in interface com.iisc.jwc.jsheet.ISheet

Throws:

com.iisc.jwc.orb.CException

getSelection

public com.iisc.jwc.orb.CRange[] getSelection()

Return the range for the currently selected range

Specified by:

getSelection in interface com.iisc.jwc.jsheet.ISheet

getTarget

public JSClient getTarget()

getWorkArea

public Range getWorkArea()
                  throws com.iisc.jwc.orb.CException

Throws:

com.iisc.jwc.orb.CException

getWorkArea

public Range getWorkArea(boolean cached)
                  throws com.iisc.jwc.orb.CException

Throws:

com.iisc.jwc.orb.CException

initJSheet

public void initJSheet()

isFocusable

public boolean isFocusable()

modifyObserver

public void modifyObserver(com.iisc.jwc.jsheet.ObserverItems obs,
                           com.iisc.jwc.orb.CRange range)
                    throws com.iisc.jwc.orb.CException

Remove the observer managers

Specified by:

modifyObserver in interface com.iisc.jwc.jsheet.ISheet

Parameters:

obs - the observer items

range - the new range for the observer

Throws:

com.iisc.jwc.orb.CException - ORB error.

newCNumericStyle

public com.iisc.jwc.orb.CNumericStyle newCNumericStyle(java.awt.Color negativeColor,
                                                       java.lang.String customFormat,
                                                       int formatType,
                                                       int precision,
                                                       int attr)

Returns a new CNumericStyle object

Parameters:

negativeColor - the color for negative numbers, or null to use font color

customFormat - the background Color

formatType - the style alignment settings

precision - the numeric precision

attr - other format attributes

print

public void print(java.awt.Graphics g)

When printing to a postscript printer, we need double buffering to be off.

printSelected

public void printSelected(java.lang.String name)

Prints the selected grid sheet cells. The printed range includes the last cell containing a value.

Parameters:

name - The sheet's name.

printSheet

public void printSheet(java.lang.String name)

Prints the grid sheet cells. The printed range includes the last cell containing a value.

Parameters:

name - The sheet's name.

removeAllObservers

public void removeAllObservers(boolean clientOnly)

Remove all of the observers

Parameters:

clientOnly - server references have already been deleted, just remove client info

removeObserver

public void removeObserver(com.iisc.jwc.jsheet.ObserverItems obs)
                    throws com.iisc.jwc.orb.CException

Remove the observer managers

Specified by:

removeObserver in interface com.iisc.jwc.jsheet.ISheet

Parameters:

obs - the observer items

Throws:

com.iisc.jwc.orb.CException - ORB error.

removeProtection

public void removeProtection(com.iisc.jwc.orb.CRange[] range,
                             java.lang.String userOrGroup,
                             int permission)
                      throws com.iisc.jwc.orb.CException

Specified by:

removeProtection in interface com.iisc.jwc.jsheet.ISheet

Throws:

com.iisc.jwc.orb.CException

setActivateObserver

public void setActivateObserver(boolean activate)
                         throws com.iisc.jwc.orb.CException

Activate/deactivate the observer manager for this sheet

Specified by:

setActivateObserver in interface com.iisc.jwc.jsheet.ISheet

Parameters:

activate - true to activate, false to deactivate

Throws:

com.iisc.jwc.orb.CException - ORB error.

setActiveCell

public void setActiveCell(com.iisc.jwc.orb.CCell cell)

Returns the current active cell

Specified by:

setActiveCell in interface com.iisc.jwc.jsheet.ISheet

setBGImage

public void setBGImage(java.awt.Image image)

setCellEntry

public void setCellEntry(com.iisc.jwc.orb.CCell cell,
                         java.lang.String text)
                  throws com.iisc.jwc.orb.CException

Sets the text for this cell on the server

Specified by:

setCellEntry in interface com.iisc.jwc.jsheet.ISheet

Parameters:

cell - the cell object

text - the text to set

Throws:

com.iisc.jwc.orb.CException - ORB error.

setCellEntry

public void setCellEntry(java.lang.String text)

Sets the cells value for the current cell.

Parameters:

text - the value to set

setCellValue

public void setCellValue(com.iisc.jwc.orb.CCell cell,
                         com.iisc.jwc.orb.CValue value)
                  throws com.iisc.jwc.orb.CException

Sets the cells value.

Specified by:

setCellValue in interface com.iisc.jwc.jsheet.ISheet

Parameters:

cell - the cell object

value - the value object

Throws:

com.iisc.jwc.orb.CException - ORB error.

setCStyle

public boolean setCStyle(com.iisc.jwc.orb.CStyle cstyle)
                  throws com.iisc.jwc.orb.CException

Applys the style to the selected range

Specified by:

setCStyle in interface com.iisc.jwc.jsheet.ISheet

Parameters:

cstyle - a CStyle object containing the formatting changes

Throws:

com.iisc.jwc.orb.CException - ORB error.

setFreezePaneCell

public void setFreezePaneCell(com.iisc.jwc.orb.CCell cell)

Sheet Property attributes

setGridSize

public void setGridSize(int row,
                        int col)

Sets the maximum size of the entire grid

Parameters:

row - the largest row

col - the largest column

setNameID

public void setNameID(short nmid)

Sets the name id of this sheet in the book

setSelection

public void setSelection(com.iisc.jwc.orb.CRange range)

Sets the grid's selection range.

Specified by:

setSelection in interface com.iisc.jwc.jsheet.ISheet

Parameters:

range - the range to select

setSelection

public void setSelection(com.iisc.jwc.orb.CRange[] ranges)

Sets the grid's selection range.

Specified by:

setSelection in interface com.iisc.jwc.jsheet.ISheet

Parameters:

ranges - the ranges to select

setSelection

public void setSelection(com.iisc.jwc.orb.CRange range,
                         boolean clear)

Sets the grid's selection range.

Specified by:

setSelection in interface com.iisc.jwc.jsheet.ISheet

Parameters:

range - the range to select

clear - true to clear previous selection, false to create additional selection

setStyle

public void setStyle(com.iisc.jwc.orb.CStyle style)
              throws com.iisc.jwc.orb.CException

Sets the style for the current range

Parameters:

style - the CStyle object contain the information to change

Throws:

com.iisc.jwc.orb.CException - ORB error.

setVisibleGridLines

public void setVisibleGridLines(boolean set)

Shows or hides the grid lines

Parameters:

set - true to turn them on, false to turn them off

setVisibleHeaders

public void setVisibleHeaders(boolean set)

Shows or hides the grid headers

Parameters:

set - true to turn them on, false to turn them off

storeStyleRowCol

public boolean storeStyleRowCol(int nRow,
                                int nCol,
                                com.iisc.grid.GXStyle style,
                                int mt,
                                int nType)

IGNORE

updateSheetProperties

public void updateSheetProperties()