public final class WB extends CalculatableResWorkSheet implements WriteECReport, ShrinkFitable, WBProvider
CalculatableResWorkSheet.RecalRelationNameSpace
block, book, reportAttrSet
EMPTY
FIT, KEY, PAPER_HEIGHT, PAPER_WHDTH, TOOLBAR_HEIGHT, WEB_PAGE, XML_TAG
TAG
限定符和类型 | 方法和说明 |
---|---|
void |
addCellElement(CellElement cellElement)
添加格子
|
void |
addCellElement(CellElement cellElement,
boolean override)
添加格子
|
void |
addCellElement(WriteCellElement cell)
添加格子
|
void |
addCellElement(WriteCellElement cell,
boolean override)
添加格子
|
void |
addFloatElement(FloatElement floatElement)
添加悬浮元素
|
AppendRowData |
appendData(ColumnRow curPoint,
boolean beforePoint,
int count,
boolean isFromStash)
插入
|
void |
bringFloatElementForward(FloatElement floatElement)
悬浮元素前移
|
void |
bringFloatElementToFront(FloatElement floatElement)
悬浮元素移动到最前
|
VerifyResult[] |
checkVerifiers()
进行校验
|
void |
dealWithValue4Recal(CellElement ce)
处理值用于重计算
|
java.awt.Rectangle |
deleteData(ColumnRow curPoint)
删除以deletePoint为始的?
|
ExcelImportUncertainRect |
findUnCertainWriteExpandRect()
carl:找出模板中可能是不定行扩展的扩展块来
|
PageSetProvider |
generateReportPageSet(PaperSettingProvider paperSetting)
根据页面设置生成页面集合
|
int |
get_oi_column(int col) |
int |
get_oi_row(int row) |
<T> T |
getAttributeTarget(java.lang.String xmlTag) |
int |
getBoxExpandSize(int col,
int row)
获取格子扩展后的大小
|
int |
getBoxExpandSize(int col,
int row,
boolean vertical)
获取格子扩展后的大小
|
Calculator |
getCalculator()
获取当前算子
|
int |
getCurrentSheetIndex() |
CellElementCaseCreator |
getDefaultCellElementCaseCreator() |
DomOptimizer |
getDomOptimizer() |
TemplateElementCase |
getElementCase() |
int |
getExistedBoxExpandSize(int col,
int row,
boolean vertical)
获取格子扩展后的大小刨去删除状态的格子
|
java.util.List |
getExtendedColumnRowList(ColumnRow[] crArray,
ColumnRow baseLocation)
carl: ColumnRow[]中为原格子,此方法生成扩展队列 例如 [A1,B1] 生成
[[A1,B1],[A2,B2],[A3,B3]...]扩展之后的对应
暂时觉得,对应是否合理的判断不应该在这里做
|
java.lang.String[] |
getRelatedColumnRowNames(java.lang.String statement) |
LongMap |
getRelationMap() |
ColumnRow |
getRelativeColumnRow(ColumnRow curPoint)
根据插入删除按钮所在位置,得到指定格子的位置
|
int |
getReportIndexBySheetName(java.lang.String name) |
ColumnRow |
getResultColumnRow(ColumnRow cr)
获取一个行列在扩展后所在的位置
|
SE |
getSE() |
WriteCellElement |
getWriteCellElement(int column,
int row)
获取格子
|
void |
importStashData(JSONObject cellValues,
JSONArray rows,
JSONArray insertRows,
JSONArray deleteRows,
JSONObject cellValuesAssist)
引入暂存数据
|
void |
insertColumn(int columnIndex)
增加列
|
void |
insertRow(int rowIndex)
增加行
|
void |
merge(int rowFrom,
int rowTo,
int colFrom,
int colTo)
合并格子
|
ResultECReport |
processWidgetAsImage(ResultECReport resultbook)
将结果报表中的控件处理成图片, 用于导出打印
|
void |
readXML(XMLableReader reader)
读取子节点,应该会被XMLableReader.readXMLObject()调用多次
|
void |
recalculate(Report report,
java.util.Map parameterMap)
根据参数重新计算报表
|
java.util.List |
recalculate(Report report,
java.util.Map parameterMap,
boolean reCalRF)
重计算
|
void |
removeAllCellElements()
删除所有格子
|
void |
removeAllFloatElements()
去除所有悬浮元素
|
boolean |
removeCellElement(CellElement cell)
移除格子
|
CellElement |
removeCellElement(int column,
int row)
移除格子
|
boolean |
removeCellElement(WriteCellElement cell)
移除格子
|
void |
removeColumn(int columnIndex)
移除列
|
boolean |
removeFloatElement(FloatElement floatElement)
移除悬浮元素
|
FloatElement |
removeFloatElement(java.lang.String name)
移除悬浮元素
|
void |
removeRow(int rowIndex)
移除行
|
WriteCellElement |
removeWriteCellElement(int column,
int row)
移除格子
|
java.lang.Object |
resolveColumnRowRange(ColumnRowRange crr,
ColumnRow baseLocation)
解析行列域,返回值
|
void |
sendFloatElementBackward(FloatElement floatElement)
悬浮元素后移
|
void |
sendFloatElementToBack(FloatElement floatElement)
悬浮元素移到最后
|
int |
setCurrentColumnRow(ColumnRow[] crArray,
ColumnRow baseLocation,
Calculator ca,
DBWriteAction action,
int groupIdx)
根据crArray和baseLocation找到不同的BaseColumnRow
|
void |
setDomOptimizer(DomOptimizer domOptimizer) |
void |
setSE(SE se) |
void |
shrinkTOFit()
调整
|
void |
shrinkToFitPaper(Calculator calculator)
自适应调整页面行高列宽
|
AppendRowData |
simpleAppendData(ColumnRow selectedColumnRow,
boolean beforePoint,
int count,
boolean isExcelImport,
boolean isFromStash)
简单插入
|
void |
simpleDeleteData(ColumnRow selectedColumnRow)
ben:不考虑父格,直接删除选中格子及其sons
|
void |
unDeleteData(ColumnRow undoDeletePoint)
根据某deletePoint单元格进行取消删除行列操作
|
void |
writeXML(XMLPrintWriter writer)
Write XML.
|
fireCellValueChange, getFormulaRelation, getFormulaRelation, recalculateCertainCell
createElementCaseBlockImplement, generateReportPageSet, getColumnMappingArray, getResultCellElement, getResultWorkBook, getRowMappingArray, recalculate, recalculate, setColumnMappingArray, setResultWorkBook, setRowMappingArray
__mod_column_row, addColumnPrivilegeControl, addRowPrivilegeControl, cacheCellElement, cellIterator, clone, cloneWithoutCellCase, cloneWithoutCellCase, copyReadOnlyAttr, equals, floatIterator, getBlock, getBook, getCellCase, getCellElement, getCellValue, getColumn, getColumnCount, getColumnPrivilegeControl, getColumnWidth, getColumnWidthList_DEC, getFloatElement, getFooter, getHeader, getPaperSetting, getReportPageAttr, getReportSettings, getRow, getRowCount, getRowHeight, getRowHeightList_DEC, getRowPrivilegeControl, getTableDataSource, intersect, isElementCaseReport, isFiltered, iteratorOfElementCase, prepare2ShrinkRealWidthOrHeight4Cell, readReportHF, recalculateCellCase, releaseCellElementCache, removeColumnPrivilegeControl, removeRowPrivilegeControl, setBook, setCellCase, setCellValue, setColumnWidth, setFooter, setHeader, setReportPageAttr, setReportSettings, setRowHeight, shrinkTOFitColumnWidthForCellElement, shrinkTOFitRowHeightForCellElement, writeCommonXML
finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
isFiltered
getReportPageAttr, getResultWorkBook, setResultWorkBook, writeCommonXML
getBook, getFooter, getHeader, getTableDataSource, isElementCaseReport, iteratorOfElementCase, setFooter, setHeader, setReportSettings
getReportSettings
cellIterator, getColumnCount, getColumnWidthList_DEC, getReportSettings, getRowCount, getRowHeightList_DEC
getColumnMappingArray, getResultCellElement, getRowMappingArray
addColumnPrivilegeControl, addRowPrivilegeControl, getColumnPrivilegeControl, getColumnWidthList_DEC, getRowHeightList_DEC, getRowPrivilegeControl, prepare2ShrinkRealWidthOrHeight4Cell, removeColumnPrivilegeControl, removeRowPrivilegeControl, setColumnWidth, setReportPageAttr, setRowHeight, shrinkTOFitColumnWidthForCellElement, shrinkTOFitRowHeightForCellElement
getCellElement, getCellValue, getColumn, intersect, setCellValue
getFloatElement
getReportPageAttr
cellIterator, getColumnCount, getColumnWidth, getRow, getRowCount, getRowHeight
floatIterator
clone
getFormulaRelation, getFormulaRelation, getReportSettings, recalculateCertainCell
public WB()
public WB(SE se)
public SE getSE()
getSE
在类中 CalculatableResWorkSheet
public void setSE(SE se)
setSE
在接口中 WBProvider
public DomOptimizer getDomOptimizer()
public void setDomOptimizer(DomOptimizer domOptimizer)
public ExcelImportUncertainRect findUnCertainWriteExpandRect()
findUnCertainWriteExpandRect
在接口中 WriteECReport
public int getBoxExpandSize(int col, int row)
getBoxExpandSize
在接口中 WriteECReport
col
- 当前列row
- 当前行public int getBoxExpandSize(int col, int row, boolean vertical)
getBoxExpandSize
在接口中 WriteECReport
col
- 当前列row
- 当前行vertical
- 是否为纵向public int getExistedBoxExpandSize(int col, int row, boolean vertical)
getExistedBoxExpandSize
在接口中 WriteECReport
col
- 当前列row
- 当前行vertical
- 是否为纵向public ColumnRow getResultColumnRow(ColumnRow cr)
WriteECReport
getResultColumnRow
在接口中 WriteECReport
public int get_oi_column(int col)
public int get_oi_row(int row)
public TemplateElementCase getElementCase()
public int setCurrentColumnRow(ColumnRow[] crArray, ColumnRow baseLocation, Calculator ca, DBWriteAction action, int groupIdx) throws java.lang.Exception
DBWritable
setCurrentColumnRow
在接口中 DBWritable
setCurrentColumnRow
在接口中 DMLReport
crArray
- 一组单元格baseLocation
- 基准格子ca
- 算子action
- 操作groupIdx
- 如果是单元格组的话java.lang.Exception
- 计算错误则抛出此异常public java.util.List getExtendedColumnRowList(ColumnRow[] crArray, ColumnRow baseLocation)
getExtendedColumnRowList
在接口中 DBWritable
crArray
- 一组单元格baseLocation
- 基准单元格public <T> T getAttributeTarget(java.lang.String xmlTag)
getAttributeTarget
在接口中 WriteECReport
public VerifyResult[] checkVerifiers()
checkVerifiers
在接口中 WriteECReport
public java.lang.String[] getRelatedColumnRowNames(java.lang.String statement) throws java.lang.Exception
java.lang.Exception
public ColumnRow getRelativeColumnRow(ColumnRow curPoint)
WriteECReport
getRelativeColumnRow
在接口中 WriteECReport
public AppendRowData simpleAppendData(ColumnRow selectedColumnRow, boolean beforePoint, int count, boolean isExcelImport, boolean isFromStash) throws WriteException
simpleAppendData
在接口中 DBWritable
selectedColumnRow
- 选中的按钮beforePoint
- 是否在添加点之前插入数据count
- 插入数目isExcelImport
- 是否是excel导入isFromStash
- 是否是插入已保存数据WriteException
public AppendRowData appendData(ColumnRow curPoint, boolean beforePoint, int count, boolean isFromStash) throws WriteException
appendData
在接口中 DBWritable
curPoint
- 插入点 插入行按钮所在位置beforePoint
- 是否在添加点之前插入数据count
- 插入数目isFromStash
- 是否从已有数据中插入WriteException
public java.lang.Object resolveColumnRowRange(ColumnRowRange crr, ColumnRow baseLocation)
resolveColumnRowRange
在接口中 DBWritable
crr
- 行列域baseLocation
- 基准格子public java.awt.Rectangle deleteData(ColumnRow curPoint) throws WriteException
deleteData
在接口中 DBWritable
curPoint
- 插入点WriteException
public void shrinkTOFit()
shrinkTOFit
在接口中 ShrinkFitable
public void simpleDeleteData(ColumnRow selectedColumnRow) throws WriteException
simpleDeleteData
在接口中 DBWritable
selectedColumnRow
- 选中位置WriteException
public void unDeleteData(ColumnRow undoDeletePoint) throws WriteException
unDeleteData
在接口中 DBWritable
undoDeletePoint
- 某deletePoint单元格WriteException
public LongMap getRelationMap()
getRelationMap
在类中 CalculatableResWorkSheet
public int getCurrentSheetIndex()
public int getReportIndexBySheetName(java.lang.String name)
getReportIndexBySheetName
在接口中 WriteECReport
getReportIndexBySheetName
在类中 CalculatableResWorkSheet
public void dealWithValue4Recal(CellElement ce)
dealWithValue4Recal
在类中 CalculatableResWorkSheet
ce
- 格子public CellElementCaseCreator getDefaultCellElementCaseCreator()
public Calculator getCalculator()
CalculatableResWorkSheet
getCalculator
在类中 CalculatableResWorkSheet
public WriteCellElement getWriteCellElement(int column, int row)
getWriteCellElement
在接口中 WriteElementCase
column
- 列row
- 行public void addCellElement(CellElement cellElement)
addCellElement
在类中 AbstractECReport
cellElement
- 格子public void addCellElement(CellElement cellElement, boolean override)
addCellElement
在类中 AbstractECReport
cellElement
- 格子override
- 是否覆盖public void removeAllCellElements()
removeAllCellElements
在接口中 CellElementCase
removeAllCellElements
在类中 AbstractECReport
public void addFloatElement(FloatElement floatElement)
addFloatElement
在接口中 FloatElementCase
addFloatElement
在类中 AbstractECReport
floatElement
- 新增的悬浮元素public void bringFloatElementForward(FloatElement floatElement)
bringFloatElementForward
在接口中 FloatElementCase
bringFloatElementForward
在类中 AbstractECReport
floatElement
- 悬浮元素public void bringFloatElementToFront(FloatElement floatElement)
bringFloatElementToFront
在接口中 FloatElementCase
bringFloatElementToFront
在类中 AbstractECReport
floatElement
- 悬浮元素public void insertColumn(int columnIndex)
insertColumn
在接口中 CellElementCase
insertColumn
在类中 AbstractECReport
columnIndex
- 列序号public void insertRow(int rowIndex)
insertRow
在接口中 CellElementCase
insertRow
在类中 AbstractECReport
rowIndex
- 行序号public void merge(int rowFrom, int rowTo, int colFrom, int colTo)
merge
在接口中 CellElementCase
merge
在类中 AbstractECReport
rowFrom
- 起始行rowTo
- 结尾行colFrom
- 起始列colTo
- 结尾列public void removeAllFloatElements()
removeAllFloatElements
在接口中 FloatElementCase
removeAllFloatElements
在类中 AbstractECReport
public boolean removeCellElement(CellElement cell)
removeCellElement
在类中 AbstractECReport
cell
- 格子public CellElement removeCellElement(int column, int row)
removeCellElement
在接口中 CellElementCase
removeCellElement
在类中 AbstractECReport
column
- 列row
- 行public void removeColumn(int columnIndex)
removeColumn
在接口中 CellElementCase
removeColumn
在类中 AbstractECReport
columnIndex
- 列序号public FloatElement removeFloatElement(java.lang.String name)
removeFloatElement
在接口中 FloatElementCase
removeFloatElement
在类中 AbstractECReport
name
- 悬浮元素名public boolean removeFloatElement(FloatElement floatElement)
removeFloatElement
在接口中 FloatElementCase
removeFloatElement
在类中 AbstractECReport
floatElement
- 悬浮元素public void removeRow(int rowIndex)
removeRow
在接口中 CellElementCase
removeRow
在类中 AbstractECReport
rowIndex
- 行序号public void sendFloatElementBackward(FloatElement floatElement)
sendFloatElementBackward
在接口中 FloatElementCase
sendFloatElementBackward
在类中 AbstractECReport
floatElement
- 悬浮元素public void sendFloatElementToBack(FloatElement floatElement)
sendFloatElementToBack
在接口中 FloatElementCase
sendFloatElementToBack
在类中 AbstractECReport
floatElement
- 悬浮元素public void addCellElement(WriteCellElement cell)
addCellElement
在接口中 WriteElementCase
cell
- 格子public void addCellElement(WriteCellElement cell, boolean override)
addCellElement
在接口中 WriteElementCase
cell
- 格子override
- 是否覆盖public boolean removeCellElement(WriteCellElement cell)
removeCellElement
在接口中 WriteElementCase
cell
- 格子public WriteCellElement removeWriteCellElement(int column, int row)
removeWriteCellElement
在接口中 WriteElementCase
column
- 列row
- 行public PageSetProvider generateReportPageSet(PaperSettingProvider paperSetting)
generateReportPageSet
在接口中 ResultReport
generateReportPageSet
在类中 AbstractResECWorkSheet
paperSetting
- 页面设置public ResultECReport processWidgetAsImage(ResultECReport resultbook)
processWidgetAsImage
在接口中 ResultECReport
processWidgetAsImage
在类中 AbstractResECWorkSheet
resultbook
- 结果报表public void recalculate(Report report, java.util.Map parameterMap)
recalculate
在接口中 ResultReport
recalculate
在类中 AbstractResECWorkSheet
report
- 参数没用,重构时可以去掉parameterMap
- 重新计算的参数Mappublic java.util.List recalculate(Report report, java.util.Map parameterMap, boolean reCalRF)
recalculate
在类中 AbstractResECWorkSheet
report
- 报表parameterMap
- 参数reCalRF
- 是否清空结果公式public void importStashData(JSONObject cellValues, JSONArray rows, JSONArray insertRows, JSONArray deleteRows, JSONObject cellValuesAssist)
importStashData
在接口中 DBWritable
cellValues
- 格子值rows
- 行insertRows
- 插入行deleteRows
- 删除行cellValuesAssist
- 格子值的辅助(决定格子值是公式还是编辑值)public void readXML(XMLableReader reader)
XMLReadable
readXML
在接口中 XMLReadable
readXML
在类中 AbstractECReport
reader
- XML读取对象XMLableReader
public void writeXML(XMLPrintWriter writer)
XMLWriter
writeXML
在接口中 XMLWriter
writeXML
在类中 AbstractECReport
writer
- XML写入对象public void shrinkToFitPaper(Calculator calculator)
shrinkToFitPaper
在接口中 ElementCase
shrinkToFitPaper
在类中 AbstractECReport
calculator
- 算子