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.
Thank you for your update on this matter. I apologize, but I need a couple of additional clarifications in this case. Can you please provide some information on the following?
1. Regarding points 1 and 2, you mention that you have the IgxSpreadsheet within an Igx Modal Window? I am unable to see a particular control that matches this exact description – are you referring to the IgxDialog component described here?: https://ko.infragistics.com/products/ignite-ui-angular/angular/components/dialog. If you are not referring to this, then can you please provide some sample code that shows how you are using your modal dialog?
2. Regarding the inability to sort / filter, I have modified the Excel file shown at the link that you provided to include the header options, as it does not appear to include this by default. I am attaching that modification here, and you can load it into the sample project shown on this page: https://ko.infragistics.com/products/ignite-ui-angular/angular/components/spreadsheet-overview. In doing so, I am able to successfully sort after filtering the table in the spreadsheet. Given, I have not yet tried this within a modal dialog, but I don't see how that would affect the ability to sort and filter the table in the spreadsheet.
xlsx.zip
Thanks i have fixed the issue mentioned in point number 1
on the sorting issue am able to sort the after using your excel. but what are the basic pre requisite for spreadsheet to work. is it applicable only with header option for chart? we have created excel using openxml and i have applied filter to that excel. what other option (Please share steps ) i need to enable in the xlsx file for the sorting to work.
sample sort.xlsx
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
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.