public ChartBuilderHelper(IDocument document, ChartPlotArea chartPlotArea, CellRanges tableData)
{
this.m_document = document;
this.ChartPlotArea = chartPlotArea;
this.m_tableData = tableData;
startRowIndex = m_tableData.startcell.rowIndex;
endRowIndex = m_tableData.endcell.rowIndex;
startColumnIndex = m_tableData.startcell.columnIndex;
endColumnIndex = m_tableData.endcell.columnIndex;
table = new Table(m_document, "local-table", null);
DataTable = m_tableData.table;
}
/// <summary>
/// analyse the xml string which
/// contains the cell range of the data table
/// </summary>
/// <returns>CellRange</returns>
public CellRanges GetCellRangeFromXMLString()
{
CellRanges chartData = new CellRanges();
string cellrange = CellRange;
#region
if (!string.IsNullOrEmpty(cellrange))
{
int index1 = cellrange.IndexOf(".", 0);
if (index1 != -1)
{
string tableName = cellrange.Substring(0, index1);
Table dataTable = GetTable(tableName);
if (dataTable != null)
{
chartData.table = dataTable;
}
int index2 = cellrange.IndexOf(":", 0);
string startCell = cellrange.Substring((index1 + 1), index2 - index1 - 1);
CellPos StartCell = GetCellPos(startCell, dataTable);
chartData.startcell = StartCell;
int index3 = cellrange.IndexOf(".", (index1 + 1));
int length = cellrange.Length;
string endCell = cellrange.Substring((index3 + 1), length - index3 - 1);
CellPos EndCell = GetCellPos(endCell, dataTable);
chartData.endcell = EndCell;
TableData = chartData;
}
}
#endregion
return(chartData);
}
public ChartBuilderHelper(IDocument document, ChartPlotArea chartPlotArea, CellRanges tableData)
{
this.m_document = document;
this.ChartPlotArea = chartPlotArea;
this.m_tableData = tableData;
startRowIndex = m_tableData.startcell.rowIndex ;
endRowIndex = m_tableData.endcell .rowIndex ;
startColumnIndex = m_tableData.startcell .columnIndex ;
endColumnIndex = m_tableData.endcell .columnIndex ;
table = new Table (m_document ,"local-table",null);
DataTable = m_tableData.table ;
}
/// <summary>
/// analyse the xml string which
/// contains the cell range of the data table
/// </summary>
/// <returns>CellRange</returns>
public CellRanges GetCellRangeFromXMLString()
{
CellRanges chartData = new CellRanges ();
string cellrange = this.CellRange ;
#region
if (cellrange!=null&&cellrange!="")
{
int index1 = cellrange.IndexOf (".",0);
if (index1!=-1)
{
string tableName = cellrange.Substring (0,index1);
Table dataTable = GetTable(tableName);
if (dataTable!=null)
chartData.table =dataTable;
int index2 = cellrange.IndexOf (":",0);
string startCell = cellrange.Substring ((index1+1),index2-index1-1);
CellPos StartCell = GetCellPos(startCell,dataTable);
chartData.startcell =StartCell;
int index3 = cellrange.IndexOf (".",(index1+1));
int length = cellrange.Length ;
string endCell = cellrange.Substring ((index3+1),length-index3-1);
CellPos EndCell = GetCellPos(endCell,dataTable);
chartData.endcell = EndCell;
TableData = chartData;
}
}
#endregion
return chartData;
}
