Class SharedValueManager
java.lang.Object
org.apache.poi.hssf.record.aggregates.SharedValueManager
Manages various auxiliary records while constructing a
RowRecordsAggregate
:
- Author:
- Josh Micich, Vladimirs Abramovs(Vladimirs.Abramovs at exigenservices.com) - handling of ArrayRecords
-
Method Summary
Modifier and TypeMethodDescriptionvoid
Add specified Array Record.static SharedValueManager
create
(SharedFormulaRecord[] sharedFormulaRecords, CellReference[] firstCells, ArrayRecord[] arrayRecords, TableRecord[] tableRecords) static SharedValueManager
getArrayRecord
(int firstRow, int firstColumn) Gets theSharedValueRecordBase
record if it should be encoded immediately after the formula record contained in the specifiedFormulaRecordAggregate
agg.linkSharedFormulaRecord
(CellReference firstCell, FormulaRecordAggregate agg) removeArrayFormula
(int rowIndex, int columnIndex) Removes theArrayRecord
for the cell group containing the specified cell.void
unlink
(SharedFormulaRecord sharedFormulaRecord) Converts allFormulaRecord
s handled by sharedFormulaRecord to plain unshared formulas
-
Method Details
-
createEmpty
- Returns:
- a new empty
SharedValueManager
.
-
getRecordForFirstCell
Gets theSharedValueRecordBase
record if it should be encoded immediately after the formula record contained in the specifiedFormulaRecordAggregate
agg. Note - the shared value record always appears after the first formula record in the group. For arrays and tables the first formula is always the in the top left cell. However, since shared formula groups can be sparse and/or overlap, the first formula may not actually be in the top left cell.- Returns:
- the SHRFMLA, TABLE or ARRAY record for the formula cell, if it is the first cell of
a table or array region.
null
if the formula cell is not shared/array/table, or if the specified formula is not the the first in the group.
-
addArrayRecord
Add specified Array Record. -
removeArrayFormula
Removes theArrayRecord
for the cell group containing the specified cell. The caller should clear (set blank) all cells in the returned range.- Returns:
- the range of the array formula which was just removed. Never
null
.
-
getArrayRecord
- Returns:
- the shared ArrayRecord identified by (firstRow, firstColumn). never
null
.
-