Format does not take effect

test222.jpg

I added a format format to the official demo and found that it did not take effect...


6 Replies

MM Manikandan Murugesan Syncfusion Team August 24, 2021 09:58 AM UTC

Hi Sakura, 

The format “#,###.##;(#,###.00)” denotes that it formats the positive values with available decimal values and negative values with “00”. And the values are formatted using this format as expected in the pivot table. Kindly refer to the following sample. 
 
 
Please refer to the following documents to know more about the number formatting. 
 
Please let us know if you have any concerns. 
 
Regards, 
Manikandan. 



SJ Sakura Jiang replied to Manikandan Murugesan August 24, 2021 10:04 AM UTC

I mean that the positive number retains two decimal places and does not take effect 



SJ Sakura Jiang August 24, 2021 10:10 AM UTC


If I write like this, an error will be reported



MM Manikandan Murugesan Syncfusion Team August 25, 2021 10:05 AM UTC

Hi Sakura, 

Please find the response below. 
Query 
Comments 
I mean that the positive number retains two decimal places and does not take effect  
For the specified format (#,###.##;(#,###.00)), it retains decimal values for the value that having decimals from the bound data source. But, we found that the specified value doesn’t have any decimal values in the given data source. Hence, the reported problem occurs. We have modified the sample with decimal values for your convenience. Kindly refer the following sample. 




If I write like this, an error will be reported 
We can be able to reproduce the problem at our end. We have considered this as a bug “Exception occurs while applying custom format” and logged a defect report in our database. And the fix will be available in our upcoming weekly release which is estimated to be rolled out in next week. You can track the same by using below link. 
 
 


Please let us know if you have any concerns. 
Regards, 
Manikandan 



MM Manikandan Murugesan Syncfusion Team August 31, 2021 10:35 AM UTC

Hi Sakura, 
 
Due to complexity, the fix for the issue “Exception occurs while applying custom format” couldn't be included in our upcoming weekly release. But it will be included in our Volume 3 release which is estimated to be rolled out at the end of next month. 
 
We appreciate your patience until then. 
 
Regards, 
Manikandan 



MM Manikandan Murugesan Syncfusion Team September 7, 2021 03:10 PM UTC

Hi Sakura, 
 
We are glad to inform you that the fix for the issue “Exception occurs while applying custom format” has been included in the weekly release (v19.2.60). Kindly refer to the following sample. 
 
 
We thank you for your support and appreciate your patience in waiting for this release. Please contact us if you require any further assistance.  
   
Regards,  
Manikandan 


Loader.
Up arrow icon