@using Winnovative.ExcelLib
@using SealExcelConverter
@{	
	//Full documentation of the converter at http://www.winnovative-software.com/excel-library.aspx
    ExcelConverter converter = Model;
    var page = converter.Page;
    var view = converter.View;

    //Chart: rowStart and colStart can be modified here to set an absolute or relative position of the items displayed...
    int rowStart = converter.CurrentRow;
    int colStart = converter.CurrentCol;
    //Target sheet can be changed here
    var currentSheet = converter.Sheet;
	//converter.Sheet =
converter.SetAdditionalSheet(converter.Sheet.Name + " " + view.Report.Repository.TranslateReport("Charts"), ref rowStart, ref colStart);

    if (view.Model.HasSerie && view.GetBoolValue(ExcelConverter.show_charts,
true))
    {
        var firstSerie = page.Series[0];

        ExcelChartType chartType = (firstSerie.Element.SerieDefinition == Seal.Model.SerieDefinition.Serie ?
ExcelConverter.ConvertChartType(page.Series[0].Element.SerieType) :
ExcelConverter.ConvertChartType(page.Series[0].Element.Nvd3Serie));
        ExcelChart chart = converter.Sheet.Charts.AddChart(chartType,
colStart, rowStart, colStart + converter.ChartWidth, rowStart + converter.ChartHeight);
        chart.Title.Text =
view.Report.TranslateGeneral(view.GetValue(ExcelConverter.chart_nvd3_title))
;

        rowStart += converter.ChartHeight;

        //Series Y values, support only of the Primary Axis...
        int serieIndex = 1;
        int colIndex = 0;
        foreach (var serie in page.Series)
        {
            colIndex = 0;
			foreach (var xDimensionKey in
page.PrimaryXValues.Keys)
			{
				//Find the corresponding serie value...
				var value = serie.Values.FirstOrDefault(i => i.XDimensionValues == xDimensionKey);
				if (value != null) {
					converter.SetValue(rowStart +
serieIndex, colStart + colIndex, value.Yvalue);
				}
                colIndex++;
			}
			
            ExcelChartSeries chartSerie = chart.Series.AddSeries(serie.SerieDisplayName);
            chartSerie.ChartType = chartType;
            chartSerie.CategoryNamesRange = converter.Sheet[rowStart, colStart, rowStart, colStart + page.PrimaryXValues.Keys.Count - 1];
            chartSerie.ValuesRange = converter.Sheet[rowStart + serieIndex, colStart, rowStart + serieIndex, colStart + page.PrimaryXValues.Keys.Count - 1];
            serieIndex++;
        }

        //Series X Values must be set after...
        colIndex = 0;
        foreach (var xValue in page.PrimaryXValues.Keys)
        {
            converter.Sheet[rowStart, colStart + colIndex].Value = page.PrimaryXValues[xValue];
            var xCells = xValue as Seal.Model.ResultCell[];
            if (xCells != null && converter.UseElementFormat)
            {
                converter.Sheet[rowStart, colStart + colIndex].Style.Number.NumberFormatString = xCells[0].Element.GetExcelFormat(view.CultureInfo);
            }
            colIndex++;
        }

        if (converter.Sheet == currentSheet) 
        {
            converter.CurrentRow += converter.ChartHeight + serieIndex + 1;
        }
    }
    converter.Sheet = currentSheet;
}