Question Re: Number Format in Grid Cell in Product Lifecycle Management Q&A https://community.sap.com/t5/product-lifecycle-management-q-a/number-format-in-grid-cell/qaa-p/5564719#M25344 <HTML><HEAD></HEAD><BODY><P>Nothing changed much other than the WB, it's still the basic java number formatting options (which is probably why the help doc popup looks a bit like a javadoc).</P><P></P><P>I believe the WB has a bug when setting and retrieving a nested comma in the ColumnFormats property, which itself is a comma separated DT property.</P><P></P><P>Use something like this in your PARAM's:</P><P></P><P>0.00,#^^#0.00,MM/dd/yy (just use the double carat for any nested comma and leave the commas to denote column breaks in the list).</P></BODY></HTML> Wed, 06 May 2009 21:20:12 GMT jcgood25 2009-05-06T21:20:12Z Number Format in Grid Cell https://community.sap.com/t5/product-lifecycle-management-q-a/number-format-in-grid-cell/qaq-p/5564718 <HTML><HEAD></HEAD><BODY><P>I can't get a SQLDataType=8 cell to format with comma separators (ie, 9,999,999). Have the number format options changed in 12.0? I can't find the reference table in the Help Docs. The table in the 11.5 help docs is here (file:///C:/Inetpub/wwwroot/LighthammerCMS/Help/popups/NumberFormatPopup.htm).</P></BODY></HTML> Wed, 06 May 2009 21:12:43 GMT https://community.sap.com/t5/product-lifecycle-management-q-a/number-format-in-grid-cell/qaq-p/5564718 Former Member 2009-05-06T21:12:43Z Re: Number Format in Grid Cell https://community.sap.com/t5/product-lifecycle-management-q-a/number-format-in-grid-cell/qaa-p/5564719#M25344 <HTML><HEAD></HEAD><BODY><P>Nothing changed much other than the WB, it's still the basic java number formatting options (which is probably why the help doc popup looks a bit like a javadoc).</P><P></P><P>I believe the WB has a bug when setting and retrieving a nested comma in the ColumnFormats property, which itself is a comma separated DT property.</P><P></P><P>Use something like this in your PARAM's:</P><P></P><P>0.00,#^^#0.00,MM/dd/yy (just use the double carat for any nested comma and leave the commas to denote column breaks in the list).</P></BODY></HTML> Wed, 06 May 2009 21:20:12 GMT https://community.sap.com/t5/product-lifecycle-management-q-a/number-format-in-grid-cell/qaa-p/5564719#M25344 jcgood25 2009-05-06T21:20:12Z Re: Number Format in Grid Cell https://community.sap.com/t5/product-lifecycle-management-q-a/number-format-in-grid-cell/qaa-p/5564720#M25345 <HTML><HEAD></HEAD><BODY><P>The bug you mention was the source of my consternation. Thanks.</P></BODY></HTML> Thu, 07 May 2009 01:58:46 GMT https://community.sap.com/t5/product-lifecycle-management-q-a/number-format-in-grid-cell/qaa-p/5564720#M25345 Former Member 2009-05-07T01:58:46Z