public void Copy(Worksheet src, int fromRow, int fromColumn, int toRow, int toColumn, int rowCount, int columnCount)
{
if (object.ReferenceEquals(src, this.Sheet))
{
this.Copy(fromRow, fromColumn, toRow, toColumn, rowCount, columnCount);
}
else
{
int offsetRow = toRow - fromRow;
int offsetColumn = toColumn - fromColumn;
for (int i = 0; i < rowCount; i++)
{
for (int j = 0; j < columnCount; j++)
{
Sparkline sparkline = src.GetSparkline(fromRow + i, fromColumn + j);
if (sparkline != null)
{
Sparkline sparkline2 = sparkline.Clone();
sparkline2.Row = toRow + i;
sparkline2.Column = toColumn + j;
CalcExpression dateAxisReference = sparkline2.DateAxisReference;
if (dateAxisReference != null)
{
if (CanOffset(dateAxisReference, offsetRow, offsetColumn, ((Worksheet)this.Sheet).RowCount, ((Worksheet)this.Sheet).ColumnCount))
{
sparkline2.DateAxisReference = dateAxisReference.Offset(offsetRow, offsetColumn, false, true);
}
else
{
sparkline2.DateAxisReference = new CalcErrorExpression(CalcErrors.Reference);
}
}
CalcExpression dataReference = sparkline2.DataReference;
if (dataReference != null)
{
if (CanOffset(dataReference, offsetRow, offsetColumn, ((Worksheet)this.Sheet).RowCount, ((Worksheet)this.Sheet).ColumnCount))
{
sparkline2.DataReference = dataReference.Offset(offsetRow, offsetColumn, false, true);
}
else
{
sparkline2.DataReference = new CalcErrorExpression(CalcErrors.Reference);
}
}
this.Add(sparkline2.Group);
this.Sheet.SetSparkline(toRow + i, toColumn + j, sparkline2);
}
else
{
this.Sheet.SetSparkline(toRow + i, toColumn + j, null);
}
}
}
}
}
public void Copy(int fromRow, int fromColumn, int toRow, int toColumn, int rowCount, int columnCount)
{
DataMatrix <Sparkline> matrix = new DataMatrix <Sparkline>(rowCount, columnCount);
int offsetRow = toRow - fromRow;
int offsetColumn = toColumn - fromColumn;
for (int i = 0; i < rowCount; i++)
{
for (int k = 0; k < columnCount; k++)
{
Sparkline sparkline = this.Sheet.GetSparkline(fromRow + i, fromColumn + k);
if (sparkline != null)
{
Sparkline sparkline2 = sparkline.Clone();
sparkline2.Row = toRow + i;
sparkline2.Column = toColumn + k;
CalcExpression dateAxisReference = sparkline2.DateAxisReference;
if (dateAxisReference != null)
{
if (CanOffset(dateAxisReference, offsetRow, offsetColumn, ((Worksheet)this.Sheet).RowCount, ((Worksheet)this.Sheet).ColumnCount))
{
sparkline2.DateAxisReference = dateAxisReference.Offset(offsetRow, offsetColumn, false, true);
}
else
{
sparkline2.DateAxisReference = new CalcErrorExpression(CalcErrors.Reference);
}
}
CalcExpression dataReference = sparkline2.DataReference;
if (dataReference != null)
{
if (CanOffset(dataReference, offsetRow, offsetColumn, ((Worksheet)this.Sheet).RowCount, ((Worksheet)this.Sheet).ColumnCount))
{
sparkline2.DataReference = dataReference.Offset(offsetRow, offsetColumn, false, true);
}
else
{
sparkline2.DataReference = new CalcErrorExpression(CalcErrors.Reference);
}
}
this.Add(sparkline2.Group);
matrix.SetValue(i, k, sparkline2);
}
}
}
for (int j = 0; j < rowCount; j++)
{
for (int m = 0; m < columnCount; m++)
{
this.Sheet.SetSparkline(toRow + j, toColumn + m, matrix.GetValue(j, m));
}
}
}
