Hi,
Am following this link for spreadsheet
https://ko.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet-configuring
when we click on particular row and apply filter it gives excel style filtering. now clicking on that filter it opens up the modal windows showing different events
i have couple of questions
1. can we configure this window to open on left or right side of cell(am showing spreadsheet in the pop up and that modal window is partially hiding for the first column)
2. when i click on sorting it is not doing any thing even in the example provided
3. when we click on filter can we get unique values for that column as in excel
When sorting information in a worksheet, you can rearrange the data to find values quickly. You can sort a range or table of data on one or more columns of data. For example, you can sort employees —first by department, and then by last name.
Hello Peru,
The Infragistics Excel Library and Spreadsheet control is on other .NET Core platforms like WPF, Windows Forms, etc., so you can use the library in a C# .NET Core application. Those platforms support .NET Core via NuGet, and you can read how to set up the NuGet feed by reading the following documentation: https://ko.infragistics.com/help/wpf/nuget-feeds.
Regarding the syntax for adding a table to a Worksheet, it is essentially the same properties, just in C# syntax. The APIs are the same between Ignite UI for Angular and our .NET Core platforms, but for example, this would be the code, where “sheet” is the Worksheet:
sheet.Tables.Add("A3:C11", true);
Please let me know if you have any other questions or concerns on this matter.
and one example for adding any default excel style table. documentation is hard to find without examples :)
thanks this helps a lot in customization.
A quick final question may not be related to topic.
can we use infragistics library with C# in .net core API ?(for purpose of creating excel)
The error that “the specified WorksheetTableStyle does not belong to the same workbook as the table” means that the string ID that you have passed to your table is not registered with the Workbook. You can use the following code snippet as guidance on creation of a WorkbookTableStyle:
let style: WorksheetTableStyle = new WorksheetTableStyle("myCustomTableStyle", true); sheet.workbook.customTableStyles().add(style);
let color: Color = new Color(); color.colorString = "#FF0000"; let colorInfo: WorkbookColorInfo = new WorkbookColorInfo(color);
style.areaFormats(WorksheetTableStyleArea.WholeTable).fill = CellFill.createSolidFill(colorInfo);
let table: WorksheetTable = sheet.tables().add(address, true, style);
Please let me know if have any other questions or concerns on this matter.