SpreadJS Designer - Filter on Cell

SpreadJS Designer - Filter on Cell

Posted by: kwallace on 26 May 2021, 1:27 am EST

• 

  kwallace

  • Post Options:
  • Link
    Copy

  Posted 26 May 2021, 1:27 am EST - Updated 3 October 2022, 12:48 am EST

  In SpreadJS if I have a column setup and click the top cell with data inside of it to add a filter to it, the filter gets added to the cell above the one I chose, and the items listed is only the cell directly below, (the cell I originally chose).
  
  In excel if I add a filter to a cell the filter gets put on that selected cell and the filter list shows all cells with content below it, stopping when it reaches an empty cell.
  
  See the attached screenshots for Excel vs SpreadJS functionality.
  
  Would this be able to be fixed?

  Thanks,
  
  Keith

  

  1646×663 33.3 KB

  

  690×535 11.7 KB

  

  1591×854 43.9 KB

  

  1857×865 64.9 KB

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 26 May 2021, 7:40 pm EST

  Hi Keith,

  We are able to observe the issue at our end hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information. The internal ID for this issue will be SJS-8846.

  Regards,
  
  Avinash