private LinkedDataRecord CreateValuesLinkedDataRecord()
{
LinkedDataRecord r = new LinkedDataRecord();
r.SetLinkType( LinkedDataRecord.LINK_TYPE_VALUES );
r.SetReferenceType( LinkedDataRecord.REFERENCE_TYPE_WORKSHEET );
r.SetCustomNumberFormat( false );
r.SetIndexNumberFmtRecord( (short) 0 );
Area3DPtg p = new Area3DPtg(0, 31, 0, 0,
false, false, false, false, 0);
r.SetFormulaOfLink(new Ptg[] { p, });
return r;
}
private LinkedDataRecord CreateTitleLinkedDataRecord()
{
LinkedDataRecord r = new LinkedDataRecord();
r.SetLinkType( LinkedDataRecord.LINK_TYPE_TITLE_OR_TEXT );
r.SetReferenceType( LinkedDataRecord.REFERENCE_TYPE_DIRECT );
r.SetCustomNumberFormat( false );
r.SetIndexNumberFmtRecord( (short) 0 );
r.SetFormulaOfLink(null);
return r;
}
private Integer SetVerticalCellRange(LinkedDataRecord linkedDataRecord,
CellRangeAddressBase range) {
if (linkedDataRecord == null)
{
return null;
}
List<Ptg> ptgList = new ArrayList<Ptg>();
int rowCount = (range.GetLastRow() - range.GetFirstRow()) + 1;
int colCount = (range.GetLastColumn() - range.GetFirstColumn()) + 1;
for (Ptg ptg : linkedDataRecord.GetFormulaOfLink()) {
if (ptg is AreaPtgBase) {
AreaPtgBase areaPtg = (AreaPtgBase) ptg;
areaPtg.SetFirstRow(range.GetFirstRow());
areaPtg.SetLastRow(range.GetLastRow());
areaPtg.SetFirstColumn(range.GetFirstColumn());
areaPtg.SetLastColumn(range.GetLastColumn());
ptgList.Add(areaPtg);
}
}
linkedDataRecord.SetFormulaOfLink(ptgList.ToArray(new Ptg[ptgList.Size()]));
return rowCount * colCount;
}
