StatusBar does consider hidden filtered content

StatusBar does consider hidden filtered content

Posted by: davide.vago on 26 July 2020, 11:09 pm EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 July 2020, 11:09 pm EST - Updated 3 October 2022, 12:49 am EST

  Hi there,

  Re-using the sandbox example I created for this: https://www.grapecity.com/forums/spread-sheets/programmatic-filter-doesnt

  I noticed that once the user filters out content within a spreadsheet, the statusBar does count hidden content therefore information such as count, sum, max, min don’t reflect the visible data.

  Please look at the example below:
  
  

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 27 July 2020, 9:32 pm EST

  Hi Davide,

  We are able to replicate the issue at our end. This seems like a regression issue. I’ve forwarded it to the concerned team for further investigation(SJS-5155) and will let you know about updates regarding the same.

  Regards

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 19 August 2020, 6:22 pm EST

  Hi Davide,

  This issue is now fixed in the latest version 13.2.1. Please update to the latest version and let us know if you face any issues.
  
  You may get the latest version from npm or download using the following link:
  
  http://cdn.grapecity.com/spreadjs/13.2.1/Files/SpreadJS.Release.13.2.1.zip

  Regards

• 

  kmalyi

  • Post Options:
  • Link
    Copy

  Posted 10 May 2021, 9:00 pm EST - Updated 3 October 2022, 12:44 am EST

  Looks like this issue was fixed for rows but it still for Columns, please take a look.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 11 May 2021, 6:42 pm EST

  Hi,

  Thank you for the information. We could also observe the same issue hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this as soon as we get any information.

  Regards,
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 17 May 2021, 10:55 pm EST

  Hi,

  The Devs informed us that. This is by design, the function in the status bar actually used the subtotal function.
  
  the subtotal function will ignore the hidden row, but will not ignore the hidden column.
  
  Excel also does the same so SpreadJS just keep the same with excel.

  Regards
  
  Avinash