StatusBar does consider hidden filtered column content

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

  • Posted 11 May 2021, 6:21 pm EST

    Hello, an issue is very similar to this

    So statusBar does count hidden content. This issue was fixed for rows but still exist for columns.
  • Replied 11 May 2021, 6:46 pm EST


    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.

  • Replied 17 May 2021, 10:55 pm EST


    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.


  • Replied 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?
  • Marked as Answer

    Replied 23 May 2021, 5:18 pm EST


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

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels