Number Format in Grid Cell

[Former Member]

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).

[jcgood25 · Accepted solution]

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).

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.

Use something like this in your PARAM's:

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).

[Former Member · Accepted solution]

The bug you mention was the source of my consternation. Thanks.