internal X14.Sparkline ToSparkline()
{
X14.Sparkline spk = new X14.Sparkline();
if (this.StartRowIndex == this.EndRowIndex && this.StartColumnIndex == this.EndColumnIndex)
{
spk.Formula = new Excel.Formula();
spk.Formula.Text = SLTool.ToCellReference(this.WorksheetName, this.StartRowIndex, this.StartColumnIndex);
}
else
{
spk.Formula = new Excel.Formula();
spk.Formula.Text = SLTool.ToCellRange(this.WorksheetName, this.StartRowIndex, this.StartColumnIndex, this.EndRowIndex, this.EndColumnIndex);
}
spk.ReferenceSequence = new Excel.ReferenceSequence();
spk.ReferenceSequence.Text = SLTool.ToCellReference(this.LocationRowIndex, this.LocationColumnIndex);
return(spk);
}
internal X14.Sparkline ToSparkline()
{
X14.Sparkline spk = new X14.Sparkline();
if (this.StartRowIndex == this.EndRowIndex && this.StartColumnIndex == this.EndColumnIndex)
{
spk.Formula = new Excel.Formula();
spk.Formula.Text = SLTool.ToCellReference(this.WorksheetName, this.StartRowIndex, this.StartColumnIndex);
}
else
{
spk.Formula = new Excel.Formula();
spk.Formula.Text = SLTool.ToCellRange(this.WorksheetName, this.StartRowIndex, this.StartColumnIndex, this.EndRowIndex, this.EndColumnIndex);
}
spk.ReferenceSequence = new Excel.ReferenceSequence();
spk.ReferenceSequence.Text = SLTool.ToCellReference(this.LocationRowIndex, this.LocationColumnIndex);
return spk;
}
internal X14.Sparkline ToSparkline()
{
var spk = new X14.Sparkline();
if ((StartRowIndex == EndRowIndex) && (StartColumnIndex == EndColumnIndex))
{
spk.Formula = new Formula();
spk.Formula.Text = SLTool.ToCellReference(WorksheetName, StartRowIndex, StartColumnIndex);
}
else
{
spk.Formula = new Formula();
spk.Formula.Text = SLTool.ToCellRange(WorksheetName, StartRowIndex, StartColumnIndex, EndRowIndex,
EndColumnIndex);
}
spk.ReferenceSequence = new ReferenceSequence();
spk.ReferenceSequence.Text = SLTool.ToCellReference(LocationRowIndex, LocationColumnIndex);
return(spk);
}
