Flexsheet filter not working for merged cells

Flexsheet filter not working for merged cells

Posted by: chris.jones on 26 July 2019, 6:33 am EST

• 

  chris.jones

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 July 2019, 6:33 am EST

  I have a Flexsheet filter on a column which contains merged cells. When I open up the filter some of the entries are missing. This seems to be intermittent and only seems to occur after applying a filter on a different column. It can be fairly easily reproduced using https://www.grapecity.com/wijmo/demos/Grid/FlexSheet/CellMerging/purejs

  1. In column “A”, create some merged groups
  2. In any other column, select the filter icon and filter out several rows
  3. Select the filter icon for column “A”. The filter will now often not show all of the valid entries that exist and are still visible in column “A”.
• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 29 July 2019, 6:15 am EST - Updated 3 October 2022, 6:45 pm EST

  Hi Chris,

  We are sorry but we were not able to replicate the issue at our end. Please refer to the attached screenshot. Could you please tell us whether we are missing something in order to replicate the issue? You could also provide us with a sample that replicates the issue.

  

  Regards,
  
  Ashwin

• 

  chris.jones

  • Post Options:
  • Link
    Copy

  Posted 29 July 2019, 11:14 am EST

  hi Ashwin,

  Sorry that you could not repeat it. Here is a more specific example. If you still can’t repeat then I will send a recording:

  For column A select 1 to 5 - Merge
  
  For column A select 6 to 10 - Merge
  
  For column A select 11 to 15 - Merge
  
  For column A select 16 to 19 - Merge

  So you have 4 merged groups in column A

  Click filter for column C

  Uncheck top three 2,3,4 and apply filter. The “0” group in column A still has entries so is correctly shown in the grid

  Now press filter for column A. There is no 0 entry.

  Thanks
  
  Chris

• 

  chris.jones

  • Post Options:
  • Link
    Copy

  Posted 29 July 2019, 11:19 am EST - Updated 3 October 2022, 6:45 pm EST

  

  I moved the filter to the side a bit so you can see the data underneath

• 

  chris.jones

  • Post Options:
  • Link
    Copy

  Posted 29 July 2019, 11:27 am EST

  hi Ashwin

  Actually, having played with it a little more, I know the specific reason. When the first element of a merged group is removed via another unrelated filter then it does not show.

  Thanks
  
  Chris

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 30 July 2019, 12:45 am EST

  Hi Chris,

  We were able to replicate the issue at our end so we have forwarded a bug report to the dev team with internal tracking id 392169. We will give you an update on this as soon as we have further information.

  Regards,
  
  Ashwin

• 

  jokker414

  • Post Options:
  • Link
    Copy

  Posted 30 July 2019, 9:58 am EST

  I’ve had almost the same issue a month ago.

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 31 July 2019, 12:14 am EST

  Hi James,

  We have added you as a correspondent to the case. We will give you an update as soon as the issue is fixed.

  Regards,
  
  Ashwin

• 

  chris.jones

  • Post Options:
  • Link
    Copy

  Posted 20 November 2019, 12:34 pm EST

  Hi

  Any news on whether this has been fixed in 2019v3?

  Thanks
  
  Chris

• 

  ashwin.saxena

  

  • Post Options:
  • Link
    Copy

  Posted 20 November 2019, 11:12 pm EST

  Hi Chris,

  The issue has been fixed in the latest 19v3 build. You may verify the same using the sample link below:

  https://www.grapecity.com/wijmo/demos/Grid/FlexSheet/CellMerging/purejs

  ~regards

• 

  chris.jones

  • Post Options:
  • Link
    Copy

  Posted 21 November 2019, 4:38 am EST

  Thats great. Thanks.