public void AfterTotalsRender(DataSourcePanelEventArgs args)
{
//args.Range.Range(1, 7, 1, 9).Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Right;
//IXLRange mergedRange = args.Range.Range(1, 1, 1, 6).Merge();
//mergedRange.Value = "Totals";
//mergedRange.Style.Alignment.Horizontal = XLAlignmentHorizontalValues.Left;
}
public void TestExcelDynamicPaneAfterRender(DataSourcePanelEventArgs args)
{
args.Range.Style.Fill.BackgroundColor = XLColor.TractorRed;
}
public void TestExcelDynamicPaneAfterTotalsRender(DataSourcePanelEventArgs args)
{
args.Range.Cells().ElementAt(5).Style.NumberFormat.Format = "$ #,0.00";
}
public void TestExcelDynamicPanelAfterTotalsTemplatesRender(DataSourcePanelEventArgs args)
{
args.Range.Style.Border.OutsideBorder = XLBorderStyleValues.Dashed;
args.Range.Style.Border.OutsideBorderColor = XLColor.Green;
}
public void TestExcelDynamicPanelAfterDataRender(DataSourcePanelEventArgs args)
{
args.Range.Style.Border.InsideBorder = args.Range.Style.Border.OutsideBorder = XLBorderStyleValues.Thin;
args.Range.Style.Border.InsideBorderColor = args.Range.Style.Border.OutsideBorderColor = XLColor.Orange;
}
public void TestExcelTotalsPanelAfterRender(DataSourcePanelEventArgs args)
{
args.Range.FirstCell().Value = "Changed plain text";
}
public void TestExcelDataSourcePanelAfterRender(DataSourcePanelEventArgs args)
{
args.Range.Style.Border.OutsideBorder = XLBorderStyleValues.Thin;
}
