private void Spreadsheet_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args) { foreach (var sheet in args.GridCollection) { sheet.FillSeriesController.AllowFillSeries = false; } }
private void Spreadsheet_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args) { foreach (var sheet in args.GridCollection) { if (sheet.Worksheet.AutoFilters.FilterRange != null) { sheet.Worksheet.AutoFilters.FilterRange = null; } } }
//To freeze 5 rows and 3 columns. private void SpreadSheetControl_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args) { //To maintain the freeze state in saved work sheet. spreadSheetControl.Workbook.ActiveSheet.Range[5, 3].FreezePanes(); //To freeze the rows and columns in the view var gridModel = spreadSheetControl.ActiveGrid; gridModel.FrozenColumns = 3; gridModel.FrozenRows = 5; }
private void AssociatedObject_WorkbookLoaded(object sender, Syncfusion.UI.Xaml.Spreadsheet.Helpers.WorkbookLoadedEventArgs args) { foreach (var grid in args.GridCollection) { grid.CreateGridColumn = CreateSpreadsheetColumnExt; var renderer = new SpreadsheetTemplateCellRenderer(); grid.CellRenderers.Add("ArrowTemplate", renderer); grid.QueryRange += Grid_QueryRange; AssociatedObject.SetRowColumnHeadersVisibility(false); } AssociatedObject.Protect(true, true, ""); AssociatedObject.ProtectSheet(AssociatedObject.ActiveSheet, "", Syncfusion.XlsIO.ExcelSheetProtection.None); }