TypeError: GC.Spread.Sheets.RowFilterBase is not a constructor

TypeError: GC.Spread.Sheets.RowFilterBase is not a constructor

Posted by: davide.vago on 30 August 2019, 8:00 am EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 30 August 2019, 8:00 am EST

  Good morning/evening

  I’m currently trying to reset/modify filters programmatically and I found on your documentation the method reset applicable to the RowFilterBase, however this method throws an error (see title)

  my code is something like:

  
  const totalRows = window.spreadSheet.activeSheet.getRowCount()
  const totalCols = window.spreadSheet.activeSheet.getColumnCount()
  const range = new GC.Spread.Sheets.Range(1, 0, totalRows, totalCols)
  const instance = new GC.Spread.Sheets.RowFilterBase(range)
  instance.reset()
  
  

  Apparently this GC.Spread.Sheets.RowFilterBase doesn’t exist.

  Looking forward to hearing from you.

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 30 August 2019, 8:31 am EST

  ref. http://help.grapecity.com/spread/SpreadJSWeb/webframe.html#JavascriptLibrary~GcSpread.Sheets.RowFilterBase~_ctor.html

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 2 September 2019, 3:21 am EST

  Hi Davide,

  The docs link you have shared is for an older version of SpreadJS. In the latest version, RowFilterBase has been moved to GC.Spread.Sheets.Filter namespace. Also instead of using RowFilterBase, we would recommend you to use HideRowFilter. Please refer to the following documents and the sample demonstrating the use of HideRowFilter:
  
  API References:
  
  • RowFilterBase class: http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.Sheets.Filter.RowFilterBase.html
  
  • HideRowFilter class: http://help.grapecity.com/spread/SpreadSheets12/webframe.html#SpreadJS~GC.Spread.Sheets.Filter.HideRowFilter.html

  Sample for Filter:
  
  https://www.grapecity.com/demos/spread/JS/TutorialSample/Features/Filter/basicFilter/purejs

  Regards

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 2 September 2019, 6:08 am EST

  Thank you, HideRowFilter does the job.