Forums Home / ComponentOne / WPF Edition
Posted by: mark.smeltzer on 28 January 2020, 12:07 pm EST
mark.smeltzer
Posted 28 January 2020, 12:07 pm EST
Excel UI has a function called “Format as Table”. This causes the headers to become filterable/sortable.
Questions:
mohitg
Posted 28 January 2020, 8:52 pm EST
Hello,
No, this is not possible to set cell range as format as table in both C1Flexsheet and C1XLBook.
Also, Flexsheet does not support it in UI also.
Thanks,
Mohit
mark.smeltzer
Posted 29 January 2020, 7:26 am EST
When can this be added? Exporting as table is one of our user’s requirements. Worst case, I could create a filtering UI to simulate this in our app. But, we need full fidelity for exporting…
mark.smeltzer
Posted 29 January 2020, 3:43 pm EST - Updated 3 October 2022, 11:58 pm EST
I found that C1FlexSheet’s columns have a drop down which allows filtering. However, it appears to be quite “dumb”: the filtering applies to all rows, even the column header. That is a bug. However, I don’t see any property like “FirstRowIsColumnHeader” or similar to exclude the first row.
Moreover, the sort options aren’t even clickable, even though they are visibile.
mark.smeltzer
Posted 29 January 2020, 3:44 pm EST
FYI, I am using the latest release of the WPF components…
mohitg
Posted 2 February 2020, 4:07 pm EST
Hello,
It is design behavior to filter the first row. However, I have an enhancement request to our development team(419319) to add the property to avoid the first row of the sheet while filtering.
Moreover, the sort options aren’t even clickable, even though they are visibile.
Please set the AllowSorting property of Flexsheet to “True” to enable the sorting.
Thanks,
Mohit
mark.smeltzer
Posted 3 February 2020, 2:11 pm EST
Thanks for the info.
