Spread V11: Issue with applying filters (rowFilter)

Spread V11: Issue with applying filters (rowFilter)

Posted by: viswanath.malepati on 17 July 2018, 5:19 am EST

• 

  viswanath.malepati

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 17 July 2018, 5:19 am EST

  Hi,

  We are trying to apply filters on column after sheet has some data. And there are some differences in the way spread behaves when compared to Excel.

  Please find our observations and the files attached.

  • "

  • "if we give “|” in between, then it matches all prefixes and suffixes "

  • “if we give “|” in end, then all are showing”

  • "if we give “" anywhere, its not showing any rows.”

  • “if we give only “.” or only “?” then it will give all rows having only special characters”

  "

  Note: Each of the above point has an associated html file attached as attachment.

  Thanks,
  
  Viswanath

  spread11filters.zip

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 18 July 2018, 4:45 am EST

  Hi Viswanath,

  We do not try to match and copy the MS Excel filter. However I have submitted this issue for further investigation to our development team. The tracking id for this issue is 260948. I will let you know as soon as I get an update on this.

  Thanks,
  
  Deepak Sharma

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 19 July 2018, 4:57 am EST

  Hi Viswanath,

  The developer suggested a solution for this issue that can set the ‘useWildCards’ property to false for the filter condition. For example:

  
  var value = "sheet|";
  var condition = new GC.Spread.Sheets.ConditionalFormatting.Condition(GC.Spread.Sheets.ConditionalFormatting.ConditionType.textCondition, {
                              compareType: GC.Spread.Sheets.ConditionalFormatting.TextCompareType.equalsTo,
                              expected: value,                          
  });
  
  condition.useWildCards(false);
  
  

  Thanks,
  
  Deepak Sharma