Spreadsheet (Keikai Spreadsheet Build 5.0.0 API)

java.lang.Object
- org.zkoss.zk.ui.AbstractComponent
- - org.zkoss.zk.ui.HtmlBasedComponent
  - - org.zkoss.zul.impl.XulElement
    - - io.keikai.ui.Spreadsheet

All Implemented Interfaces:

Serializable, Cloneable, org.zkoss.zk.ui.Component, org.zkoss.zk.ui.ext.AfterCompose, org.zkoss.zk.ui.ext.Scope, org.zkoss.zk.ui.sys.ComponentCtrl
```
public class Spreadsheet
extends org.zkoss.zul.impl.XulElement
implements Serializable, org.zkoss.zk.ui.ext.AfterCompose
```
Spreadsheet is a rich ZK Component to handle EXCEL like behavior, it reads the data from a data model(SBook) and interact with this model by event.
You can assign a Book by #setBook(SBook) or just set the .xls file location by setSrc(String). You can also set two attributes to restrict max rows and columns to show on client side by setMaxVisibleRows(int) and setMaxVisibleColumns(int).
To use Spreadsheet in .zul file, just use <spreadsheet/> tag like any other ZK Components.
An simplest example :
;<spreadsheet src= "/WEB-INF/xls/my.xls" maxrows="300" maxcolumns="80"
height="400px" width="90%" />

Author:

dennischen

See Also:

Serialized Form

Nested Class Summary

Nested Classes
Modifier and Type Class and Description

class Spreadsheet.HelperContainer<T>
- Nested classes/interfaces inherited from class org.zkoss.zk.ui.AbstractComponent
  org.zkoss.zk.ui.AbstractComponent.Children

Nested Classes
Modifier and Type	Class and Description
`class`	`Spreadsheet.HelperContainer<T>`

Field Summary
- Fields inherited from class org.zkoss.zk.ui.HtmlBasedComponent
  _zclass
- Fields inherited from interface org.zkoss.zk.ui.Component
  APPLICATION_SCOPE, COMPONENT_SCOPE, DESKTOP_SCOPE, PAGE_SCOPE, REQUEST_SCOPE, SESSION_SCOPE, SPACE_SCOPE
- Fields inherited from interface org.zkoss.zk.ui.sys.ComponentCtrl
  AFTER_CHILD_ADDED, AFTER_CHILD_REMOVED, AFTER_PAGE_ATTACHED, AFTER_PAGE_DETACHED, CE_BUSY_IGNORE, CE_DUPLICATE_IGNORE, CE_IMPORTANT, CE_NON_DEFERRABLE, CE_REPEAT_IGNORE

Constructor Summary

Constructors
Constructor and Description

Spreadsheet()

Constructors
Constructor and Description
`Spreadsheet()`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods
Modifier and Type	Method and Description
`void`	`addToolbarButton(int index, ToolbarButton btn)` Inserts the specified button at the specified position in the buttons list.
`boolean`	`addToolbarButton(ToolbarButton btn)` Adds toolbar button to the end of the buttons.
`void`	`afterCompose()`
`void`	`clearClientCache(SSheet sheet)` Call this method to clear client side cache for a Sheet and fine tune data loading speed.
`void`	`disableUserAction(AuxAction action, boolean disabled)` Sets the `AuxAction` disabled
`void`	`focus()` Retrieve client side spreadsheet focus.The cell focus and selection will keep at last status.
`void`	`focusTo(int row, int column)` Retrieve client side spreadhsheet focus, move cell focus to position (row,column) and also scroll the cell to into visible view.
`Book`	`getBook()` Returns the book model of this Spreadsheet.
`CellRef`	`getCellFocus()` Return current cell(row,column) focus position.
`int`	`getColumnfreeze()` Deprecated. since 3.0.0, use `Sheet.getColumnFreeze()` instead.
`String`	`getColumntitle(int index)` Get Column title of given index, it returns column name depends on following condition 1.if there is a custom column title assign on this spreadsheet on index, then return custom value 2.if there is a custom column title assign on selected sheet on index, the return custom value 3.return default column String, for example index 0 become "A", index 9 become "J"
`Map`	`getColumntitles()` Get the column titles Map object, modification of return object doesn't cause any update.
`int`	`getColumnwidth()` Gets the default column width of the selected sheet
`int`	`getCurrentMaxVisibleColumns()` Returns the maximum visible number of columns of the currently selected sheet.
`int`	`getCurrentMaxVisibleRows()` Returns the maximum visible number of rows of the currently selected sheet.
`Object`	`getExtraCtrl()`
`AreaRef`	`getHighlight()` Return current highlight rectangle.
`Importer`	`getImporter()` Gets the importer that import the file in the specified src ( `getSrc()`) to `Book` data model.
`int`	`getLeftheadwidth()` Gets the left head panel width
`int`	`getMaxcolumns()` Deprecated. since 3.0.0, use `#getMaxVisibleColumns()`
`int`	`getMaxRenderedCellSize()` Returns the max rendered cell size
`int`	`getMaxrows()` Deprecated. since 3.0.0, use `#getMaxVisibleRows()`
`int`	`getMaxVisibleColumns()` Returns the maximum visible number of columns of this spreadsheet.
`int`	`getMaxVisibleRows()` Returns the maximum visible number of rows of this spreadsheet.
`int`	`getPreloadColumnSize()`
`int`	`getPreloadRowSize()`
`int`	`getRowfreeze()` Deprecated. since 3.0.0, use `Sheet.getRowFreeze()` instead.
`int`	`getRowheight()` Gets the default row height of the selected sheet
`String`	`getRowtitle(int index)` Get Row title of given index, it returns row name depends on following condition 1.if there is a custom row title assign on this spreadsheet on index, then return custom value 2.if there is a custom row title assign on selected sheet on index, the return custom value 3.return default row index+1 String, for example index 0 become "1", index 9 become "10"
`Map`	`getRowtitles()` Get the row titles Map object, modification of the return object doesn't cause any update.
`SBook`	`getSBook()` Returns the book model of this Spreadsheet.
`Sheet`	`getSelectedSheet()` Gets the selected sheet, the default selected sheet is first sheet.
`String`	`getSelectedSheetName()`
`SSheet`	`getSelectedSSheet()` Gets the selected sheet, the default selected sheet is first sheet.
`SSheet`	`getSelectedXSheet()` Deprecated. since 3.0.0 , use `getSelectedSheet()`
`AreaRef`	`getSelection()` Return current selection rectangle only if onCellSelection event listener is registered.
`int`	`getSheetMaxVisibleColumns(SSheet sheet)` Returns the max visible columns of the specified sheet
`int`	`getSheetMaxVisibleRows(SSheet sheet)` Returns the max visible rows of the specified sheet
`SImporter`	`getSImporter()` Deprecated. since 3.0.0 , use `getImporter()`
`String`	`getSrc()` Returns the src location of book model.
`List<ToolbarButton>`	`getToolbarButtons()` Returns all toolbar buttons (read only).
`int`	`getTopheadheight()` Gets the top head panel height
`UndoableActionManager`	`getUndoableActionManager()`
`UserActionManager`	`getUserActionManager()` Gets the user action manager, then you can register/override your custom action by call `UserActionManager.registerHandler(String, String, UserActionHandler)`
`SBook`	`getXBook()` Deprecated. since 3.0.0 , use `getBook()`
`boolean`	`insertBefore(org.zkoss.zk.ui.Component newChild, org.zkoss.zk.ui.Component refChild)`
`void`	`invalidate()`
`protected boolean`	`isCleanBookAutomatically()`
`boolean`	`isClientCacheDisabled()` Returns whether client cache disabled or not
`boolean`	`isHidecolumnhead()` Returns true if hide column head of this spread sheet; default to false.
`boolean`	`isHiderowhead()` Returns true if hide row head of this spread sheet; default to false.
`static boolean`	`isIE9()`
`boolean`	`isKeepCellSelection()` Returns true if keep the cell selection box when lost focus; default to false.
`boolean`	`isShowAddColumn()` Returns whether show the add column button in sheetbar.
`boolean`	`isShowAddRow()` Returns whether show the add row button in sheetbar.
`boolean`	`isShowFormulabar()` Returns whether show formula bar
`boolean`	`isShowSheetbar()` Returns whether show sheetbar
`boolean`	`isShowSheetTabContextMenu()` Returns whether show ContextMenu in sheet tab
`boolean`	`isShowToolbar()` Returns whether shows toolbar
`void`	`moveEditorFocus(String id, String name, String color, int row, int col)` Add and move other editor's focus
`protected Object`	`newExtraCtrl()` Return a extra controller.
`void`	`notifyLoadedAreaChange()` NotifyChange the currently loaded area and freeze area if exists.
`void`	`notifyVisibleAreaChange()` NotifyChange the currently visible area and freeze area if exists.
`void`	`onPageAttached(org.zkoss.zk.ui.Page newpage, org.zkoss.zk.ui.Page oldpage)`
`void`	`onPageDetached(org.zkoss.zk.ui.Page page)`
`static Object[]`	`parseLinkAddress(Book book, String linkAddress)`
`void`	`removeEditorFocus(String id)` Remove editor's focus on specified name
`boolean`	`removeToolbarButton(int index)` Removes the button at the specified position in this buttons list.
`boolean`	`removeToolbarButton(String key)` Removes the first occurrence of the given key in the buttons list.
`boolean`	`removeToolbarButton(ToolbarButton btn)` Removes the first occurrence of the given button instance in the buttons list.
`protected void`	`renderProperties(org.zkoss.zk.ui.sys.ContentRenderer renderer)`
`protected void`	`renderProperties0(org.zkoss.zk.ui.sys.ContentRenderer renderer)`
`void`	`response(String key, org.zkoss.zk.au.AuResponse response)`
`void`	`service(org.zkoss.zk.au.AuRequest request, boolean everError)` Processes an AU request.
`void`	`setBook(Book book)` Sets the book data model of this spread sheet.
`void`	`setCellFocus(CellRef focus)` Sets the cell focus position.(this method doesn't focus the spreadsheet.) In general, if you set a cell focus, you also set the selection by `setSelection(AreaRef)`; And if you want to get the focus back to spreadsheet, call `focus()` to retrieve focus.
`void`	`setClientCacheDisabled(boolean clientCacheDisabled)` Sets to disable client cache.
`void`	`setColumnfreeze(int colfreeze)` Deprecated. since 3.0.0, use `Range.setFreezePanel(int, int)` instead.
`void`	`setColumntitles(Map titles)` Sets the customized titles of column header.
`void`	`setColumntitles(String titles)` Sets the customized titles which split by ','.
`void`	`setColumnwidth(int columnWidth)` Sets the default column width of the selected sheet
`void`	`setCtrlKeys(String ctrlKeys)`
`void`	`setDraggable(String draggable)` Don't call this, the spreadsheet is not draggable.
`void`	`setHidecolumnhead(boolean hide)` Sets true to hide the column head of this spread sheet.
`void`	`setHiderowhead(boolean hide)` Sets true to hide the row head of this spread sheet.
`void`	`setHighlight(AreaRef highlight)` Sets the highlight rectangle or sets a null value to hide it.
`void`	`setIgnoreAutoHeight(boolean b)` Whether ignore row's autoHeight calculation.
`void`	`setImporter(Importer importer)` Sets the importer for import the book data model from a specified src.
`void`	`setKeepCellSelection(boolean keep)` Sets true to keep the cell selection box when lost focus.
`void`	`setLeftheadwidth(int leftWidth)` Sets the left head panel width, must large then 0.
`void`	`setMaxcolumns(int maxcols)` Deprecated. since 3.0.0, use `#setMaxVisibleColumns(int)`
`void`	`setMaxRenderedCellSize(int maxRenderedCellSize)` Sets the max rendered cell size.
`void`	`setMaxrows(int maxrows)` Deprecated. since 3.0.0, use `#setMaxVisibleRows(int)`
`void`	`setMaxVisibleColumns(int maxcols)` Sets the maximum visible number of columns of this spreadsheet.
`void`	`setMaxVisibleRows(int maxrows)` Sets the maximum visible number of rows of this spreadsheet.
`void`	`setPreloadColumnSize(int size)`
`void`	`setPreloadRowSize(int size)`
`void`	`setRowfreeze(int rowfreeze)` Deprecated. since 3.0.0, use `Range.setFreezePanel(int, int)` instead.
`void`	`setRowheight(int rowHeight)` Sets the default row height of the selected sheet
`void`	`setRowtitles(Map titles)` Sets the customized titles of row header.
`void`	`setRowtitles(String titles)` Sets the customized titles which split by ','.
`void`	`setSBook(SBook book)` Sets the book data model of this spread sheet.
`void`	`setSelectedSheet(String name)` Sets the selected sheet by a name
`void`	`setSelection(AreaRef sel)` Sets the selection rectangle.
`void`	`setSheetMaxVisibleColumns(SSheet sheet, int maxColumns)` Sets the max visibles columns of the specified sheet.
`void`	`setSheetMaxVisibleRows(SSheet sheet, int maxRows)` Sets the max visible rows of the specified sheet
`void`	`setShowAddColumn(boolean showAddColumn)` Sets whether show the add column button in sheetbar.
`void`	`setShowAddRow(boolean showAddRow)` Sets whether show the add row button in sheetbar.
`void`	`setShowContextMenu(boolean showContextMenu)` Sets whether show ContextMenu or not
`void`	`setShowFormulabar(boolean showFormulabar)` Sets whether show formula bar or not
`void`	`setShowSheetbar(boolean showSheetbar)` Sets whether show sheetbar or not
`void`	`setShowSheetTabContextMenu(boolean showSheetTabContextMenu)` Sets whether show ContextMenu or not
`void`	`setShowToolbar(boolean showToolbar)` Sets whether show toolbar or not Default: false
`void`	`setSImporter(SImporter importer)` Deprecated. since 3.0.0 , use `setImporter(Importer)`
`void`	`setSrc(String src)` Sets the src location of the book data model to be imported into spreadsheet.
`void`	`setTopheadheight(int topHeight)` Sets the top head panel height, must large then 0.
`void`	`setUserName(String name)` Set focus name of this spreadsheet.
`void`	`setXBook(SBook book)` Deprecated. since 3.0.0 , use `setBook(Book)`
`void`	`smartUpdate(String attr, Object value)`
`void`	`smartUpdate(String attr, Object value, boolean append)`

Methods inherited from class org.zkoss.zul.impl.XulElement
clone, getContext, getCtrlKeys, getPopup, getPropertyAccess, getTooltip, setContext, setContext, setContextAttributes, setPopup, setPopup, setPopupAttributes, setTooltip, setTooltip, setTooltipAttributes

Methods inherited from class org.zkoss.zk.ui.HtmlBasedComponent
addSclass, evalCSSFlex, getAction, getDraggable, getDroppable, getHeight, getHflex, getLeft, getRenderdefer, getSclass, getStyle, getTabindex, getTabindexInteger, getTooltiptext, getTop, getVflex, getWidth, getZclass, getZindex, getZIndex, removeSclass, removeSclass, setAction, setClass, setDroppable, setFocus, setHeight, setHeight0, setHeightDirectly, setHflex, setHflex0, setHflexDirectly, setLeft, setLeftDirectly, setRenderdefer, setSclass, setStyle, setTabindex, setTabindex, setTooltiptext, setTop, setTopDirectly, setVflex, setVflex0, setVflexDirectly, setWidth, setWidth0, setWidthDirectly, setZclass, setZindex, setZIndex, setZIndexDirectly

Methods inherited from class org.zkoss.zk.ui.AbstractComponent
addAnnotation, addAnnotation, addCallback, addClientEvent, addEventHandler, addEventListener, addEventListener, addForward, addForward, addForward, addForward, addMoved, addRedrawCallback, addScopeListener, addShadowRoot, addShadowRootBefore, addSharedEventHandlerMap, appendChild, applyProperties, beforeChildAdded, beforeChildRemoved, beforeParentChanged, detach, didActivate, didActivate, didDeserialize, didDeserialize, disableBindingAnnotation, disableClientUpdate, enableBindingAnnotation, getAnnotatedProperties, getAnnotatedPropertiesBy, getAnnotation, getAnnotation, getAnnotations, getAnnotations, getAnnotations, getAttribute, getAttribute, getAttribute, getAttributeOrFellow, getAttributes, getAttributes, getAuService, getAutag, getCallback, getChildren, getClientAttribute, getClientDataAttribute, getClientEvents, getDefaultMold, getDefinition, getDesktop, getEventHandler, getEventHandlerNames, getEventListenerMap, getEventListeners, getFellow, getFellow, getFellowIfAny, getFellowIfAny, getFellows, getFirstChild, getId, getLastChild, getListenerIterator, getMold, getNextSibling, getPage, getParent, getPreviousSibling, getRedrawCallback, getRoot, getShadowFellowIfAny, getShadowRoots, getShadowVariable, getShadowVariable, getShadowVariable0, getSpaceOwner, getSpecialRendererOutput, getStubonly, getSubBindingAnnotationCount, getTemplate, getTemplateNames, getUuid, getWidgetAttribute, getWidgetAttributeNames, getWidgetClass, getWidgetListener, getWidgetListenerNames, getWidgetOverride, getWidgetOverrideNames, hasAttribute, hasAttribute, hasAttribute, hasAttributeOrFellow, hasBindingAnnotation, hasFellow, hasFellow, hasSubBindingAnnotation, invalidatePartial, isChildable, isInvalidated, isListenerAvailable, isVisible, onChildAdded, onChildRemoved, onWrongValue, query, queryAll, redraw, redrawChildren, removeAttribute, removeAttribute, removeAttribute, removeCallback, removeChild, removeEventListener, removeForward, removeForward, removeRedrawCallback, removeScopeListener, removeShadowRoot, render, render, render, replace, response, response, service, sessionDidActivate, sessionWillPassivate, setAttribute, setAttribute, setAttribute, setAuService, setAutag, setClientAttribute, setClientDataAttribute, setDefinition, setDefinition, setId, setMold, setPage, setPageBefore, setParent, setStubonly, setStubonly, setSubBindingAnnotationCount, setTemplate, setVisible, setVisibleDirectly, setWidgetAttribute, setWidgetClass, setWidgetListener, setWidgetOverride, smartUpdate, smartUpdate, smartUpdate, smartUpdate, smartUpdate, smartUpdate, smartUpdate, smartUpdateWidgetListener, smartUpdateWidgetOverride, toString, updateByClient, updateSubBindingAnnotationCount, willPassivate, willPassivate, willSerialize, willSerialize

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

- Constructor Detail
  - Spreadsheet
```
public Spreadsheet()
```
- Method Detail
  - getUserActionManager
```
public UserActionManager getUserActionManager()
```
    Gets the user action manager, then you can register/override your custom action by call UserActionManager.registerHandler(String, String, UserActionHandler)
    
    Returns:
    
    UserActionManager or null if doesn't support to override
    
    Since:
    
    3.0.0
  - setCtrlKeys
```
public void setCtrlKeys(String ctrlKeys)
```
    Overrides:
    
    setCtrlKeys in class org.zkoss.zul.impl.XulElement
  - setMaxRenderedCellSize
```
public void setMaxRenderedCellSize(int maxRenderedCellSize)
```
    Sets the max rendered cell size. When rendered cell size greater then this limit, client side will prune extra cells (DOM Element).
    
    Parameters:
    
    maxRenderedCellSize -
  - getMaxRenderedCellSize
```
public int getMaxRenderedCellSize()
```
    Returns the max rendered cell size
    
    Returns:
    
    int maxRenderedCellSize
  - isClientCacheDisabled
```
public boolean isClientCacheDisabled()
```
    Returns whether client cache disabled or not
    
    Returns:
  - setClientCacheDisabled
```
public void setClientCacheDisabled(boolean clientCacheDisabled)
```
    Sets to disable client cache. Default is false
    
    Parameters:
    
    clientCacheDisabled -
  - setDraggable
```
public void setDraggable(String draggable)
```
    Don't call this, the spreadsheet is not draggable.
    
    Overrides:
    
    setDraggable in class org.zkoss.zk.ui.HtmlBasedComponent
    
    Throws:
    
    UnsupportedOperationException - if this method is called.
  - getXBook
```
public SBook getXBook()
```
    Deprecated. since 3.0.0 , use getBook()
    
    Returns:
    
    the book model of this spreadsheet.
  - getSBook
```
public SBook getSBook()
```
    Returns the book model of this Spreadsheet. If you call this method at first time and the book has not assigned by setSBook(SBook), this will create a new model depends on src;
    
    Returns:
    
    the book model of this spreadsheet.
  - setXBook
```
public void setXBook(SBook book)
```
    Deprecated. since 3.0.0 , use setBook(Book)
    
    Sets the book data model of this spread sheet.
    
    Parameters:
    
    book - the book data model.
  - setSBook
```
public void setSBook(SBook book)
```
    Sets the book data model of this spread sheet.
    
    Parameters:
    
    book - the book data model.
  - getSelectedXSheet
```
public SSheet getSelectedXSheet()
```
    Deprecated. since 3.0.0 , use getSelectedSheet()
  - getSelectedSSheet
```
public SSheet getSelectedSSheet()
```
    Gets the selected sheet, the default selected sheet is first sheet.
    
    Returns:
    
    #SSheet
  - getSrc
```
public String getSrc()
```
    Returns the src location of book model. This src is used by the specified importer to create the book data model of this spread sheet.
    
    Returns:
    
    the src location
  - setSrc
```
public void setSrc(String src)
```
    Sets the src location of the book data model to be imported into spreadsheet. A specified importer (getImporter()) will use this src to create the book data model.
    
    Parameters:
    
    src - the book src location
  - getSImporter
```
public SImporter getSImporter()
```
    Deprecated. since 3.0.0 , use getImporter()
    
    Gets the importer that import the file in the specified src ( getSrc()) to XBook data model. The default importer is ExcelImporter.
    
    Returns:
    
    the importer
  - setSImporter
```
public void setSImporter(SImporter importer)
```
    Deprecated. since 3.0.0 , use setImporter(Importer)
    
    Sets the importer for import the book data model from a specified src.
    
    Parameters:
    
    importer - the importer to import a spread sheet file from a document format (e.g. an Excel file) by the specified src (@link #setSrc(). The default importer is ExcelImporter.
  - setSelectedSheet
```
public void setSelectedSheet(String name)
```
    Sets the selected sheet by a name
    
    Parameters:
    
    name - the name of spreadsheet to be selected.
  - getMaxrows
```
public int getMaxrows()
```
    Deprecated. since 3.0.0, use #getMaxVisibleRows()
    
    Returns the maximum visible number of rows of this spreadsheet. You can assign new number by calling setMaxrows(int).
    
    Returns:
    
    the maximum visible number of rows.
  - setMaxrows
```
public void setMaxrows(int maxrows)
```
    Deprecated. since 3.0.0, use #setMaxVisibleRows(int)
    
    Sets the maximum visible number of rows of this spreadsheet. For example, if you set this parameter to 40, it will allow showing only row 0 to 39. The minimal value of max number of rows must large than 0;
    Default : 20.
    
    Parameters:
    
    maxrows - the maximum visible number of rows
  - setPreloadRowSize
```
public void setPreloadRowSize(int size)
```
  - getPreloadRowSize
```
public int getPreloadRowSize()
```
  - getMaxcolumns
```
public int getMaxcolumns()
```
    Deprecated. since 3.0.0, use #getMaxVisibleColumns()
    
    Returns the maximum visible number of columns of this spreadsheet. You can assign new numbers by calling setMaxcolumns(int).
    
    Returns:
    
    the maximum visible number of columns
  - setMaxcolumns
```
public void setMaxcolumns(int maxcols)
```
    Deprecated. since 3.0.0, use #setMaxVisibleColumns(int)
    
    Sets the maximum visible number of columns of this spreadsheet. For example, if you set this parameter to 40, it will allow showing only column 0 to column 39. the minimal value of max number of columns must large than 0;
    
    Parameters:
    
    maxcols - the maximum visible number of columns
  - setPreloadColumnSize
```
public void setPreloadColumnSize(int size)
```
  - getPreloadColumnSize
```
public int getPreloadColumnSize()
```
  - getRowfreeze
```
public int getRowfreeze()
```
    Deprecated. since 3.0.0, use Sheet.getRowFreeze() instead.
    
    Returns the index of row freeze of this of spreadsheet or selected sheet.
  - setRowfreeze
```
public void setRowfreeze(int rowfreeze)
```
    Deprecated. since 3.0.0, use Range.setFreezePanel(int, int) instead.
    
    Sets the index of row freeze of this spreadsheet.
  - getColumnfreeze
```
public int getColumnfreeze()
```
    Deprecated. since 3.0.0, use Sheet.getColumnFreeze() instead.
    
    Returns the index of column freeze of this of spreadsheet or selected sheet.
  - setColumnfreeze
```
public void setColumnfreeze(int colfreeze)
```
    Deprecated. since 3.0.0, use Range.setFreezePanel(int, int) instead.
    
    Sets the index of column freeze of this spreadsheet.
  - isHiderowhead
```
public boolean isHiderowhead()
```
    Returns true if hide row head of this spread sheet; default to false.
    
    Returns:
    
    true if hide row head of this spread sheet; default to false.
  - setHiderowhead
```
public void setHiderowhead(boolean hide)
```
    Sets true to hide the row head of this spread sheet.
    
    Parameters:
    
    hide - true to hide the row head of this spread sheet.
  - isHidecolumnhead
```
public boolean isHidecolumnhead()
```
    Returns true if hide column head of this spread sheet; default to false.
    
    Returns:
    
    true if hide column head of this spread sheet; default to false.
  - setHidecolumnhead
```
public void setHidecolumnhead(boolean hide)
```
    Sets true to hide the column head of this spread sheet.
    
    Parameters:
    
    hide - true to hide the row head of this spread sheet.
  - setColumntitles
```
public void setColumntitles(Map titles)
```
    Sets the customized titles of column header.
    
    Parameters:
    
    titles - a map for customized column titles, the key of column must be Integer object.
  - getColumntitles
```
public Map getColumntitles()
```
    Get the column titles Map object, modification of return object doesn't cause any update.
    
    Returns:
    
    Map object of customized column names
  - setColumntitles
```
public void setColumntitles(String titles)
```
    Sets the customized titles which split by ','. For example: "name,title,age" or "name,,age" , an empty string means use default column title. This method will split the input string to a Map with sequence index from 0, then call setColumntitles(Map)
    
    Note: this method will always invoke invalidate()
    
    Parameters:
    
    titles - the column titles
  - setRowtitles
```
public void setRowtitles(Map titles)
```
    Sets the customized titles of row header.
    
    Parameters:
    
    titles - map for customized column titles, the key of column must be Integer object.
  - getRowtitles
```
public Map getRowtitles()
```
    Get the row titles Map object, modification of the return object doesn't cause any update.
    
    Returns:
    
    Map object of customized row names
  - setRowtitles
```
public void setRowtitles(String titles)
```
    Sets the customized titles which split by ','. For example: "name,title,age" or "name,,age" , an empty string means use default row title. This method will split the input string to a Map with sequence index from 0, then call setRowtitles(Map)
    
    Note: this method will always invoke invalidate()
    
    Parameters:
    
    titles - the row titles
  - getRowheight
```
public int getRowheight()
```
    Gets the default row height of the selected sheet
    
    Returns:
    
    default value depends on selected sheet
  - setRowheight
```
public void setRowheight(int rowHeight)
```
    Sets the default row height of the selected sheet
    
    Parameters:
    
    rowHeight - the row height
  - getColumnwidth
```
public int getColumnwidth()
```
    Gets the default column width of the selected sheet
    
    Returns:
    
    default value depends on selected sheet
  - setColumnwidth
```
public void setColumnwidth(int columnWidth)
```
    Sets the default column width of the selected sheet
    
    Parameters:
    
    columnWidth - the default column width
  - getLeftheadwidth
```
public int getLeftheadwidth()
```
    Gets the left head panel width
    
    Returns:
    
    default value is 36
  - setLeftheadwidth
```
public void setLeftheadwidth(int leftWidth)
```
    Sets the left head panel width, must large then 0.
    
    Parameters:
    
    leftWidth - leaf header width
  - getTopheadheight
```
public int getTopheadheight()
```
    Gets the top head panel height
    
    Returns:
    
    default value is 20
  - setTopheadheight
```
public void setTopheadheight(int topHeight)
```
    Sets the top head panel height, must large then 0.
    
    Parameters:
    
    topHeight - top header height
  - setShowToolbar
```
public void setShowToolbar(boolean showToolbar)
```
    Sets whether show toolbar or not Default: false
    
    Parameters:
    
    showToolbar - true to show toolbar
  - isShowToolbar
```
public boolean isShowToolbar()
```
    Returns whether shows toolbar
    
    Returns:
    
    boolean
  - setShowFormulabar
```
public void setShowFormulabar(boolean showFormulabar)
```
    Sets whether show formula bar or not
    
    Parameters:
    
    showFormulabar - true if want to show formula bar
  - isShowFormulabar
```
public boolean isShowFormulabar()
```
    Returns whether show formula bar
  - setShowSheetbar
```
public void setShowSheetbar(boolean showSheetbar)
```
    Sets whether show sheetbar or not
    
    Parameters:
    
    showSheetbar - true if want to show sheet tab panel
  - isShowSheetbar
```
public boolean isShowSheetbar()
```
    Returns whether show sheetbar
  - setShowContextMenu
```
public void setShowContextMenu(boolean showContextMenu)
```
    Sets whether show ContextMenu or not
    
    Parameters:
    
    showContextMenu -
  - isShowSheetTabContextMenu
```
public boolean isShowSheetTabContextMenu()
```
    Returns whether show ContextMenu in sheet tab
    
    Returns:
  - setShowSheetTabContextMenu
```
public void setShowSheetTabContextMenu(boolean showSheetTabContextMenu)
```
    Sets whether show ContextMenu or not
    
    Parameters:
    
    showSheetTabContextMenu -
  - renderProperties
```
protected void renderProperties(org.zkoss.zk.ui.sys.ContentRenderer renderer)
                         throws IOException
```
    Overrides:
    
    renderProperties in class org.zkoss.zul.impl.XulElement
    
    Throws:
    
    IOException
  - renderProperties0
```
protected void renderProperties0(org.zkoss.zk.ui.sys.ContentRenderer renderer)
                          throws IOException
```
    Throws:
    
    IOException
  - getColumntitle
```
public String getColumntitle(int index)
```
    Get Column title of given index, it returns column name depends on following condition
    1.if there is a custom column title assign on this spreadsheet on index, then return custom value
    2.if there is a custom column title assign on selected sheet on index, the return custom value
    3.return default column String, for example index 0 become "A", index 9 become "J"
    
    Returns:
    
    column name
  - getRowtitle
```
public String getRowtitle(int index)
```
    Get Row title of given index, it returns row name depends on following condition
    1.if there is a custom row title assign on this spreadsheet on index, then return custom value
    2.if there is a custom row title assign on selected sheet on index, the return custom value
    3.return default row index+1 String, for example index 0 become "1", index 9 become "10"
    
    Parameters:
    
    index - row index
    
    Returns:
    
    row name
  - getSelection
```
public AreaRef getSelection()
```
    Return current selection rectangle only if onCellSelection event listener is registered. The returned value is a clone copy of current selection status. Default Value:(0,0,0,0)
    
    Returns:
    
    current selection
  - setSelection
```
public void setSelection(AreaRef sel)
```
    Sets the selection rectangle. In general, if you set a selection, you must also set the focus by setCellFocus(CellRef);. And, if you want to get the focus back to spreadsheet, call focus() after set selection.
    
    Parameters:
    
    sel - the selection rect
  - getHighlight
```
public AreaRef getHighlight()
```
    Return current highlight rectangle. the returned value is a clone copy of current highlight status. Default Value: null
    
    Returns:
    
    current highlight
  - setHighlight
```
public void setHighlight(AreaRef highlight)
```
    Sets the highlight rectangle or sets a null value to hide it.
    
    Parameters:
    
    highlight - the highlight rect
  - getCellFocus
```
public CellRef getCellFocus()
```
    Return current cell(row,column) focus position. you can get the row by CellRef.getRow(), get the column by CellRef.getColumn() . The returned value is a copy of current focus status. Default Value:(0,0)
    
    Returns:
    
    current focus
  - setCellFocus
```
public void setCellFocus(CellRef focus)
```
    Sets the cell focus position.(this method doesn't focus the spreadsheet.) In general, if you set a cell focus, you also set the selection by setSelection(AreaRef); And if you want to get the focus back to spreadsheet, call focus() to retrieve focus.
    
    Parameters:
    
    focus - the cell focus position
  - getExtraCtrl
```
public Object getExtraCtrl()
```
    Specified by:
    
    getExtraCtrl in interface org.zkoss.zk.ui.sys.ComponentCtrl
    
    Overrides:
    
    getExtraCtrl in class org.zkoss.zk.ui.HtmlBasedComponent
  - newExtraCtrl
```
protected Object newExtraCtrl()
```
    Return a extra controller. only spreadsheet developer need to call this method.
  - invalidate
```
public void invalidate()
```
    Specified by:
    
    invalidate in interface org.zkoss.zk.ui.Component
    
    Overrides:
    
    invalidate in class org.zkoss.zk.ui.AbstractComponent
  - focus
```
public void focus()
```
    Retrieve client side spreadsheet focus.The cell focus and selection will keep at last status. It is useful if you want get focus back to spreadsheet after do some outside processing, for example after user click a outside button or menu item.
    
    Overrides:
    
    focus in class org.zkoss.zk.ui.HtmlBasedComponent
  - focusTo
```
public void focusTo(int row,
                    int column)
```
    Retrieve client side spreadhsheet focus, move cell focus to position (row,column) and also scroll the cell to into visible view.
    
    Parameters:
    
    row - row of cell to move
    
    column - column of cell to move
  - isIE9
```
public static boolean isIE9()
```
  - getSelectedSheetName
```
public String getSelectedSheetName()
```
  - disableUserAction
```
public void disableUserAction(AuxAction action,
                              boolean disabled)
```
    Sets the AuxAction disabled
    
    Parameters:
    
    disabled -
    
    action -
  - addToolbarButton
```
public boolean addToolbarButton(ToolbarButton btn)
```
    Adds toolbar button to the end of the buttons.
    
    Parameters:
    
    btn -
    
    Returns:
    
    true if success.
    
    Since:
    
    5.0.0
  - addToolbarButton
```
public void addToolbarButton(int index,
                             ToolbarButton btn)
```
    Inserts the specified button at the specified position in the buttons list. Shifts the button currently at that position (if any) and any subsequent buttons to the right (adds one to their indices).
    
    Parameters:
    
    index - index at which the specified element is to be inserted
    
    btn -
  - removeToolbarButton
```
public boolean removeToolbarButton(ToolbarButton btn)
```
    Removes the first occurrence of the given button instance in the buttons list.
    
    Parameters:
    
    btn -
    
    Returns:
    
    Since:
    
    5.0.0
  - removeToolbarButton
```
public boolean removeToolbarButton(String key)
```
    Removes the first occurrence of the given key in the buttons list.
    
    Parameters:
    
    key - the button's key
    
    Returns:
    
    Since:
    
    5.0.0
  - removeToolbarButton
```
public boolean removeToolbarButton(int index)
```
    Removes the button at the specified position in this buttons list.
    
    Parameters:
    
    index -
    
    Returns:
  - getToolbarButtons
```
public List<ToolbarButton> getToolbarButtons()
```
    Returns all toolbar buttons (read only).
    
    Returns:
    
    Since:
    
    5.0.0
  - insertBefore
```
public boolean insertBefore(org.zkoss.zk.ui.Component newChild,
                            org.zkoss.zk.ui.Component refChild)
```
    Specified by:
    
    insertBefore in interface org.zkoss.zk.ui.Component
    
    Overrides:
    
    insertBefore in class org.zkoss.zk.ui.AbstractComponent
  - removeEditorFocus
```
public void removeEditorFocus(String id)
```
    Remove editor's focus on specified name
  - moveEditorFocus
```
public void moveEditorFocus(String id,
                            String name,
                            String color,
                            int row,
                            int col)
```
    Add and move other editor's focus
  - setUserName
```
public void setUserName(String name)
```
    Set focus name of this spreadsheet.
    
    Parameters:
    
    name - focus name that show on other Spreadsheet
  - service
```
public void service(org.zkoss.zk.au.AuRequest request,
                    boolean everError)
```
    Processes an AU request. It is invoked internally.
    Default: in addition to what are handled by HtmlBasedComponent.service(org.zkoss.zk.au.AuRequest, boolean), it also handles onChange.
    
    Specified by:
    
    service in interface org.zkoss.zk.ui.sys.ComponentCtrl
    
    Overrides:
    
    service in class org.zkoss.zk.ui.HtmlBasedComponent
  - smartUpdate
```
public void smartUpdate(String attr,
                        Object value)
```
    Overrides:
    
    smartUpdate in class org.zkoss.zk.ui.AbstractComponent
  - smartUpdate
```
public void smartUpdate(String attr,
                        Object value,
                        boolean append)
```
    Overrides:
    
    smartUpdate in class org.zkoss.zk.ui.AbstractComponent
  - response
```
public void response(String key,
                     org.zkoss.zk.au.AuResponse response)
```
    Overrides:
    
    response in class org.zkoss.zk.ui.AbstractComponent
  - afterCompose
```
public void afterCompose()
```
    Specified by:
    
    afterCompose in interface org.zkoss.zk.ui.ext.AfterCompose
  - onPageAttached
```
public void onPageAttached(org.zkoss.zk.ui.Page newpage,
                           org.zkoss.zk.ui.Page oldpage)
```
    Specified by:
    
    onPageAttached in interface org.zkoss.zk.ui.sys.ComponentCtrl
    
    Overrides:
    
    onPageAttached in class org.zkoss.zk.ui.AbstractComponent
  - onPageDetached
```
public void onPageDetached(org.zkoss.zk.ui.Page page)
```
    Specified by:
    
    onPageDetached in interface org.zkoss.zk.ui.sys.ComponentCtrl
    
    Overrides:
    
    onPageDetached in class org.zkoss.zk.ui.AbstractComponent
  - isCleanBookAutomatically
```
protected boolean isCleanBookAutomatically()
```
    Returns:
    
    true if should clean book automatically when component detached
    
    Since:
    
    3.0.0
  - getBook
```
public Book getBook()
```
    Returns the book model of this Spreadsheet. If you call this method at first time and the book has not assigned by setBook(Book), this will create a new model depends on src;
    
    Returns:
    
    the book model of this spread sheet.
  - setBook
```
public void setBook(Book book)
```
    Sets the book data model of this spread sheet.
    
    Parameters:
    
    book - the book data model.
  - getSelectedSheet
```
public Sheet getSelectedSheet()
```
    Gets the selected sheet, the default selected sheet is first sheet.
    
    Returns:
    
    #Sheet
  - getMaxVisibleColumns
```
public int getMaxVisibleColumns()
```
    Returns the maximum visible number of columns of this spreadsheet. You can assign new numbers by calling setMaxVisibleColumns(int).
    
    Returns:
    
    the maximum visible number of columns
    
    Since:
    
    3.0.0
  - getMaxVisibleRows
```
public int getMaxVisibleRows()
```
    Returns the maximum visible number of rows of this spreadsheet. You can assign new number by calling setMaxVisibleRows(int).
    
    Returns:
    
    the maximum visible number of rows of the currently selected sheet.
    
    Since:
    
    3.0.0
  - getCurrentMaxVisibleColumns
```
public int getCurrentMaxVisibleColumns()
```
    Returns the maximum visible number of columns of the currently selected sheet.
    
    Returns:
    
    Since:
    
    3.8.1
  - getCurrentMaxVisibleRows
```
public int getCurrentMaxVisibleRows()
```
    Returns the maximum visible number of rows of the currently selected sheet.
    
    Returns:
    
    Since:
    
    3.8.1
  - setMaxVisibleColumns
```
public void setMaxVisibleColumns(int maxcols)
```
    Sets the maximum visible number of columns of this spreadsheet. For example, if you set this parameter to 40, it will allow showing only column 0 to column 39. the minimal value of max number of columns must large than 0. Since 3.8.1, if you set maximum visible number of columns to 0, it means you allow end user to adjust the visible number of columns.
    Default : 0. (since 3.8.1)
    
    Parameters:
    
    maxcols - the maximum visible number of columns
    
    Since:
    
    3.0.0
  - setMaxVisibleRows
```
public void setMaxVisibleRows(int maxrows)
```
    Sets the maximum visible number of rows of this spreadsheet. For example, if you set this parameter to 40, it will allow showing only row 0 to 39. The minimal value of max number of rows must large than 0. Since 3.8.1, if you set maximum visible number of rows to 0, it means you allow end user to adjust the visible number of rows.
    Default : 0. (since 3.8.1)
    
    Parameters:
    
    maxrows - the maximum visible number of rows
    
    Since:
    
    3.0.0
  - getImporter
```
public Importer getImporter()
```
    Gets the importer that import the file in the specified src ( getSrc()) to Book data model. The default importer is excel importer.
    
    Returns:
    
    the importer
  - setImporter
```
public void setImporter(Importer importer)
```
    Sets the importer for import the book data model from a specified src.
    
    Parameters:
    
    importer - the importer to import a spread sheet file from a document format (e.g. an Excel file) by the specified src (@link #setSrc(). The default importer is excel importer
  - clearClientCache
```
public void clearClientCache(SSheet sheet)
```
    Call this method to clear client side cache for a Sheet and fine tune data loading speed. Note if the given sheet is the currently selected sheet, it will be ignored.
    
    Parameters:
    
    sheet - the sheet
    
    Since:
    
    3.7.0
  - getUndoableActionManager
```
public UndoableActionManager getUndoableActionManager()
```
  - isKeepCellSelection
```
public boolean isKeepCellSelection()
```
    Returns true if keep the cell selection box when lost focus; default to false.
    
    Returns:
    
    true if keep the cell selection box when lost focus; default to false.
    
    Since:
    
    3.8.1
  - setKeepCellSelection
```
public void setKeepCellSelection(boolean keep)
```
    Sets true to keep the cell selection box when lost focus.
    
    Parameters:
    
    keep - true to keep the cell selection box when lost focus.
    
    Since:
    
    3.8.1
  - getSheetMaxVisibleRows
```
public int getSheetMaxVisibleRows(SSheet sheet)
```
    Returns the max visible rows of the specified sheet
    
    Parameters:
    
    sheet -
    
    Since:
    
    3.8.1
  - getSheetMaxVisibleColumns
```
public int getSheetMaxVisibleColumns(SSheet sheet)
```
    Returns the max visible columns of the specified sheet
    
    Parameters:
    
    sheet -
    
    Since:
    
    3.8.1
  - setSheetMaxVisibleRows
```
public void setSheetMaxVisibleRows(SSheet sheet,
                                   int maxRows)
```
    Sets the max visible rows of the specified sheet
    
    Parameters:
    
    sheet -
    
    Since:
    
    3.8.1
  - setSheetMaxVisibleColumns
```
public void setSheetMaxVisibleColumns(SSheet sheet,
                                      int maxColumns)
```
    Sets the max visibles columns of the specified sheet.
    
    Parameters:
    
    sheet -
    
    Since:
    
    3.8.1
  - setShowAddRow
```
public void setShowAddRow(boolean showAddRow)
```
    Sets whether show the add row button in sheetbar.
    
    Parameters:
    
    showAddRow - true if want to show add row button in sheetbar
    
    Since:
    
    3.8.1
  - isShowAddRow
```
public boolean isShowAddRow()
```
    Returns whether show the add row button in sheetbar.
    
    Since:
    
    3.8.1
  - setShowAddColumn
```
public void setShowAddColumn(boolean showAddColumn)
```
    Sets whether show the add column button in sheetbar.
    
    Parameters:
    
    showAddColumn - true if want to show add column button in sheetbar
    
    Since:
    
    3.8.1
  - isShowAddColumn
```
public boolean isShowAddColumn()
```
    Returns whether show the add column button in sheetbar.
    
    Since:
    
    3.8.1
  - parseLinkAddress
```
public static Object[] parseLinkAddress(Book book,
                                        String linkAddress)
```
  - notifyLoadedAreaChange
```
public void notifyLoadedAreaChange()
```
    NotifyChange the currently loaded area and freeze area if exists.
    
    Since:
    
    3.8.3
  - notifyVisibleAreaChange
```
public void notifyVisibleAreaChange()
```
    NotifyChange the currently visible area and freeze area if exists.
    
    Since:
    
    3.8.3
  - setIgnoreAutoHeight
```
public void setIgnoreAutoHeight(boolean b)
```
    Whether ignore row's autoHeight calculation. Default to false. Calculating text height and doing row's autoHeight adjustment is an expensive operation. In application, if your cell height is fixed then you can set this flag to true to avoid Keikai Spreadsheet to calculate this information and thus speed up your application a bit. However, if you need Keikai Spreadsheet to calculate row's autoHeight, you have to keep it at false. Though not encouraged, note that whenever you set it from true to false, Spreadsheet will invalidate itself to gurantee the autocalculation works.
    
    Parameters:
    
    b -
    
    Since:
    
    3.8.3

Class Spreadsheet

Nested Class Summary

Nested classes/interfaces inherited from class org.zkoss.zk.ui.AbstractComponent

Field Summary

Fields inherited from class org.zkoss.zk.ui.HtmlBasedComponent

Fields inherited from interface org.zkoss.zk.ui.Component

Fields inherited from interface org.zkoss.zk.ui.sys.ComponentCtrl

Constructor Summary

Method Summary

Methods inherited from class org.zkoss.zul.impl.XulElement

Methods inherited from class org.zkoss.zk.ui.HtmlBasedComponent

Methods inherited from class org.zkoss.zk.ui.AbstractComponent

Methods inherited from class java.lang.Object

Constructor Detail

Spreadsheet

Method Detail

getUserActionManager

setCtrlKeys

setMaxRenderedCellSize

getMaxRenderedCellSize

isClientCacheDisabled

setClientCacheDisabled

setDraggable

getXBook

getSBook

setXBook

setSBook

getSelectedXSheet

getSelectedSSheet

getSrc

setSrc

getSImporter

setSImporter

setSelectedSheet

getMaxrows

setMaxrows

setPreloadRowSize

getPreloadRowSize

getMaxcolumns

setMaxcolumns

setPreloadColumnSize

getPreloadColumnSize

getRowfreeze

setRowfreeze

getColumnfreeze

setColumnfreeze

isHiderowhead

setHiderowhead

isHidecolumnhead

setHidecolumnhead

setColumntitles

getColumntitles

setColumntitles

setRowtitles

getRowtitles

setRowtitles

getRowheight

setRowheight

getColumnwidth

setColumnwidth

getLeftheadwidth

setLeftheadwidth

getTopheadheight

setTopheadheight

setShowToolbar

isShowToolbar

setShowFormulabar

isShowFormulabar

setShowSheetbar

isShowSheetbar

setShowContextMenu

isShowSheetTabContextMenu

setShowSheetTabContextMenu

renderProperties

renderProperties0

getColumntitle

getRowtitle

getSelection

setSelection

getHighlight