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

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

• 

  nhan.thanh.nguyen

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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.
  
  https://www.grapecity.com/forums/spreadjs/number-formatter-which-was-selected-in-ribbon
  
  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

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  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 https://www.grapecity.com/my-account/my-support.

  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: https://www.grapecity.com/forums/spreadjs.

  Warmest regards,

  Ankit