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; }