C1FlexSheet/C1XLBook: how to enable "table" format/filtering?

Posted by: mark.smeltzer on 28 January 2020, 12:07 pm EST

  • 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:
    1) how can I enable that setting in the C1XLBook API?
    2) how can I enable that setting in the C1FlexSheet API?
    3) does the C1FlexSheet support that function in its UI?
  • Replied 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
  • Replied 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...
  • Replied 29 January 2020, 3:43 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.

  • Replied 29 January 2020, 3:44 pm EST

    FYI, I am using the latest release of the WPF components...
  • Replied 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
  • Replied 3 February 2020, 2:11 pm EST

    Thanks for the info.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels