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; }