How to set default value when value is empty or null for Number Type

Posted by: nhan.thanh.nguyen on 22 February 2023, 9:45 pm EST

    • Post Options:
    • Link

    Posted 22 February 2023, 9:45 pm EST

    Hi teams,

    Here I’ve requirements like when the value is empty or null, I want handle that like setting a default value “-” to that column. can you help with this with reactjs.

    For the latest topic, I would like to set default value “-” to that column which type was Number.

    I have set the format below: “###,###0.00;(###,###0.00);-”. It’s true with “0” value but I need to set “-” for an empty value. With this format, type of cell is Custom (not Number type). Is there any way to do this with Number type?

    I’m looking for your answer!

    Thanks and Best Regards,

    Nhan Nguyen

  • Posted 26 February 2023, 2:13 pm EST

    Dear Nhan,

    I wanted to take a moment to update you on the issue you recently reported. I have created a new case on your behalf and assigned it to you with the unique Case ID: CAS-38335-C3F4Y4. To keep up-to-date with the progress of the case, please visit

    Moreover, I want to reassure you that we are committed to providing you with the highest quality of service, and we are always here to help. If you have any further queries related to SpreadJS, please feel free to create a new case on the Official SpreadJS Public Forum at:

    Warmest regards,


Need extra support?

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

Learn More

Forum Channels