CFSpreadsheet formatting fails when using documented approach

79 Views Asked by James A Mohler At 20 October 2024 at 01:37

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 best solutions below

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'},