FlexSheet - Discrepancy between sort and filter

Posted by: holly.anderson on 19 January 2018, 8:44 am EST

  • Posted 19 January 2018, 8:44 am EST

    Hello,

    I've noticed that when editing a value in a cell, the spreadsheet is re-sorted right away but not re-filtered. For example, if a column has a sort (not filter) applied and I edit a value in the column, then the edited row moves to the position where it should be according to the applied sort order. However, if a column has a filter (not sort) applied and I edit a value in the column so that the new value doesn't match the filter, the edited row remains visible. The row is only removed from view if I reapply the existing filter.

    Interestingly, if a column has both sort and filter applied and I edit a value in the column so that the edited row (1) should move to the top and (2) shouldn't appear anymore because it doesn't match the filter, then the row becomes invisible, as expected.

    Holly
  • Replied 22 January 2018, 4:25 am EST

    Hi Holly,
    We are able to replicate the issue at our end.

    This seems design behavior for the FlexSheet same as Excel.
    However, if you would like to filter edited item as per the filter definition, you may use one of method as given below:
    #1: Re apply filter using FlexGridFilter's apply method.
    #2: Refresh CollectionView bound to FlexSheet

    Please refer to the attached sample for the same.

    ~Manish

    FlexSheet_filterReApply_rowEditEnd.zip
  • Replied 22 January 2018, 8:40 am EST

    Hi Manish,

    Could you explain a bit more how the FlexSheet behaves the same as Excel? To test this, I formatted some data as a table in Excel 2013. If I filter a column in Excel and then change a value in that column, the column is not re-filtered. This is the same as FlexSheet. If I sort a column in Excel and then change a value in that column, the column is not re-sorted. This is not the same behavior as FlexSheet. Do you have an example where the column is re-sorted immediately in Excel?

    I don't necessarily mind that items aren't re-filtered immediately in the FlexSheet. It's the inconsistency between sort and filter that I don't like. And that fact that if sort and filter are applied to the same column, then the column is immediately re-filtered after changing a value.

    Holly
  • Replied 23 January 2018, 12:26 am EST

    Hi Holly,
    I am really sorry to mention that only filter functionality match with Excel. However, if you would like to achieve the same Excel like behavior for Sorting too, you need to handle filterChanging event for FlexSheet filter and detect mousedown and click event for sort button.

    Please refer to the updated plunker for the same (Initialized event):

    http://plnkr.co/edit/8p4Uh03uALMpf0iCXtWC?p=preview

    ~Manish
  • Replied 25 January 2018, 9:08 am EST

    Hi Manish,

    Thanks for the example. Do you know if this inconsistency between sort and filter is by design? I would have assumed that sort and filter should both behave similarly to Excel. Do you think the discrepancy should be logged as a bug? If not, I'll make do with the workaround you provided.

    Holly
  • Replied 30 January 2018, 5:39 am EST

    Hi Holly,
    We are sorry for the delay.
    Yeah, you are right. The behavior should be same for both. Hence, we have forwarded this to the concerned team for further investigation with tracking id 306358.

    We will let you know as we get any update on this.

    ~Manish
  • Replied 27 February 2018, 4:30 am EST

    Hi,
    This issue has been fixed and the fix will be included in the next release build. You may get the latest pre-release build for verifying issue from here:
    http://prerelease.componentone.com/wijmo5/

    ~Manish
  • Replied 5 March 2018, 9:52 am EST

    Hi Manish,

    Could you please verify what the resolution was for this issue? Based on our discussion, I'd assumed that the fix would be for FlexSheet to behave similar to Excel in regards to sort and filter. Particularly, I would think that neither sort nor filter should be automatically reapplied when a value is changed. Instead, I'm seeing that both sort and filter are automatically reapplied. And there is also another inconsistency. Sort is reapplied after a value is changed and the focus leaves the row. Filter is reapplied after a value is changed and the focus leaves the cell.

    Holly
  • Replied 6 March 2018, 7:02 am EST

    We are investigating this. Will get back to you on this tomorrow.
  • Replied 7 March 2018, 6:45 am EST

    Sorry Holly,

    Its taking bit longer. Will update you on this soon
  • Replied 8 March 2018, 6:22 am EST

    Hi Holly,

    Yes you are right there seems to be an issue. I have updated the case 306358 with your observations. I will update you once I have further updates.
  • Replied 23 March 2018, 9:33 am EST

    Any update?
  • Replied 26 March 2018, 7:46 am EST

    Hi,

    Our Dev Team is actively working on this. I have requested an ETA for the same. I will update you on this soon.
  • Replied 5 April 2018, 11:43 am EST

    Any update?
  • Marked as Answer

    Replied 5 April 2018, 1:31 pm EST

    Hi,

    This has been fixed. Could you please check this out the latest release & lete know if you are still facing issues l.
  • Replied 6 April 2018, 7:49 am EST

    This issue seems to have been fixed. Thanks!
  • Replied 14 August 2018, 12:36 pm EST

    This issue seems to be occurring again in version 5.20182.500. Please see attached sample and follow these steps:

    1) Filter column B by value to exclude "Item5".
    2) Change the value in the first cell in column B to "Item5".
    3) Hit Enter.

    Result: The items are not re-filtered. This is consistent with Excel.

    4) Sort column B.

    Result: The items are re-filtered. This is inconsistent with Excel.

    FlexSheetDemo_SortFilter.zip
  • Replied 16 August 2018, 7:32 am EST

    Hi,
    We were able to replicate the issue at our end and hence it has been forwarded to the concerned team for further investigation with internal tracking id 339373.
    We will let you know for any updates on this.

    ~Sharad
  • Replied 22 August 2018, 3:03 pm EST

    Is there any update on this?
  • Replied 23 August 2018, 1:11 am EST

    Hi,
    The issue is still with the dev team. We are unable to provide an ETA but we will let you know as we get an update on this.

    ~Sharad
  • Replied 10 September 2018, 2:11 pm EST

    Hello,

    It's been a few weeks so I wanted to check in a see if there is an update yet.

    Thanks,
    Holly
  • Replied 11 September 2018, 3:07 am EST

    Hi Holly,

    The issue has been fixed in the latest rc build 5.20182.523 and will be included in the next stable release.
    You may confirm the same by downloading rc build from : http://prerelease.componentone.com/wijmo5/latest/

    Please note that rc build are not suitable for production and should not be used in the production.

    Regards
    Sharad

  • Replied 14 September 2018, 9:28 am EST

    Hello,

    When I use the build at http://prerelease.componentone.com/wijmo5/latest/, this issue does not occur. But when I use the build at http://cdn.grapecity.com/wijmo/5.20182.523, the problem still occurs. Did the fix not make it into the new release?

    Holly
  • Replied 18 September 2018, 2:09 am EST

    Hi Holly,

    We are sorry for the delayed response on this.
    We have asked the product team for this and will update you soon.

    Regards
    Sharad
  • Replied 26 September 2018, 11:14 am EST

    Any update?
  • Replied 28 September 2018, 5:16 am EST

    Sorry for delayed response.
    We have confirmed from the dev team that released 5.20182.523 build was earlier build than 5.20182.523-nightly.d20180907.t0028(which includes the fix).
    Fix will be included in the next release which is scheduled for late October.

    ~Sharad
Need extra support?

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

Learn More

Forum Channels