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
Hey thanks for the detailed information. am trying to get few API from the information you shared but am not able to get all the required details for my requirement. this is what i have tried so far.
i have converted this excel in to the spreadsheet and converted this to a table for worksheet 0 as i have only on worksheet from A1 to C11. i have deleted first 2 rows as those are blank.
with above code am getting worksheet as table and it is creating default column names. i have couple of questions
1. is it possible to set row 3 as header row so that custom column names are not created and i can keep row 3 as header so that it is fiexed and doesnt get sorted ? once this is set i can set this row as frozen as well
2. instead of hardcoding A1:C11 can we get calculate the column and row length of the worksheet ?
1122.sample sort.xlsx
Hello Peru,
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.
Please let me know if you have any other questions or concerns on this matter.
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
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.
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