CFSpreadsheet formatting fails when using documented approach

Question

58 views Asked by James A Mohler At 25 November 2014 at 23:38

If I try to format a cell with

columnFormat = {
    integer = { alignment = "center", dataformat = '#,##0'},

    ...

In Adobe's documentation is says:

enter image description here

I get a

enter image description here

There are 1 answers

**James A Mohler** · Accepted Answer · 2014-11-25 23:38:26

James A Mohler On 25 November 2014 at 23:38 BEST ANSWER

The formatting option needs to escape the #

To make this work, I needed

columnFormat = {
    integer = { alignment = "center", dataformat = '##,####0'},