com.vaadin.addon.spreadsheet.client

Class SheetWidget

java.lang.Object

com.google.gwt.user.client.ui.UIObject

com.google.gwt.user.client.ui.Widget

com.google.gwt.user.client.ui.Panel

com.vaadin.addon.spreadsheet.client.SheetWidget

All Implemented Interfaces:

com.google.gwt.event.logical.shared.HasAttachHandlers, com.google.gwt.event.shared.HasHandlers, com.google.gwt.user.client.EventListener, com.google.gwt.user.client.ui.HasVisibility, com.google.gwt.user.client.ui.HasWidgets, com.google.gwt.user.client.ui.HasWidgets.ForIsWidget, com.google.gwt.user.client.ui.IsWidget, Iterable<com.google.gwt.user.client.ui.Widget>

public class SheetWidget
extends com.google.gwt.user.client.ui.Panel

Nested Class Summary

Nested classes/interfaces inherited from class com.google.gwt.user.client.ui.UIObject

com.google.gwt.user.client.ui.UIObject.DebugIdImpl, com.google.gwt.user.client.ui.UIObject.DebugIdImplEnabled

Nested classes/interfaces inherited from interface com.google.gwt.user.client.ui.HasWidgets

com.google.gwt.user.client.ui.HasWidgets.ForIsWidget

Field Summary

Fields inherited from class com.google.gwt.user.client.ui.UIObject

DEBUG_ID_PREFIX

Constructor Summary

Constructors

Constructor and Description
SheetWidget(SheetHandler view, boolean touchMode)

Method Summary

Modifier and Type	Method and Description
void	addMergedRegion(MergedRegion region)
void	addPopupButton(PopupButtonWidget popupButton)
void	addSheetOverlay(String key, SheetOverlay overlay)
void	addShiftedCellBorderStyles(List<String> styles)
void	cellValuesUpdated(ArrayList<CellData> updatedCellData)
void	clearAll(boolean removed) Clears the sheet.
protected void	clearBasicCellStyles()
protected void	clearCellCommentsAndInvalidFormulas()
void	clearCellRangeStyles() Clears the highlight (background) on selected cells and their corresponding headers.
protected void	clearMergedCells()
protected void	clearPositionStyles()
void	clearSelectedCellsOnCut()
void	clearSelectedCellStyle() Clears the light outline on the selected cell which is visible when the selection is not coherent.
protected void	clearShiftedBorderCellStyles()
void	commitComment(String text, int col, int row)
void	displayCustomCellEditor(com.google.gwt.user.client.ui.Widget customEditorWidget)
void	editCellComment(int col, int row)
void	focusSheet()
void	focusSheet(boolean doAsDeferred)
protected com.google.gwt.dom.client.Element	getBottomLeftPane()
protected com.google.gwt.dom.client.Element	getBottomRightPane()
int	getBottomVisibleRowIndex() Returns the first row index that is completely visible on the bottom.
CellData	getCellData(int column, int row)
String	getCellFormulaValue(int column, int row)
String	getCellValue(int column, int row)
protected CopyPasteTextBox.CopyPasteHandler	getCopyPasteHandler()
protected Collection<com.google.gwt.user.client.ui.Widget>	getCustomWidgetIterator()
com.google.gwt.user.client.ui.TextBox	getInlineEditor()
int	getLeftVisibleColumnIndex() Returns the first column index that is completely visible on the left.
String	getOriginalCellValue(int column, int row)
protected Cell	getRealEventTargetCell(int clientX, int clientY, Cell cell)
int	getRightVisibleColumnIndex() Returns the first column index that is completely visible on the right.
int[]	getRowHeights()
String	getRules(com.google.gwt.dom.client.StyleElement stylesheet) Clears the rules starting from the given index
int	getSelectedCellColumn()
String	getSelectedCellKey()
String	getSelectedCellLatestValue()
int	getSelectedCellRow()
int	getSelectionBottomRow()
int	getSelectionLeftCol()
int	getSelectionRightCol()
int	getSelectionTopRow()
int[]	getSheetDisplayRange()
SheetHandler	getSheetHandler()
protected SheetJsniUtil	getSheetJsniUtil()
int	getSheetScrollLeft()
int	getSheetScrollTop()
protected com.google.gwt.dom.client.Element	getTopLeftPane()
protected com.google.gwt.dom.client.Element	getTopRightPane()
int	getTopVisibleRowIndex() Returns the first row index that is completely visible on the top.
protected void	handleInputElementValueChange(boolean update)
boolean	hasFrozenColumns()
boolean	hasFrozenRows()
boolean	isAreaCompletelyVisible(int col1, int col2, int row1, int row2) Is the given area currently visible completely.
boolean	isCellCompletelyVisible(int col, int row) Is the given cell currently visible completely.
boolean	isCellLocked(int column, int row)
boolean	isCellRendered(int col, int row) Is the given cell currently rendered.
boolean	isCellRenderedInBottomLeftPane(int col, int row) Is the cell currently rendered in bottom left pane.
boolean	isCellRenderedInScrollPane(int col, int row)
boolean	isCellRenderedInTopLeftPane(int col, int row) Is the cell currently rendered in top left pane.
boolean	isCellRenderedInTopRightPane(int col, int row) Is the cell currently rendered in top right pane.
boolean	isCoherentSelection()
protected boolean	isEditingCell()
protected boolean	isEventInCustomEditorCell(com.google.gwt.user.client.Event event)
boolean	isFrozenCellRendered(int col, int row) Is the cell currently rendered in any of the frozen panes.
protected boolean	isMouseButtonDownAndSelecting()
boolean	isSelectedCellCompletelyVisible()
boolean	isSelectedCellCustomized()
boolean	isSelectedCellPergentage()
boolean	isSelectedCellRendered()
boolean	isSelectionAreaCompletelyVisible()
boolean	isSelectionRangeOutlineVisible()
boolean	isSheetElement(com.google.gwt.dom.client.Element cast)
boolean	isTouchMode()
Iterator<com.google.gwt.user.client.ui.Widget>	iterator()
protected void	onAttach()
protected void	onCellCommentFocus(CellComment cellComment)
protected void	onMouseMoveWhenSelectingCells(com.google.gwt.user.client.Event event)
protected void	onSheetMouseDown(com.google.gwt.user.client.Event event)
protected void	onSheetMouseMove(com.google.gwt.user.client.Event event)
protected void	onSheetMouseOverOrOut(com.google.gwt.user.client.Event event) This is using a delayed execution because we don't want to try to do stuff when it is unnecessary.
protected void	onSheetScroll(com.google.gwt.user.client.Event event)
void	onUnload()
void	onWidgetResize()
void	refreshAlwaysVisibleCellCommentOverlays()
void	refreshCellStyles()
void	refreshCurrentCellCommentOverlay()
void	refreshPopupButtonOverlays()
void	relayoutSheet(boolean triggerRequest)
boolean	remove(com.google.gwt.user.client.ui.Widget child)
void	removeCustomCellEditor()
void	removeMergedRegion(MergedRegion region, int ruleIndex)
void	removePopupButton(PopupButtonWidget popupButton)
void	removeSheetOverlay(String key)
void	removeShiftedCellBorderStyles()
void	removeStyles() For internal use.
void	replaceAsSelectedCells(int col1, int col2, int row1, int row2) Marks the given interval as selected (highlighted background), replaces old selected cells.
void	replaceHeadersAsSelected(int row1, int row2, int col1, int col2) Replaces the currently marked selected headers (highlighted) with the given intervals.
protected void	requestCells()
void	resetFromModel(int scrollLeft, int scrollTop) Set the model that stores the contents of the spreadsheet.
void	scrollAreaIntoView(int col1, int col2, int row1, int row2) Scrolls the sheet to show the given area, or as much of it as fits into the view.
void	scrollCellIntoView(int col, int row) Scrolls the sheet to show the given cell, then triggers escalator for updating cells if necessary.
void	scrollSelectedCellIntoView()
void	scrollSelectionAreaIntoView()
void	setCellComments(HashMap<String,String> newCellCommentsMap, HashMap<String,String> newCellCommentAuthorsMap)
void	setCellCommentVisible(boolean visible, String key)
void	setCellLinks(HashMap<String,String> cellLinksMap)
void	setCoherentSelection(boolean coherentSelection)
void	setColGroupingData(List<GroupingData> data)
void	setColGroupingInversed(boolean inversed)
void	setColGroupingMax(int max)
void	setDisplayGridlines(boolean displayGridlines)
void	setDisplayRowColHeadings(boolean displayRowColHeadings)
void	setFocused(boolean focused)
void	setHorizontalSplitPosition(int horizontalSplitPosition)
void	setInvalidFormulaCells(Set<String> newInvalidFormulaCells)
void	setInvalidFormulaMessage(String invalidFormulaMessage)
void	setRowGroupingData(List<GroupingData> data)
void	setRowGroupingInversed(boolean inversed)
void	setRowGroupingMax(int max)
void	setScrollPosition(int scrollLeft, int scrollTop)
void	setSelectedCell(int col, int row)
void	setSelectionRangeOutlineVisible(boolean visible)
void	setTouchMode(boolean touchMode)
void	setVerticalSplitPosition(int verticalSplitPosition)
void	showCustomWidgets(HashMap<String,com.google.gwt.user.client.ui.Widget> newWidgetMap)
void	startEditingCell(boolean focus, boolean recalculate, String value)
void	stopEditingCell(boolean focusSheet)
protected void	stoppedSelectingCellsWithDrag(com.google.gwt.user.client.Event event)
void	swapCellSelection(int column, int row) Swaps the selected cell to the new one, which is the selected cell after this call.
void	swapSelectedCellInsideSelection(int col, int row) Swaps the selected cell to the new one, which is the selected cell after this call.
static String	toCssKey(int col, int row) Generates css key for the cell.
static String	toKey(int col, int row) Generates classname key for the cell.
void	updateBottomLeftCellValues(List<CellData> cellData2)
void	updateBottomRightCellValues(List<CellData> cellData2)
void	updateInputValue(String value)
void	updateMergedRegionSize(MergedRegion region)
void	updateOverlayInfo(String key, OverlayInfo overlayInfo)
void	updatePopupButtonPosition(PopupButtonWidget popupButton, int oldRow, int oldCol, int newRow, int newCol) PopupButtons should not change position (cell), but the popupButton's col and row values come after the popupButton has actually been added.
void	updateSelectedCellStyles(int col1, int col2, int row1, int row2, boolean replace)
void	updateSelectedCellValue(String value)
void	updateSelectionOutline(int col1, int col2, int row1, int row2)
void	updateTopLeftCellValues(List<CellData> cellData2)
void	updateTopRightCellValues(List<CellData> cellData2)

Methods inherited from class com.google.gwt.user.client.ui.Panel

add, add, adopt, clear, doAttachChildren, doDetachChildren, orphan, remove

Methods inherited from class com.google.gwt.user.client.ui.Widget

addAttachHandler, addBitlessDomHandler, addDomHandler, addHandler, asWidget, asWidgetOrNull, createHandlerManager, delegateEvent, fireEvent, getHandlerCount, getLayoutData, getParent, isAttached, isOrWasAttached, onBrowserEvent, onDetach, onLoad, removeFromParent, setLayoutData, sinkEvents, unsinkEvents

Methods inherited from class com.google.gwt.user.client.ui.UIObject

addStyleDependentName, addStyleName, ensureDebugId, ensureDebugId, ensureDebugId, getAbsoluteLeft, getAbsoluteTop, getElement, getOffsetHeight, getOffsetWidth, getStyleElement, getStyleName, getStyleName, getStylePrimaryName, getStylePrimaryName, getTitle, isVisible, isVisible, onEnsureDebugId, removeStyleDependentName, removeStyleName, resolvePotentialElement, setElement, setElement, setHeight, setPixelSize, setSize, setStyleDependentName, setStyleName, setStyleName, setStyleName, setStyleName, setStylePrimaryName, setStylePrimaryName, setTitle, setVisible, setVisible, setWidth, sinkBitlessEvent, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface java.lang.Iterable

forEach, spliterator

Constructor Detail

SheetWidget

public SheetWidget(SheetHandler view,
                   boolean touchMode)

Method Detail

getCopyPasteHandler

protected CopyPasteTextBox.CopyPasteHandler getCopyPasteHandler()

onAttach

protected void onAttach()

Overrides:

onAttach in class com.google.gwt.user.client.ui.Widget

getSheetHandler

public SheetHandler getSheetHandler()

getSheetJsniUtil

protected SheetJsniUtil getSheetJsniUtil()

onUnload

public void onUnload()

Overrides:

onUnload in class com.google.gwt.user.client.ui.Widget

requestCells

protected void requestCells()

resetFromModel

public void resetFromModel(int scrollLeft,
                           int scrollTop)

Set the model that stores the contents of the spreadsheet. Setting model redraws the sheet.

relayoutSheet

public void relayoutSheet(boolean triggerRequest)

onWidgetResize

public void onWidgetResize()

removeStyles

public void removeStyles()

For internal use. May be removed at a later time.

onSheetScroll

protected void onSheetScroll(com.google.gwt.user.client.Event event)

onSheetMouseOverOrOut

protected void onSheetMouseOverOrOut(com.google.gwt.user.client.Event event)

This is using a delayed execution because we don't want to try to do stuff when it is unnecessary.

Parameters:

event -

onSheetMouseMove

protected void onSheetMouseMove(com.google.gwt.user.client.Event event)

isEventInCustomEditorCell

protected boolean isEventInCustomEditorCell(com.google.gwt.user.client.Event event)

getRealEventTargetCell

protected Cell getRealEventTargetCell(int clientX,
                                      int clientY,
                                      Cell cell)

onSheetMouseDown

protected void onSheetMouseDown(com.google.gwt.user.client.Event event)

Parameters:

event - The original event (that can be onClick or onTouchStart)

onMouseMoveWhenSelectingCells

protected void onMouseMoveWhenSelectingCells(com.google.gwt.user.client.Event event)

stoppedSelectingCellsWithDrag

protected void stoppedSelectingCellsWithDrag(com.google.gwt.user.client.Event event)

isEditingCell

protected boolean isEditingCell()

isMouseButtonDownAndSelecting

protected boolean isMouseButtonDownAndSelecting()

getCellData

public CellData getCellData(int column,
                            int row)

getCellValue

public String getCellValue(int column,
                           int row)

isCellLocked

public boolean isCellLocked(int column,
                            int row)

getCellFormulaValue

public String getCellFormulaValue(int column,
                                  int row)

getOriginalCellValue

public String getOriginalCellValue(int column,
                                   int row)

getRules

public String getRules(com.google.gwt.dom.client.StyleElement stylesheet)

Clears the rules starting from the given index

getInlineEditor

public com.google.gwt.user.client.ui.TextBox getInlineEditor()

isSelectedCellCustomized

public boolean isSelectedCellCustomized()

showCustomWidgets

public void showCustomWidgets(HashMap<String,com.google.gwt.user.client.ui.Widget> newWidgetMap)

addSheetOverlay

public void addSheetOverlay(String key,
                            SheetOverlay overlay)

updateOverlayInfo

public void updateOverlayInfo(String key,
                              OverlayInfo overlayInfo)

removeSheetOverlay

public void removeSheetOverlay(String key)

addMergedRegion

public void addMergedRegion(MergedRegion region)

updateMergedRegionSize

public void updateMergedRegionSize(MergedRegion region)

removeMergedRegion

public void removeMergedRegion(MergedRegion region,
                               int ruleIndex)

setCellLinks

public void setCellLinks(HashMap<String,String> cellLinksMap)

setInvalidFormulaCells

public void setInvalidFormulaCells(Set<String> newInvalidFormulaCells)

setCellComments

public void setCellComments(HashMap<String,String> newCellCommentsMap,
                            HashMap<String,String> newCellCommentAuthorsMap)

setCellCommentVisible

public void setCellCommentVisible(boolean visible,
                                  String key)

refreshAlwaysVisibleCellCommentOverlays

public void refreshAlwaysVisibleCellCommentOverlays()

refreshCurrentCellCommentOverlay

public void refreshCurrentCellCommentOverlay()

refreshPopupButtonOverlays

public void refreshPopupButtonOverlays()

onCellCommentFocus

protected void onCellCommentFocus(CellComment cellComment)

updateBottomRightCellValues

public void updateBottomRightCellValues(List<CellData> cellData2)

updateTopLeftCellValues

public void updateTopLeftCellValues(List<CellData> cellData2)

updateTopRightCellValues

public void updateTopRightCellValues(List<CellData> cellData2)

updateBottomLeftCellValues

public void updateBottomLeftCellValues(List<CellData> cellData2)

cellValuesUpdated

public void cellValuesUpdated(ArrayList<CellData> updatedCellData)

getRowHeights

public int[] getRowHeights()

handleInputElementValueChange

protected void handleInputElementValueChange(boolean update)

toKey

public static final String toKey(int col,
                                 int row)

Generates classname key for the cell.

Parameters:

col - column index, 1 based

row - row index, 1 based

Returns:

key

toCssKey

public static final String toCssKey(int col,
                                    int row)

Generates css key for the cell.

Parameters:

col - column index, 1 based

row - row index, 1 based

Returns:

key

clearAll

public void clearAll(boolean removed)

Clears the sheet. After this no headers or cells are visible.

Parameters:

removed - if the widget is completely removed from DOM after this

getSelectedCellKey

public String getSelectedCellKey()

getSelectedCellColumn

public int getSelectedCellColumn()

getSelectedCellRow

public int getSelectedCellRow()

getSelectedCellLatestValue

public String getSelectedCellLatestValue()

setSelectedCell

public void setSelectedCell(int col,
                            int row)

getSelectionLeftCol

public int getSelectionLeftCol()

getSelectionRightCol

public int getSelectionRightCol()

getSelectionTopRow

public int getSelectionTopRow()

getSelectionBottomRow

public int getSelectionBottomRow()

isCoherentSelection

public boolean isCoherentSelection()

setCoherentSelection

public void setCoherentSelection(boolean coherentSelection)

setSelectionRangeOutlineVisible

public void setSelectionRangeOutlineVisible(boolean visible)

isSelectionRangeOutlineVisible

public boolean isSelectionRangeOutlineVisible()

updateSelectionOutline

public void updateSelectionOutline(int col1,
                                   int col2,
                                   int row1,
                                   int row2)

updateSelectedCellStyles

public void updateSelectedCellStyles(int col1,
                                     int col2,
                                     int row1,
                                     int row2,
                                     boolean replace)

clearSelectedCellStyle

public void clearSelectedCellStyle()

Clears the light outline on the selected cell which is visible when the selection is not coherent.

clearCellRangeStyles

public void clearCellRangeStyles()

Clears the highlight (background) on selected cells and their corresponding headers.

clearPositionStyles

protected void clearPositionStyles()

clearBasicCellStyles

protected void clearBasicCellStyles()

clearShiftedBorderCellStyles

protected void clearShiftedBorderCellStyles()

clearMergedCells

protected void clearMergedCells()

clearCellCommentsAndInvalidFormulas

protected void clearCellCommentsAndInvalidFormulas()

swapCellSelection

public void swapCellSelection(int column,
                              int row)

Swaps the selected cell to the new one, which is the selected cell after this call. The old cell is "highlighted" and the new one gets the selected cell outline (when selection range outline is hidden). Takes care of swapping into a merged cell (highlights correct all cell headers).

Parameters:

column - index, 1-based

row - index, 1-based

swapSelectedCellInsideSelection

public void swapSelectedCellInsideSelection(int col,
                                            int row)

Swaps the selected cell to the new one, which is the selected cell after this call. The old cell is "highlighted" and the new selected cell will be marked as selected. This method is different to swapCellSelection(int, int) because the selected cell should be inside the old selection, instead of adding a new cell into the selection. No need to modify highlighted headers.

Parameters:

col - column index, 1-based

row - row index, 1-based

replaceAsSelectedCells

public void replaceAsSelectedCells(int col1,
                                   int col2,
                                   int row1,
                                   int row2)

Marks the given interval as selected (highlighted background), replaces old selected cells. Ignores the currently selected cell.

Parameters:

col1 - starting column index, 1-based

col2 - ending column index, 1-based

row1 - starting row index, 1-based

row2 - ending row index, 1-based

replaceHeadersAsSelected

public void replaceHeadersAsSelected(int row1,
                                     int row2,
                                     int col1,
                                     int col2)

Replaces the currently marked selected headers (highlighted) with the given intervals.

Parameters:

row1 - starting row index, 1-based

row2 - ending row index, 1-based

col1 - starting column index, 1-based

col2 - ending column index, 1-based

getSheetDisplayRange

public int[] getSheetDisplayRange()

hasFrozenColumns

public boolean hasFrozenColumns()

hasFrozenRows

public boolean hasFrozenRows()

getLeftVisibleColumnIndex

public int getLeftVisibleColumnIndex()

Returns the first column index that is completely visible on the left.

Returns:

index

getRightVisibleColumnIndex

public int getRightVisibleColumnIndex()

Returns the first column index that is completely visible on the right.

Returns:

index

getTopVisibleRowIndex

public int getTopVisibleRowIndex()

Returns the first row index that is completely visible on the top.

Returns:

index

getBottomVisibleRowIndex

public int getBottomVisibleRowIndex()

Returns the first row index that is completely visible on the bottom.

Returns:

index

displayCustomCellEditor

public void displayCustomCellEditor(com.google.gwt.user.client.ui.Widget customEditorWidget)

removeCustomCellEditor

public void removeCustomCellEditor()

startEditingCell

public void startEditingCell(boolean focus,
                             boolean recalculate,
                             String value)

updateSelectedCellValue

public void updateSelectedCellValue(String value)

updateInputValue

public void updateInputValue(String value)

stopEditingCell

public void stopEditingCell(boolean focusSheet)

focusSheet

public void focusSheet()

focusSheet

public void focusSheet(boolean doAsDeferred)

isSelectedCellRendered

public boolean isSelectedCellRendered()

isSelectedCellCompletelyVisible

public boolean isSelectedCellCompletelyVisible()

isSelectionAreaCompletelyVisible

public boolean isSelectionAreaCompletelyVisible()

isCellRenderedInScrollPane

public boolean isCellRenderedInScrollPane(int col,
                                          int row)

isFrozenCellRendered

public boolean isFrozenCellRendered(int col,
                                    int row)

Is the cell currently rendered in any of the frozen panes.

Parameters:

col - column index, 1-based

row - row index, 1-based

Returns:

true if rendered within a frozen pane, false otherwise

isCellRenderedInTopLeftPane

public boolean isCellRenderedInTopLeftPane(int col,
                                           int row)

Is the cell currently rendered in top left pane.

Parameters:

col - column index, 1-based

row - row index, 1-based

Returns:

true if rendered within top left pane, false otherwise

isCellRenderedInTopRightPane

public boolean isCellRenderedInTopRightPane(int col,
                                            int row)

Is the cell currently rendered in top right pane.

Parameters:

col - column index, 1-based

row - row index, 1-based

Returns:

true if rendered within top right pane, false otherwise

isCellRenderedInBottomLeftPane

public boolean isCellRenderedInBottomLeftPane(int col,
                                              int row)

Is the cell currently rendered in bottom left pane.

Parameters:

col - column index, 1-based

row - row index, 1-based

Returns:

true if rendered within bottom left pane, false otherwise

isCellRendered

public boolean isCellRendered(int col,
                              int row)

Is the given cell currently rendered. Checks freeze panes too.

Parameters:

col - column index, 1-based

row - row index, 1-based

Returns:

true if rendered, false otherwise

isCellCompletelyVisible

public boolean isCellCompletelyVisible(int col,
                                       int row)

Is the given cell currently visible completely. Checks freeze panes too.

Parameters:

col - column index, 1-based

row - row index, 1-based

Returns:

true if completely visible, false otherwise

isAreaCompletelyVisible

public boolean isAreaCompletelyVisible(int col1,
                                       int col2,
                                       int row1,
                                       int row2)

Is the given area currently visible completely. Checks freeze panes too.

Parameters:

col1 - starting column index, 1-based

col2 - ending column index, 1-based

row1 - starting row index, 1-based

row2 - ending row index, 1-based

Returns:

true if completely visible, false otherwise

scrollSelectedCellIntoView

public void scrollSelectedCellIntoView()

scrollCellIntoView

public void scrollCellIntoView(int col,
                               int row)

Scrolls the sheet to show the given cell, then triggers escalator for updating cells if necessary. This method does the isCellRenderedInScrollPane(int, int) in itself, so no need to do the check before calling this. Nothing is done if the cell is already visible. Scrolls one cell extra to all directions to cut the scrolls to half when using keyboard navigation.

Parameters:

col - column index, 1-based

row - row index, 1-based

scrollSelectionAreaIntoView

public void scrollSelectionAreaIntoView()

scrollAreaIntoView

public void scrollAreaIntoView(int col1,
                               int col2,
                               int row1,
                               int row2)

Scrolls the sheet to show the given area, or as much of it as fits into the view.

Parameters:

col1 - starting column index, 1-based

col2 - ending column index, 1-based

row1 - starting row index, 1-based

row2 - ending row index, 1-based

addShiftedCellBorderStyles

public void addShiftedCellBorderStyles(List<String> styles)

removeShiftedCellBorderStyles

public void removeShiftedCellBorderStyles()

getSheetScrollLeft

public int getSheetScrollLeft()

getSheetScrollTop

public int getSheetScrollTop()

setScrollPosition

public void setScrollPosition(int scrollLeft,
                              int scrollTop)

addPopupButton

public void addPopupButton(PopupButtonWidget popupButton)

removePopupButton

public void removePopupButton(PopupButtonWidget popupButton)

updatePopupButtonPosition

public void updatePopupButtonPosition(PopupButtonWidget popupButton,
                                      int oldRow,
                                      int oldCol,
                                      int newRow,
                                      int newCol)

PopupButtons should not change position (cell), but the popupButton's col and row values come after the popupButton has actually been added.

iterator

public Iterator<com.google.gwt.user.client.ui.Widget> iterator()

getCustomWidgetIterator

protected Collection<com.google.gwt.user.client.ui.Widget> getCustomWidgetIterator()

remove

public boolean remove(com.google.gwt.user.client.ui.Widget child)

Specified by:

remove in interface com.google.gwt.user.client.ui.HasWidgets

Specified by:

remove in class com.google.gwt.user.client.ui.Panel

setDisplayGridlines

public void setDisplayGridlines(boolean displayGridlines)

setDisplayRowColHeadings

public void setDisplayRowColHeadings(boolean displayRowColHeadings)

setVerticalSplitPosition

public void setVerticalSplitPosition(int verticalSplitPosition)

setHorizontalSplitPosition

public void setHorizontalSplitPosition(int horizontalSplitPosition)

getBottomRightPane

protected com.google.gwt.dom.client.Element getBottomRightPane()

getBottomLeftPane

protected com.google.gwt.dom.client.Element getBottomLeftPane()

getTopRightPane

protected com.google.gwt.dom.client.Element getTopRightPane()

getTopLeftPane

protected com.google.gwt.dom.client.Element getTopLeftPane()

isSheetElement

public boolean isSheetElement(com.google.gwt.dom.client.Element cast)

clearSelectedCellsOnCut

public void clearSelectedCellsOnCut()

refreshCellStyles

public void refreshCellStyles()

isTouchMode

public boolean isTouchMode()

setTouchMode

public void setTouchMode(boolean touchMode)

editCellComment

public void editCellComment(int col,
                            int row)

commitComment

public void commitComment(String text,
                          int col,
                          int row)

isSelectedCellPergentage

public boolean isSelectedCellPergentage()

setFocused

public void setFocused(boolean focused)

setColGroupingData

public void setColGroupingData(List<GroupingData> data)

setRowGroupingData

public void setRowGroupingData(List<GroupingData> data)

setColGroupingMax

public void setColGroupingMax(int max)

setRowGroupingMax

public void setRowGroupingMax(int max)

setColGroupingInversed

public void setColGroupingInversed(boolean inversed)

setRowGroupingInversed

public void setRowGroupingInversed(boolean inversed)

setInvalidFormulaMessage

public void setInvalidFormulaMessage(String invalidFormulaMessage)