private static void AddTreeTable(
this CellCursor cursor,
TreeTable treeTable,
ReportToWorkbookProjectionContext context,
PassKind passKind)
{
if (passKind == PassKind.Formatting)
{
// Format whole table
cursor.CanvassedRange.ApplyTableFormat(treeTable.Format);
// Format columns
var tableColumns = treeTable.TableColumns;
var topLeftDataCellReference = cursor.HasMarker(TopLeftDataCellMarker) ? cursor.GetMarkedCellReference(TopLeftDataCellMarker) : null;
var bottomRightNonSummaryDataCellReference = cursor.HasMarker(BottomRightNonSummaryDataCellMarker) ? cursor.GetMarkedCellReference(BottomRightNonSummaryDataCellMarker) : null;
var bottomRightHeaderCellReference = cursor.HasMarker(BottomRightHeaderCellMarker) ? cursor.GetMarkedCellReference(BottomRightHeaderCellMarker) : null;
foreach (var column in tableColumns.Columns)
{
var wholeColumnRange = cursor.Worksheet.GetRange(cursor.RowNumber, cursor.MaxRowNumber, cursor.ColumnNumber, cursor.ColumnNumber);
// ReSharper disable once PossibleNullReferenceException
var dataCellsRange = topLeftDataCellReference == null
? null
: cursor.Worksheet.GetRange(topLeftDataCellReference.RowNumber, bottomRightNonSummaryDataCellReference.RowNumber, cursor.ColumnNumber, cursor.ColumnNumber);
var lastHeaderCellToLastNonSummaryDataCellRange = bottomRightHeaderCellReference == null
? null
: dataCellsRange == null
? null
: cursor.Worksheet.GetRange(bottomRightHeaderCellReference.RowNumber, bottomRightNonSummaryDataCellReference.RowNumber, cursor.ColumnNumber, cursor.ColumnNumber);
// Individual column format will override the format applied to all table columns,
// that's why we first apply the table columns format and then the individual column's format.
wholeColumnRange.ApplyColumnFormat(dataCellsRange, lastHeaderCellToLastNonSummaryDataCellRange, tableColumns.ColumnsFormat);
wholeColumnRange.ApplyColumnFormat(dataCellsRange, lastHeaderCellToLastNonSummaryDataCellRange, column.Format);
cursor.MoveRight();
}
cursor.ResetColumn();
}
// Add rows
cursor.AddTableRows(treeTable.TableRows, context, passKind);
}
private static void AddRow(
this CellCursor cursor,
DataStructure.Row row,
ReportToWorkbookProjectionContext context,
PassKind passKind,
DataRowsFormat dataRowsFormat)
{
cursor.AddRowBase(row, context, passKind);
if (cursor.HasMarker(BottomRightNonSummaryDataCellMarker))
{
cursor.RemoveMarker(BottomRightNonSummaryDataCellMarker);
}
cursor.AddMarker(BottomRightNonSummaryDataCellMarker);
if ((row.ChildRows != null) && row.ChildRows.Any())
{
foreach (var childRow in row.ChildRows)
{
cursor.ResetColumn();
cursor.MoveDown();
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyDataRowsFormat(dataRowsFormat);
}
cursor.AddRow(childRow, context, passKind, dataRowsFormat);
}
}
if (row.CollapsedSummaryRows != null && row.CollapsedSummaryRows.Any())
{
throw new NotSupportedException("collapsed summary rows are not supported");
}
if (row.ExpandedSummaryRows != null)
{
foreach (var expandedSummaryRow in row.ExpandedSummaryRows)
{
cursor.ResetColumn();
cursor.MoveDown();
if (passKind == PassKind.Formatting)
{
cursor.CanvassedRowRange.ApplyDataRowsFormat(dataRowsFormat);
}
cursor.AddFlatRow(expandedSummaryRow, context, passKind);
}
}
}