private RadDocument GenerateRadDocument()
{
var export = pivot.GenerateExport();
int rowCount = export.RowCount;
int columnCount = export.ColumnCount;
RadDocument document = new RadDocument();
document.SectionDefaultPageMargin = new Telerik.Windows.Documents.Layout.Padding(10);
document.LayoutMode = DocumentLayoutMode.Paged;
document.SectionDefaultPageOrientation = PageOrientation.Landscape;
document.Style.SpanProperties.FontFamily = pivot.FontFamily;
document.Style.SpanProperties.FontSize = pivot.FontSize;
document.Style.ParagraphProperties.SpacingAfter = 0;
var section = new Telerik.Windows.Documents.Model.Section();
document.Sections.Add(section);
section.Blocks.Add(new Telerik.Windows.Documents.Model.Paragraph());
var table = new Telerik.Windows.Documents.Model.Table(rowCount, columnCount);
section.Blocks.Add(table);
var tableRows = table.Rows.ToArray();
foreach (var cellInfo in export.Cells)
{
int rowStartIndex = cellInfo.Row;
int rowEndIndex = rowStartIndex + cellInfo.RowSpan - 1;
int columnStartIndex = cellInfo.Column;
int columnEndIndex = columnStartIndex + cellInfo.ColumnSpan - 1;
var value = cellInfo.Value;
var text = Convert.ToString(value);
if (!string.IsNullOrWhiteSpace(text))
{
var cells = tableRows[rowStartIndex].Cells.ToArray();
var cell = cells[columnStartIndex];
Paragraph paragraph = new Paragraph();
cell.Blocks.Add(paragraph);
var span = new Span(text);
paragraph.Inlines.Add(span);
paragraph.TextAlignment = GetTextAlignment(cellInfo.TextAlignment);
if (cellInfo.FontWeight.HasValue)
{
span.FontWeight = cellInfo.FontWeight.Value;
}
Color foreColor;
if (GetColor(cellInfo.Foreground, out foreColor))
{
span.ForeColor = foreColor;
}
cell.VerticalAlignment = GetVerticalAlignment(cellInfo.VerticalAlignment);
paragraph.LeftIndent = cellInfo.Indent * 20;
}
var borderThickness = cellInfo.BorderThickness;
var borderBrush = cellInfo.BorderBrush;
var background = cellInfo.Background;
Color backColor;
bool hasBackground = GetColor(cellInfo.Background, out backColor);
if (cellInfo.RowSpan > 1 && cellInfo.ColumnSpan > 1)
{
for (int k = rowStartIndex; k <= rowEndIndex; k++)
{
var cells = tableRows[k].Cells.ToArray();
for (int j = columnStartIndex; j <= columnEndIndex; j++)
{
var cell = cells[j];
if (hasBackground)
{
cell.Background = backColor;
}
cell.Borders = GetCellBorders(borderThickness, borderBrush, cell.Borders, k, rowStartIndex, rowEndIndex, j, columnStartIndex, columnEndIndex, hasBackground);
}
}
}
else if (cellInfo.RowSpan > 1)
{
for (int j = rowStartIndex; j <= rowEndIndex; j++)
{
// TODO: check when ColumnSpan > 1;
var cell = tableRows[j].Cells.ToArray()[columnStartIndex];
Position position = j == rowStartIndex ? Position.First : ((j == rowEndIndex) ? Position.Last : Position.Middle);
cell.Borders = GetCellBorders(borderThickness, borderBrush, position, cell.Borders, true, cellInfo.Background != null);
if (hasBackground)
{
cell.Background = backColor;
}
}
}
else if (cellInfo.ColumnSpan > 1)
{
var cells = tableRows[rowStartIndex].Cells.ToArray();
for (int j = columnStartIndex; j <= columnEndIndex; j++)
{
// TODO: check when RowSpan > 1;
var cell = cells[j];
Position position = j == columnStartIndex ? Position.First : ((j == columnEndIndex) ? Position.Last : Position.Middle);
if (hasBackground)
{
cell.Background = backColor;
}
cell.Borders = GetCellBorders(borderThickness, borderBrush, position, cell.Borders, false, hasBackground);
}
}
}
return(document);
}
private RadDocument GenerateRadDocument()
{
var export = pivot.GenerateExport();
int rowCount = export.RowCount;
int columnCount = export.ColumnCount;
RadDocument document = new RadDocument();
document.SectionDefaultPageMargin = new Telerik.Windows.Documents.Layout.Padding(10);
document.LayoutMode = DocumentLayoutMode.Paged;
document.SectionDefaultPageOrientation = PageOrientation.Landscape;
document.Style.SpanProperties.FontFamily = pivot.FontFamily;
document.Style.SpanProperties.FontSize = pivot.FontSize;
document.Style.ParagraphProperties.SpacingAfter = 0;
var section = new Telerik.Windows.Documents.Model.Section();
document.Sections.Add(section);
section.Blocks.Add(new Telerik.Windows.Documents.Model.Paragraph());
var table = new Telerik.Windows.Documents.Model.Table(rowCount, columnCount);
section.Blocks.Add(table);
var tableRows = table.Rows.ToArray();
foreach (var cellInfo in export.Cells)
{
int rowStartIndex = cellInfo.Row;
int rowEndIndex = rowStartIndex + cellInfo.RowSpan - 1;
int columnStartIndex = cellInfo.Column;
int columnEndIndex = columnStartIndex + cellInfo.ColumnSpan - 1;
var value = cellInfo.Value;
var text = Convert.ToString(value);
if (!string.IsNullOrWhiteSpace(text))
{
var cells = tableRows[rowStartIndex].Cells.ToArray();
var cell = cells[columnStartIndex];
Paragraph paragraph = new Paragraph();
cell.Blocks.Add(paragraph);
var span = new Span(text);
paragraph.Inlines.Add(span);
paragraph.TextAlignment = GetTextAlignment(cellInfo.TextAlignment);
if (cellInfo.FontWeight.HasValue)
{
span.FontWeight = cellInfo.FontWeight.Value;
}
Color foreColor;
if (GetColor(cellInfo.Foreground, out foreColor))
{
span.ForeColor = foreColor;
}
cell.VerticalAlignment = GetVerticalAlignment(cellInfo.VerticalAlignment);
paragraph.LeftIndent = cellInfo.Indent * 20;
}
var borderThickness = cellInfo.BorderThickness;
var borderBrush = cellInfo.BorderBrush;
var background = cellInfo.Background;
Color backColor;
bool hasBackground = GetColor(cellInfo.Background, out backColor);
if (cellInfo.RowSpan > 1 && cellInfo.ColumnSpan > 1)
{
for (int k = rowStartIndex; k <= rowEndIndex; k++)
{
var cells = tableRows[k].Cells.ToArray();
for (int j = columnStartIndex; j <= columnEndIndex; j++)
{
var cell = cells[j];
if (hasBackground)
{
cell.Background = backColor;
}
cell.Borders = GetCellBorders(borderThickness, borderBrush, cell.Borders, k, rowStartIndex, rowEndIndex, j, columnStartIndex, columnEndIndex, hasBackground);
}
}
}
else if (cellInfo.RowSpan > 1)
{
for (int j = rowStartIndex; j <= rowEndIndex; j++)
{
// TODO: check when ColumnSpan > 1;
var cell = tableRows[j].Cells.ToArray()[columnStartIndex];
Position position = j == rowStartIndex ? Position.First : ((j == rowEndIndex) ? Position.Last : Position.Middle);
cell.Borders = GetCellBorders(borderThickness, borderBrush, position, cell.Borders, true, cellInfo.Background != null);
if (hasBackground)
{
cell.Background = backColor;
}
}
}
else if (cellInfo.ColumnSpan > 1)
{
var cells = tableRows[rowStartIndex].Cells.ToArray();
for (int j = columnStartIndex; j <= columnEndIndex; j++)
{
// TODO: check when RowSpan > 1;
var cell = cells[j];
Position position = j == columnStartIndex ? Position.First : ((j == columnEndIndex) ? Position.Last : Position.Middle);
if (hasBackground)
{
cell.Background = backColor;
}
cell.Borders = GetCellBorders(borderThickness, borderBrush, position, cell.Borders, false, hasBackground);
}
}
}
return document;
}
