public class Spreadsheet extends org.zkoss.zul.impl.XulElement implements Serializable, org.zkoss.zk.ui.ext.AfterCompose
SBook
) and interact with this model by
event.setBook(Book)
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)
. <spreadsheet/>
tag like any other ZK Components.Constructor and Description |
---|
Spreadsheet() |
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 |
autoFitRowHeight(int row,
int col)
Adjust specified row's height of the currently-selected sheet according to the specified cell's content.
|
void |
clearClientCache(SSheet sheet)
Call this method to clear client side cache for a Sheet and fine
tune data loading speed.
|
void |
clearClipboard()
Clear current Server Clipboard
|
void |
clearTrace()
Clears the tracing.
|
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.
|
UserActionContext.Clipboard |
getClipboard()
Return current Server Clipboard
|
HeaderPositionHelper |
getColumnPosition(SSheet sheet) |
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()
|
int |
getLeftheadwidth()
Gets the left head panel width
|
int |
getMaxRenderedCellSize()
Returns the max rendered cell size
|
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 |
getRowheight()
Gets the default row height of the selected sheet
|
HeaderPositionHelper |
getRowPosition(SSheet 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 visible sheet.
|
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
|
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) |
boolean |
insertBefore(org.zkoss.zk.ui.Component newChild,
org.zkoss.zk.ui.Component refChild) |
void |
invalidate() |
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.
|
boolean |
isKeepCellSelection()
Returns true if keep the cell selection box when lost focus; default to
false.
|
boolean |
isReadOnly()
Returns whether the component is in read-ony mode or not.
|
boolean |
isShowAddColumn()
Returns whether show the add column button in sheetbar.
|
boolean |
isShowAddRow()
Returns whether show the add row button in sheetbar.
|
boolean |
isShowContextMenu()
Returns whether to show ContextMenu or not
|
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
|
boolean |
isShowZeroValues()
Returns whether to show zero values or not
|
void |
moveEditorFocus(String id,
String name,
String color,
int row,
int col)
Add and move other editor's focus
|
protected SpreadsheetCtrl |
newExtraCtrl() |
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(AuxAction btn)
Removes the first occurrence of the given button instance in the buttons list.
|
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) |
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 |
setAutofitColumnWidth(SSheet sheet,
int column)
AutoFit a single column width according to its data size.
|
void |
setAutofitColumnWidth(SSheet sheet,
int fromColumn,
int toColumn)
AutoFit multiple columns width according to each one's data size from
the
|
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 |
setClipboard(UserActionContext.Clipboard clipboard)
Set current Server Clipboard
|
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) |
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 |
setMaxRenderedCellSize(int maxRenderedCellSize)
Sets the max rendered cell size.
|
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 |
setReadOnly(boolean readOnly)
Sets whether to enable this component as read-only mode or not.
|
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 |
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)
Under collaboration edit mode, Spreadsheet renders multiple selection boxes in a sheet.
|
void |
smartUpdate(String attr,
Object value) |
void |
smartUpdate(String attr,
Object value,
boolean append) |
void |
traceDependents(Sheet sheet,
CellRef cellRef)
Trace the dependents of the reference.
|
void |
tracePrecedents(Sheet sheet,
CellRef cellRef)
Trace the precedent of the reference.
|
clone, getContext, getCtrlKeys, getPopup, getPropertyAccess, getTooltip, setContext, setContext, setContextAttributes, setPopup, setPopup, setPopupAttributes, setTooltip, setTooltip, setTooltipAttributes
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
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, isInitialized, 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
public void traceDependents(Sheet sheet, CellRef cellRef)
sheet
- cellRef
- public void tracePrecedents(Sheet sheet, CellRef cellRef)
sheet
- cellRef
- public void clearTrace()
public UserActionManager getUserActionManager()
UserActionManager.registerHandler(String, String, UserActionHandler)
UserActionManager
or null if doesn't support to overridepublic void setCtrlKeys(String ctrlKeys)
setCtrlKeys
in class org.zkoss.zul.impl.XulElement
public void setMaxRenderedCellSize(int maxRenderedCellSize)
maxRenderedCellSize
- public int getMaxRenderedCellSize()
public boolean isClientCacheDisabled()
public boolean isShowZeroValues()
public void setClientCacheDisabled(boolean clientCacheDisabled)
clientCacheDisabled
- public void setDraggable(String draggable)
setDraggable
in class org.zkoss.zk.ui.HtmlBasedComponent
UnsupportedOperationException
- if this method is called.public SBook getSBook()
setSBook(SBook)
, this
will create a new model depends on src;public void setSBook(SBook book)
book
- the book data model.public SSheet getSelectedSSheet()
SSheet
public String getSrc()
public void setSrc(String src)
getImporter()
) will use this
src to create the book data model.src
- the book src locationpublic void setSelectedSheet(String name)
name
- the name of spreadsheet to be selected.public void setPreloadRowSize(int size)
public int getPreloadRowSize()
public void setPreloadColumnSize(int size)
public int getPreloadColumnSize()
public boolean isHiderowhead()
public void setHiderowhead(boolean hide)
hide
- true to hide the row head of this spread sheet.public boolean isHidecolumnhead()
public void setHidecolumnhead(boolean hide)
hide
- true to hide the row head of this spread sheet.public void setColumntitles(Map titles)
titles
- a map for customized column titles, the key of column must be Integer object.public Map getColumntitles()
public void setColumntitles(String titles)
setColumntitles(Map)
titles
- the column titlespublic void setRowtitles(Map titles)
titles
- map for customized column titles, the key of column must be Integer object.public Map getRowtitles()
public void setRowtitles(String titles)
setRowtitles(Map)
titles
- the row titlespublic int getRowheight()
public void setRowheight(int rowHeight)
rowHeight
- the row heightpublic int getColumnwidth()
public void setColumnwidth(int columnWidth)
columnWidth
- the default column widthpublic int getLeftheadwidth()
public void setLeftheadwidth(int leftWidth)
leftWidth
- leaf header widthpublic int getTopheadheight()
public void setTopheadheight(int topHeight)
topHeight
- top header heightpublic void setShowToolbar(boolean showToolbar)
showToolbar
- true to show toolbarpublic boolean isShowToolbar()
public void setShowFormulabar(boolean showFormulabar)
showFormulabar
- true if want to show formula barpublic boolean isShowFormulabar()
public void setShowSheetbar(boolean showSheetbar)
showSheetbar
- true if want to show sheet tab panelpublic boolean isShowSheetbar()
public void setShowContextMenu(boolean showContextMenu)
showContextMenu
- public boolean isShowContextMenu()
public boolean isShowSheetTabContextMenu()
public void setShowSheetTabContextMenu(boolean showSheetTabContextMenu)
showSheetTabContextMenu
- protected void renderProperties(org.zkoss.zk.ui.sys.ContentRenderer renderer) throws IOException
renderProperties
in class org.zkoss.zul.impl.XulElement
IOException
public String getColumntitle(int index)
public String getRowtitle(int index)
index
- row indexpublic AreaRef getSelection()
public void setSelection(AreaRef sel)
setCellFocus(CellRef)
;. And, if you want
to get the focus back to spreadsheet, call focus()
after set
selection.sel
- the selection rectpublic AreaRef getHighlight()
public void setHighlight(AreaRef highlight)
highlight
- the highlight rectpublic void setReadOnly(boolean readOnly)
readOnly
- true to be read only mode.public boolean isReadOnly()
public CellRef getCellFocus()
CellRef.getRow()
, get the column by CellRef.getColumn()
. The returned value is a copy of current focus status. Default
Value:(0,0)public void setCellFocus(CellRef focus)
setSelection(AreaRef)
; And if you want to get the focus back to
spreadsheet, call focus()
to retrieve focus.focus
- the cell focus positionpublic HeaderPositionHelper getRowPosition(SSheet sheet)
public HeaderPositionHelper getColumnPosition(SSheet sheet)
public Object getExtraCtrl()
getExtraCtrl
in interface org.zkoss.zk.ui.sys.ComponentCtrl
getExtraCtrl
in class org.zkoss.zk.ui.HtmlBasedComponent
protected SpreadsheetCtrl newExtraCtrl()
public void invalidate()
invalidate
in interface org.zkoss.zk.ui.Component
invalidate
in class org.zkoss.zk.ui.AbstractComponent
public void focus()
focus
in class org.zkoss.zk.ui.HtmlBasedComponent
public void focusTo(int row, int column)
row
- row of cell to movecolumn
- column of cell to movepublic String getSelectedSheetName()
public void disableUserAction(AuxAction action, boolean disabled)
AuxAction
disabledaction
- disabled
- public boolean addToolbarButton(ToolbarButton btn)
btn
- public void addToolbarButton(int index, ToolbarButton btn)
index
- index at which the specified element is to be insertedbtn
- public boolean removeToolbarButton(ToolbarButton btn)
btn
- public boolean removeToolbarButton(String key)
key
- the button's keypublic boolean removeToolbarButton(AuxAction btn)
btn
- public boolean removeToolbarButton(int index)
index
- public List<ToolbarButton> getToolbarButtons()
public boolean insertBefore(org.zkoss.zk.ui.Component newChild, org.zkoss.zk.ui.Component refChild)
insertBefore
in interface org.zkoss.zk.ui.Component
insertBefore
in class org.zkoss.zk.ui.AbstractComponent
public void removeEditorFocus(String id)
public void moveEditorFocus(String id, String name, String color, int row, int col)
public void setUserName(String name)
name
- a name that shows with a selection box on other Spreadsheetpublic void service(org.zkoss.zk.au.AuRequest request, boolean everError)
Default: in addition to what are handled by HtmlBasedComponent.service(AuRequest, boolean)
,
it also handles onChange.
service
in interface org.zkoss.zk.ui.sys.ComponentCtrl
service
in class org.zkoss.zk.ui.HtmlBasedComponent
public void smartUpdate(String attr, Object value)
smartUpdate
in class org.zkoss.zk.ui.AbstractComponent
public void smartUpdate(String attr, Object value, boolean append)
smartUpdate
in class org.zkoss.zk.ui.AbstractComponent
public void response(String key, org.zkoss.zk.au.AuResponse response)
response
in class org.zkoss.zk.ui.AbstractComponent
public void afterCompose()
afterCompose
in interface org.zkoss.zk.ui.ext.AfterCompose
public void onPageAttached(org.zkoss.zk.ui.Page newpage, org.zkoss.zk.ui.Page oldpage)
onPageAttached
in interface org.zkoss.zk.ui.sys.ComponentCtrl
onPageAttached
in class org.zkoss.zk.ui.AbstractComponent
public void onPageDetached(org.zkoss.zk.ui.Page page)
onPageDetached
in interface org.zkoss.zk.ui.sys.ComponentCtrl
onPageDetached
in class org.zkoss.zk.ui.AbstractComponent
public Book getBook()
setBook(Book)
, this
will create a new model depends on src;public void setBook(Book book)
book
- the book data model.public void setAutofitColumnWidth(SSheet sheet, int column)
sheet
- column
- Check the note.
public void setAutofitColumnWidth(SSheet sheet, int fromColumn, int toColumn)
FontMetrics
calculates a different width value of the same text, so the result on UI may look different when the server is running on these differences which are mentioned early.sheet
- fromColumn
- the start column to autofit widthtoColumn
- the end column to autofit widthpublic void autoFitRowHeight(int row, int col)
CellOperationUtil.getAutoFitHeight(Sheet, int, int)
. If the target cell is a merged cell, please specify its left-top corner cell.row
- index of rowcol
- index of columnpublic Sheet getSelectedSheet()
Sheet
public int getMaxVisibleColumns()
setMaxVisibleColumns(int)
.public int getMaxVisibleRows()
setMaxVisibleRows(int)
.public int getCurrentMaxVisibleColumns()
public int getCurrentMaxVisibleRows()
public void setMaxVisibleColumns(int maxcols)
maxcols
- the maximum visible number of columnspublic void setMaxVisibleRows(int maxrows)
maxrows
- the maximum visible number of rowspublic Importer getImporter()
getSrc()
) to Book
data model. The default importer is
excel importer.public void setImporter(Importer importer)
importer
- the importer to import a spreadsheet file from a document
format (e.g. an Excel file) by setSrc(String)
.
The default importer is XlsxImporter
public void clearClientCache(SSheet sheet)
sheet
- the sheetpublic UndoableActionManager getUndoableActionManager()
public boolean isKeepCellSelection()
public void setKeepCellSelection(boolean keep)
keep
- true to keep the cell selection box when lost focus.public int getSheetMaxVisibleRows(SSheet sheet)
sheet
- public int getSheetMaxVisibleColumns(SSheet sheet)
sheet
- public void setSheetMaxVisibleRows(SSheet sheet, int maxRows)
sheet
- public void setSheetMaxVisibleColumns(SSheet sheet, int maxColumns)
sheet
- public void setShowAddRow(boolean showAddRow)
showAddRow
- true if want to show add row button in sheetbarpublic boolean isShowAddRow()
public void setShowAddColumn(boolean showAddColumn)
showAddColumn
- true if want to show add column button in sheetbarpublic boolean isShowAddColumn()
public void notifyLoadedAreaChange()
public void notifyVisibleAreaChange()
public void setIgnoreAutoHeight(boolean b)
b
- public UserActionContext.Clipboard getClipboard()
public void clearClipboard()
public void setClipboard(UserActionContext.Clipboard clipboard)
clipboard
- Copyright © 2023. All rights reserved.