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
Adding an example of how the spreadsheet filter appears in the igx modal pop up outside the spreadsheet and also outside the igxmodal
Hello Peru,
My team and I have done an initial review of this forum thread, and I have a few questions for you on this matter, as I am a little unsure of a few things on this. Can you please provide some information on the following?
1. You mentioned a “modal window” in your description – is the IgxSpreadsheet within one of your modal windows, or is the modal window just something you are opening in response to actions on the spreadsheet, and it is cutting off the filter dialog / context menu of the spreadsheet?
2. Which “window” are you trying to configure the opening position in point 1 of your original description? Are you referring to the drop-down menu or context menu that happens when you click the icon at the top of the cell? I cannot quite tell from your screenshot.
3. Regarding your point 2 in that the sorting is not working for you, I cannot reproduce the sorting not working in the example you linked. If I right click one of the cells and choose one of the sort options, this works on my end. Being that I can see in the screenshot that you have drop-downs in the header though, this lead me to believe that perhaps the sample there had been modified in some way? Can you detail the changes that you made?
Regarding your point 3, there unfortunately does not currently exist a filter in the IgxSpreadsheet for getting the unique values for the column. If you would like to see this feature potentially developed in a future version of the IgxSpreadsheet, I would recommend suggesting a new product idea for this at our Ignite UI for Angular GitHub page, here: https://github.com/igniteui/igniteui-angular/issues. This will place you in direct communication with our product management and development teams that plan and prioritize upcoming features based on user feedback.
Please let me know if you have any other questions or concerns on this matter.
I have been investigating into the Excel file you have provided, and I can see there that the sorting does not work if you use the drop-down in the headers. This is because the region that is present in the “Blockpoint” worksheet only spans the region of A3:C3 – it does not span the rest of the table. As such, those drop-downs will only apply the single-row region of A3:C3.
It is still possible to sort in other ways though. For example, given the worksheet you provided, if you right-click on one of the cells – for this example we’ll say “A3” – there will be a “Sort” option in the resultant context menu. If you follow the options given there and sort it, it will sort the entirety of the “A” column in the worksheet for the cells that have values.
If you wish to have the drop-down in the header work instead of the context menu, you will need to define a region that spans the entire table you would like the drop-down to apply to. In the case of your “Blockpoint” worksheet, this region would be A3:C11.
Hey thanks for the explanation. i still have few questions to understand the terminologies used here
Context menu(Right Click) in case of excel does apply sort in the excel file but same sort not work in Infragistics spreadsheet. can we make Infragistics worksheet sort same way as excel ?
Drop down in header to work how do i define a region that spans to excel entire table ? (is there any steps we can follow in excel)
share some detailed excel steps for understanding. we are looking for detailed steps what is the pre requisite required in excel sheet to make sort and filter work in the Infragistics Spreadsheet
Thank you for your update on this matter.
If I load the sample Excel file that you provided into the sample shown here: https://ko.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet-overview. If I right click on one of the cells there to bring up the context menu and click Sort => one of the menu options, it works to sort that column, although if I try to do this outside of the region you defined, I receive a warning dialog. This same thing happens in Microsoft Excel if you, for instance, try to sort after right-clicking cell A2 in your worksheet.
Regarding the drop-down in the header, a “region” in Excel essentially means an area formatted to be a table. You can read about configuring this with our library here: https://ko.infragistics.com/products/ignite-ui-angular/angular/components/excel-library-using-tables.
If you are unsure how to define tables in Excel, you can read about how to do this here: https://support.microsoft.com/en-us/office/overview-of-excel-tables-7ab0bb7d-3a9e-4b56-a3c9-6c94334e492c.
Hey, thanks for the clarification and documentation reference. this is what am trying to achieve from the excel sheet i have attached
delete the first 2 empty rows
for this am converting the worksheet as table for certain random rows/columns in this case
this.spreadsheet.workbook.worksheets(0).tables().add("A1:Z1000", true);
** i noticed other way i can hide those columns without converting this as table
i have 2 questions when converting the worksheet data as table
1. is it possible to define a header row in that excel for instance row 3 or row 1 after deleting first 2 rows
2. instead of hardcoding "A1:Z1000" for table is there way i can dynamically decide based on the excel data ?
3. Also documentation for style so i can make the cell borders bold etc
2768.sample sort.xlsx
one more thing i noticed in the solution is after i delete the first 2 rows automatically infragtics add Column 1 , column2 etc as first name may be because am setting true
hasHeaderRow doesnot exist on the Worksheettable
instead can i set the existing first row itself as header so that the row is not sorted
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);
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.
i tried