Formatter not applied to Cells with value 0

Formatter not applied to Cells with value 0

Posted by: seshareddy.kamaganiguntla on 8 September 2021, 11:49 am EST

• 

  seshareddy.kamaganiguntla

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 8 September 2021, 11:49 am EST

  When i apply a formatter to a cells, it is not working if cell has value of 0

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 9 September 2021, 5:06 am EST

  Hi,

  Could you please provide more information such as What format you setting and how exactly you are formatting cells? Please provide this information so that we could have a better understanding of the issue and assist you accordingly.

  Regards,
  
  Avinash

• 

  seshareddy.kamaganiguntla

  • Post Options:
  • Link
    Copy

  Posted 13 September 2021, 5:54 am EST - Updated 3 October 2022, 9:35 am EST

  I am using following formatter (#,###0.0);((#,###0.0);(@_) , to show 1 decimal place.But it is not applied for cells with values 0 as in the following figure.

  

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 14 September 2021, 5:45 am EST

  Hi,

  Thanks for the information, We are able to replicate the issue hence we have escalated this issue to the concerned team for further investigation. We will update you regarding this issue as we get any information from the team. The internal ID for this issue will SJS-10095,

  Meanwhile, You may use (##,##0.0) formatter string to show 1 decimal place. Please try this formatter string and let us know if you face any issues

  Regards
  
  Avinash

• 

  avinash.pathak

  • Post Options:
  • Link
    Copy

  Posted 18 October 2021, 5:22 am EST

  Hi,

  The issue has been fixed in our latest 14.2.1 release, Please update to the latest build and let me know if you still face any issues,

  Regards,
  
  Avinash