FlexSheet - Discrepancy between sort and filter

FlexSheet - Discrepancy between sort and filter

Posted by: holly.anderson on 18 January 2018, 11:44 pm EST

• 

  holly.anderson

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 18 January 2018, 11:44 pm 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

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 21 January 2018, 7:25 pm 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

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 21 January 2018, 11:40 pm 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

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 22 January 2018, 3:26 pm 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

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 25 January 2018, 12: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

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 29 January 2018, 8:39 pm 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

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 26 February 2018, 7:30 pm 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

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 5 March 2018, 12: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

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 5 March 2018, 10:02 pm EST

  We are investigating this. Will get back to you on this tomorrow.

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 6 March 2018, 9:45 pm EST

  Sorry Holly,

  Its taking bit longer. Will update you on this soon

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 7 March 2018, 9:22 pm 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.

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 23 March 2018, 12:33 am EST

  Any update?

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 25 March 2018, 10:46 pm 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.

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 5 April 2018, 2:43 am EST

  Any update?

• 

  abhishek.dutta

  

  • Post Options:
  • Link
    Copy

  Posted 5 April 2018, 4:31 am EST

  Hi,

  This has been fixed. Could you please check this out the latest release & lete know if you are still facing issues l.

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 5 April 2018, 10:49 pm EST

  This issue seems to have been fixed. Thanks!

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 14 August 2018, 3:36 am 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

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 15 August 2018, 10:32 pm 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

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 22 August 2018, 6:03 am EST

  Is there any update on this?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 22 August 2018, 4:11 pm 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

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 10 September 2018, 5:11 am EST

  Hello,

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

  Thanks,
  
  Holly

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 10 September 2018, 6:07 pm 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

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 14 September 2018, 12: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

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 17 September 2018, 5:09 pm 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

• 

  holly.anderson

  • Post Options:
  • Link
    Copy

  Posted 26 September 2018, 2:14 am EST

  Any update?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 September 2018, 8:16 pm 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