Formulas behaviour with pre-formatted cells

Posted by: davide.vago on 22 July 2020, 2:53 am EST

  • Posted 22 July 2020, 2:53 am EST

    Hi there,

    I was wondering if you have anything in you timeline for tackling the below:

    When the user inputs 2 percentage and then creates a formula to sum them:

    In SpreadJS, the output is a number not formatted as percentage. In Excel, the output of the formula comes out as percentage.

    Would it be possible to have a solution out of the box in the next releases without hacking the behaviour with custom code?

    Thank you in advance for you support

  • Posted 22 July 2020, 2:54 am EST

    I’ve recorded a couple of videos to explain the output a bit better:

  • Posted 23 July 2020, 2:12 am EST

    Hi Davide,

    This feature is not supported yet. I’ve added an enhancement request to support this feature on your behalf and will let you know about any updates regarding the same. Internal tracking ID: SJS-5052


  • Posted 9 December 2020, 8:33 pm EST

    Good morning/afternoon

    I’m wondering if there is some update regarding this issue.

    Looking forward to hearing from you

  • Posted 10 December 2020, 5:48 pm EST

    Hi Davide,

    Currently, we don’t have any updates but we have asked the Dev team regarding the same. We will update you once we have any information from the team.

    Regards Avinash

  • Posted 2 May 2023, 9:31 pm EST


    The mentioned feature has been added in the latest version of SpreadJS V16.1.0. Kindly upgrade to the latest version of SpreadJS.

    You may download the latest version of SpreadJS using the following link:



Need extra support?

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

Learn More

Forum Channels