public void SetValuesCellRange(CellRangeAddressBase range) { int count = SetVerticalCellRange(dataValues, range); series.NumValues = (short)count; }
public void SetCategoryLabelsCellRange(CellRangeAddressBase range) { int count = SetVerticalCellRange(dataCategoryLabels, range); series.NumCategories = (short)count; }
private int SetVerticalCellRange(LinkedDataRecord linkedDataRecord, CellRangeAddressBase range) { if (linkedDataRecord == null) { throw new ArgumentNullException("linkedDataRecord should not be null"); ; } List<Ptg> ptgList = new List<Ptg>(); int rowCount = (range.LastRow - range.FirstRow) + 1; int colCount = (range.LastColumn - range.FirstColumn) + 1; foreach (Ptg ptg in linkedDataRecord.FormulaOfLink) { if (ptg is AreaPtgBase) { AreaPtgBase areaPtg = (AreaPtgBase)ptg; areaPtg.FirstRow = range.FirstRow; areaPtg.LastRow = range.LastRow; areaPtg.FirstColumn = range.FirstColumn; areaPtg.LastColumn = range.LastColumn; ptgList.Add(areaPtg); } } linkedDataRecord.FormulaOfLink = (ptgList.ToArray()); return rowCount * colCount; }