protected override void RenderFooter(ExtendedXlsFile xls)
{
UsedRows++;
xls.SetCellValueStyled(UsedRows, InternalData.HeaderColumnNumbers[HeaderBal0LogicalParts.BalPartName], "Всего по " + Data.Name, TFlxFontStyles.Bold);
xls.MergeCells(UsedRows,
InternalData.HeaderColumnNumbers[HeaderBal0LogicalParts.BalPartName],
UsedRows,
InternalData.HeaderColumnNumbers[HeaderBal0LogicalParts.InputSumm] - 1);
RenderSummaryBehavior behav = new RenderSummaryBehavior(this, TFlxFontStyles.Bold);
behav.RenderSummary(xls, GetInnerFirstEntryFormulas);
if (Data.IsGroupUseInGeneralBalance)
{
behav.AddSummaryFormulas(xls, GetInnerFirstEntryFormulas);
}
if (Data.IsGroupUseInRelative)
{
UsedCols = InternalData.HeaderColumnNumbers[HeaderBal0LogicalParts.InputSumm] - 1;
for (int i = 0; i < InternalData.NumbersValues; i++)
{
UsedCols++;
AddCellToFormula(InternalData.IntervalFormulUids[i].SummBalPartSaldoForLossesDivider,
UsedCols + 2, GetUsedRows(), GetInnerFirstEntryFormulas(InternalData.IntervalFormulUids[i].SummSaldoForPs).DoubleRepresentation(), Model.Formula.EnumExcelFormulaOperators.Minus);
UsedCols++;
UsedCols++;
}
}
SetBorderAllCellsInBlock(xls, Color.Gray, TFlxBorderStyle.Dotted);
}
protected override void RenderFooter(ExtendedXlsFile xls)
{
xls.SetRowOutlineLevel(StartRow + 1, UsedRows, 1);
UsedRows++;
xls.SetCellValueStyled(UsedRows, NestingLevel, "Итого по " + Data, TFlxFontStyles.Bold);
xls.MergeCells(UsedRows, NestingLevel, UsedRows, InternalData.HeaderColumnNumbers[HeaderBal0LogicalParts.InputSumm] - 1);
RenderSummaryBehavior behav = new RenderSummaryBehavior(this, TFlxFontStyles.Bold);
behav.RenderSummary(xls, GetInnerFirstEntryFormulas);
//behav.AddSummaryFormulas(xls);
}