public interface FormulaEngine
Modifier and Type | Field and Description |
---|---|
static java.lang.String |
KEY_EXTERNAL_BOOK_NAMES |
static java.lang.String |
KEY_SHEET_INDEXES |
Modifier and Type | Method and Description |
---|---|
void |
clearCache(FormulaClearContext context) |
EvaluationResult |
evaluate(FormulaExpression expr,
FormulaEvaluationContext context) |
FormulaExpression |
extend(java.lang.String formula,
SheetRegion srcRegion,
boolean hrizontal,
FormulaParseContext context) |
FormulaExpression |
extendPtgs(FormulaExpression fexpr,
SheetRegion srcRegion,
boolean hrizontal,
FormulaParseContext context) |
FormulaExpression |
move(java.lang.String formula,
SheetRegion srcRegion,
int rowOffset,
int columnOffset,
FormulaParseContext context)
Shift the formula that care on sheet and region.
|
FormulaExpression |
movePtgs(FormulaExpression fexpr,
SheetRegion srcRegion,
int rowOffset,
int columnOffset,
FormulaParseContext context)
Shift the formula that care on sheet and region.
|
FormulaExpression |
parse(java.lang.String formula,
FormulaParseContext context) |
FormulaExpression |
renameColumnNameTablePtgs(FormulaExpression fexpr,
STable table,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
renameName(java.lang.String formula,
SBook book,
int sheetIndex,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
renameName(java.lang.String formula,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
renameNamePtgs(FormulaExpression fexpr,
SBook book,
int sheetIndex,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
renameSheet(java.lang.String formula,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
renameSheetPtgs(FormulaExpression fexpr,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
renameTableNameTablePtgs(FormulaExpression fexpr,
SBook book,
java.lang.String oldName,
java.lang.String newName,
FormulaParseContext context) |
FormulaExpression |
reorderSheetPtgs(FormulaExpression fexpr,
SBook book,
int oldIndex,
int newIndex,
FormulaParseContext context) |
FormulaExpression |
shift(java.lang.String formula,
int rowOffset,
int columnOffset,
FormulaParseContext context)
Shift the formula base on the offset
|
FormulaExpression |
shiftPtgs(FormulaExpression fexpr,
int rowOffset,
int columnOffset,
FormulaParseContext context)
Shift the formula base on the offset
|
FormulaExpression |
shrink(java.lang.String formula,
SheetRegion srcRegion,
boolean hrizontal,
FormulaParseContext context) |
FormulaExpression |
shrinkPtgs(FormulaExpression fexpr,
SheetRegion srcRegion,
boolean hrizontal,
FormulaParseContext context) |
FormulaExpression |
transpose(java.lang.String formula,
int rowOrigin,
int columnOrigin,
FormulaParseContext context)
Transpose the formula base one the origin
|
FormulaExpression |
transposePtgs(FormulaExpression fexpr,
int rowOrigin,
int columnOrigin,
FormulaParseContext context)
Transpose the formula base one the origin
|
void |
updateDependencyTable(FormulaExpression fexpr,
FormulaParseContext context) |
static final java.lang.String KEY_EXTERNAL_BOOK_NAMES
static final java.lang.String KEY_SHEET_INDEXES
FormulaExpression parse(java.lang.String formula, FormulaParseContext context)
FormulaExpression shift(java.lang.String formula, int rowOffset, int columnOffset, FormulaParseContext context)
formula
- rowOffset
- columnOffset
- context
- FormulaExpression transpose(java.lang.String formula, int rowOrigin, int columnOrigin, FormulaParseContext context)
formula
- rowOrigin
- columnOrigin
- context
- FormulaExpression move(java.lang.String formula, SheetRegion srcRegion, int rowOffset, int columnOffset, FormulaParseContext context)
formula
- srcRegion
- rowOffset
- columnOffset
- context
- FormulaExpression shrink(java.lang.String formula, SheetRegion srcRegion, boolean hrizontal, FormulaParseContext context)
FormulaExpression extend(java.lang.String formula, SheetRegion srcRegion, boolean hrizontal, FormulaParseContext context)
FormulaExpression renameSheet(java.lang.String formula, SBook book, java.lang.String oldName, java.lang.String newName, FormulaParseContext context)
FormulaExpression renameName(java.lang.String formula, SBook book, java.lang.String oldName, java.lang.String newName, FormulaParseContext context)
EvaluationResult evaluate(FormulaExpression expr, FormulaEvaluationContext context)
void clearCache(FormulaClearContext context)
FormulaExpression shiftPtgs(FormulaExpression fexpr, int rowOffset, int columnOffset, FormulaParseContext context)
formula
- rowOffset
- columnOffset
- context
- FormulaExpression transposePtgs(FormulaExpression fexpr, int rowOrigin, int columnOrigin, FormulaParseContext context)
formula
- rowOrigin
- columnOrigin
- context
- FormulaExpression movePtgs(FormulaExpression fexpr, SheetRegion srcRegion, int rowOffset, int columnOffset, FormulaParseContext context)
formula
- srcRegion
- rowOffset
- columnOffset
- context
- FormulaExpression shrinkPtgs(FormulaExpression fexpr, SheetRegion srcRegion, boolean hrizontal, FormulaParseContext context)
fexpr
- srcRegion
- hrizontal
- context
- FormulaExpression extendPtgs(FormulaExpression fexpr, SheetRegion srcRegion, boolean hrizontal, FormulaParseContext context)
fexpr
- srcRegion
- hrizontal
- context
- FormulaExpression renameSheetPtgs(FormulaExpression fexpr, SBook book, java.lang.String oldName, java.lang.String newName, FormulaParseContext context)
fexpr
- book
- oldName
- newName
- context
- FormulaExpression renameNamePtgs(FormulaExpression fexpr, SBook book, int sheetIndex, java.lang.String oldName, java.lang.String newName, FormulaParseContext context)
fexpr
- book
- oldName
- newName
- context
- FormulaExpression renameName(java.lang.String formula, SBook book, int sheetIndex, java.lang.String oldName, java.lang.String newName, FormulaParseContext context)
formula
- book
- sheetIndex
- oldName
- newName
- context
- void updateDependencyTable(FormulaExpression fexpr, FormulaParseContext context)
fexpr
- context
- FormulaExpression reorderSheetPtgs(FormulaExpression fexpr, SBook book, int oldIndex, int newIndex, FormulaParseContext context)
fexpr
- book
- oldName
- newName
- context
- FormulaExpression renameTableNameTablePtgs(FormulaExpression fexpr, SBook book, java.lang.String oldName, java.lang.String newName, FormulaParseContext context)
fexpr
- oldName
- newName
- context
- FormulaExpression renameColumnNameTablePtgs(FormulaExpression fexpr, STable table, java.lang.String oldName, java.lang.String newName, FormulaParseContext context)
fexpr
- tableName
- oldName
- newName
- context
- Copyright © 2005-2010 Potix Corporation. All Rights Reserved.