Package | Description |
---|---|
org.apache.poi.hssf.model |
Provides low level API structures for reading, writing, modifying XLS files.
|
org.apache.poi.hssf.record.aggregates |
record aggregates are not real "records" but collections of records that act as a single record.
|
org.apache.poi.hssf.usermodel.helpers | |
org.apache.poi.ss.formula |
This package contains common internal POI code for manipulating formulas.
|
org.apache.poi.ss.usermodel.helpers | |
org.apache.poi.xssf.usermodel.helpers |
Modifier and Type | Method and Description |
---|---|
void |
InternalSheet.updateFormulasAfterCellShift(FormulaShifter shifter,
int externSheetIndex)
Updates formulas in cells and conditional formats due to moving of cells
|
void |
InternalWorkbook.updateNamesAfterCellShift(FormulaShifter shifter)
Updates named ranges due to moving of cells
|
Modifier and Type | Method and Description |
---|---|
boolean |
CFRecordsAggregate.updateFormulasAfterCellShift(FormulaShifter shifter,
int currentExternSheetIx) |
void |
ConditionalFormattingTable.updateFormulasAfterCellShift(FormulaShifter shifter,
int externSheetIndex) |
void |
RowRecordsAggregate.updateFormulasAfterRowShift(FormulaShifter formulaShifter,
int currentExternSheetIndex) |
void |
ValueRecordsAggregate.updateFormulasAfterRowShift(FormulaShifter shifter,
int currentExternSheetIndex) |
Modifier and Type | Method and Description |
---|---|
void |
HSSFRowShifter.updateConditionalFormatting(FormulaShifter shifter) |
void |
HSSFRowShifter.updateFormulas(FormulaShifter shifter) |
void |
HSSFRowShifter.updateHyperlinks(FormulaShifter shifter) |
void |
HSSFRowShifter.updateNamedRanges(FormulaShifter shifter) |
void |
HSSFRowShifter.updateRowFormulas(Row row,
FormulaShifter shifter) |
Modifier and Type | Method and Description |
---|---|
static FormulaShifter |
FormulaShifter.createForRowCopy(int externSheetIndex,
java.lang.String sheetName,
int firstMovedRowIndex,
int lastMovedRowIndex,
int numberOfRowsToMove,
SpreadsheetVersion version) |
static FormulaShifter |
FormulaShifter.createForRowShift(int externSheetIndex,
java.lang.String sheetName,
int firstMovedRowIndex,
int lastMovedRowIndex,
int numberOfRowsToMove,
SpreadsheetVersion version) |
static FormulaShifter |
FormulaShifter.createForSheetShift(int srcSheetIndex,
int dstSheetIndex) |
Modifier and Type | Method and Description |
---|---|
abstract void |
RowShifter.updateConditionalFormatting(FormulaShifter shifter) |
abstract void |
RowShifter.updateFormulas(FormulaShifter shifter)
Update formulas.
|
abstract void |
RowShifter.updateHyperlinks(FormulaShifter shifter)
Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink
is of type LINK_DOCUMENT and refers to a cell that was shifted).
|
abstract void |
RowShifter.updateNamedRanges(FormulaShifter shifter)
Updated named ranges
|
abstract void |
RowShifter.updateRowFormulas(Row row,
FormulaShifter shifter)
Update the formulas in specified row using the formula shifting policy specified by shifter
|
Modifier and Type | Method and Description |
---|---|
void |
XSSFRowShifter.updateConditionalFormatting(FormulaShifter shifter) |
void |
XSSFRowShifter.updateFormulas(FormulaShifter shifter)
Update formulas.
|
void |
XSSFRowShifter.updateHyperlinks(FormulaShifter shifter)
Shift the Hyperlink anchors (not the hyperlink text, even if the hyperlink
is of type LINK_DOCUMENT and refers to a cell that was shifted).
|
void |
XSSFRowShifter.updateNamedRanges(FormulaShifter shifter)
Updated named ranges
|
void |
XSSFRowShifter.updateRowFormulas(Row row,
FormulaShifter shifter)
Update the formulas in specified row using the formula shifting policy specified by shifter
|
Copyright 2023 The Apache Software Foundation or its licensors, as applicable.