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 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.
  • Replied 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
  • Replied 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

  • 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

    Hi,

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

    Regards,
    Avinash
Need extra support?

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

Learn More

Forum Channels