Delete rows not working probably after filter

Delete rows not working probably after filter

Posted by: weimeng on 8 September 2017, 10:03 am EST

• 

  weimeng

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 10:03 am EST

  Hi,

  I came across an issue which I have set row filters to the sheet(expect last two rows), and delete some rows after filter, I notice the rows not including in the filter will disappear.

  I have create a reproducible case, and I have a row filters are applied to the most rows excluding the last empty rows. Step to reproduce:

  1. click on the filter button, everything filters correctly,
  2. click the delete button, the row will be deleted, but one of the empty rows get disappeared also
  3. click the delete button again, the other empty row disappear.

  https://jsfiddle.net/weimeng/kov5ewfb/

  Please let me know if you have any question.

  Thanks,
  
  Wei

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 10:03 am EST

  Hello,

  We are able to replicate the issue and hence we are escalating the same to the concerned team for the fix.

  Tracking id for the issue is #200761

  We will update you as soon as we hear anything from our concerned team.

  Thanks,
  
  Reeva

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 10:03 am EST

  Hello,

  We confirm that it was a bug of filter wherein the internal filter cache isn’t correctly updated when delete rows.

  However, the bug have been fixed and the update will be in next official release.

  Unfortunately, we don’t have any workaround for the same.

  Thanks,
  
  Reeva

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 8 September 2017, 10:03 am EST

  Hello,

  Your issue has been fixed in SpreadJS V10 release as given in Release Notes page in ReadMe here:-

  http://sphelp.grapecity.com/WebHelp/SpreadSheets10ReadMe/webframe.html#rnotesv10.html

  You can download latest SpreadJS V10 from this link:-

  http://spread.grapecity.com/Downloads/Download/?productID=5

  Hope it helps.

  Thanks,
  
  Reeva