Add a filter to any cell

Add a filter to any cell

Posted by: cdennington on 20 February 2024, 5:26 pm EST

• 

  cdennington

  • Post Options:
  • Link
    Copy

  Posted 20 February 2024, 5:26 pm EST - Updated 20 February 2024, 5:31 pm EST

  I’m using FlexSheet in React

  I’d like the user to be able to add a filter to any cell, like you can in Excel

  The user should be able to highlight a group of cells, add a filter, and then filter by the groups values.

  See image, I have added a filter to YTD for the values beneath

  

  1632×1327 75.7 KB

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 21 February 2024, 6:10 pm EST

  Hello,

  Apologies, but the FlexSheet control in Wijmo does not currently support cell range filtering.

  However, we have another product that does, along with many other advanced Excel features and additional functions. For more details, please refer to the following link:

  SpreadJS designer: https://developer.mescius.com/spreadjs/designer/index.html
  
  SpreadJS demo: https://developer.mescius.com/spreadjs/demos/showcase/taxform/purejs

  Regards

• 

  cdennington

  • Post Options:
  • Link
    Copy

  Posted 25 February 2024, 3:28 pm EST

  Thanks, spreadJS appears to be exactly what we are looking for.

  I just have one query, I am trying to implement several cells to have filters, like the example here: https://developer.mescius.com/spreadjs/demos/features/filters/filter-dialog/purejs

  However, I want the cells to be in more than one row, in the example above they are only on row 2, but Id like them on row 2 and row 10.

  I can get them to appear on row 10 without issue, but it appears to be overriding row 2. Am I able to pass more than one row to: rowFilter? Or is there another way I can achieve this?

• 

  chandan.rawat

  

  • Post Options:
  • Link
    Copy

  Posted 25 February 2024, 7:51 pm EST - Updated 25 February 2024, 7:56 pm EST

  Hi,

  As per my understanding, it seems that you want to apply filters on two different cell ranges in the sheet. For instance, cell range that starts at row 2(e.g. A2:B3) have a filter and a cell range that starts at row 10(e.g. A10: B11) also have a filter.

  Please note that only one filter can be applied to the sheet at a time. The filter can be applied to a cell range that has many rows and columns. This behavior is by design and the behavior of SpreadJS aligns with the behavior of MS Excel(excel-filter.gif). The filter applied to the sheet(sheet level) can be accessed using worksheet.rowFilter() method.

  If you want to apply multiple filters to cell ranges then as a workaround, you could utilize tables in SpreadJS. Every table has a filter associated with it which can be accessed with table.rowFilter() method.

  Kindly refer to the attached sample for more understanding.

  sample: https://jscodemine.grapecity.com/share/E_XtV-V_B0qx-EG8Ay1-gQ/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  I hope the above explanation resolves your issue or doubt. If you continue to face the issue, please let us know and explain your use case in more detail so that we can help you accorndingly.

  Also, kindly post your queries/questions related to SpreadJS on the SpreadJS forum at https://developer.mescius.com/forums/spreadjs.

  References:

  Worksheet.rowFitler(): https://developer.mescius.com/spreadjs/api/v17/classes/GC.Spread.Sheets.Worksheet#rowfilter
  
  Table class: https://developer.mescius.com/spreadjs/api/v17/classes/GC.Spread.Sheets.Tables.Table
  
  Table.rowFilter(): https://developer.mescius.com/spreadjs/api/v17/classes/GC.Spread.Sheets.Tables.Table#rowfilter

  

  Regards