StatusBar does consider hidden filtered column content

StatusBar does consider hidden filtered column content

Posted by: kmalyi on 11 May 2021, 6:21 pm EST

• 

  kmalyi

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 11 May 2021, 6:21 pm EST

  Hello, an issue is very similar to this https://www.grapecity.com/forums/spreadjs/statusbar-does-consider-hi

  So statusBar does count hidden content. This issue was fixed for rows but still exist for columns.

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 11 May 2021, 6:46 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. The internal id for this issue will be SJS-5155.

  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

• 

  kmalyi

  • Post Options:
  • Link
    Copy

  Posted 20 May 2021, 5:00 pm EST

  Hi avinash.pathak, is there any way to control it (ignore or not ignore hidden columns) for subtotal and during selection?

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 23 May 2021, 5:18 pm EST

  Hi,

  We are sorry but we could control the subtotal internal functionality. We are sorry for the inconvenience.

  Regards,
  
  Avinash