The firewall blocks too many parameters in one call

Posted by: laura.persyn on 22 November 2021, 8:28 am EST

  • Posted 22 November 2021, 8:28 am EST

    In Spread.NET 14, in an ASP.NET MVC 5 environment, we found strange behavior when hiding columns, the number of hidden columns seems to vary each time.

    We found the reason for this problem to be that the call has too many parameters, because the spreadcomponent synchronises the full state with the client to the server, which means that one call contains all cells. (Each cell is one parameter)

    Our firewall refuses calls with more than 5000 parameters, this is the max number of parameters it could accept.

    We calculated that with our usecase we should be able to go up to 50 rows en 250 columns which results in 12500 parameters.

    Is it possible to split this call into groups of 5000 or less parameters?

  • Posted 24 November 2021, 7:28 am EST

    Hi,

    We have escalated this issue to the concerned team for further investigation. We will update you regarding this as we get any information from the team. The internal ID for this issue will be SPNET-21775.

    Regards

    Avinash

  • Posted 24 March 2023, 4:57 am EST - Updated 24 March 2023, 5:02 am EST

    Hi,

    Devs investigated the issue and suggested the following 2 workarounds.

    1. You can place Spread control in a form (with method = “post”) to force data sent via form instead. Change code in Layout.cshtml page or page contains Spread (exp: Index.cshtml) as below images.

    2 you may off generation the hidden data as below setting:

    fpSpread.AllowGenerateHiddenData = false

    regards,

    Avinash

Need extra support?

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

Learn More

Forum Channels