CFSpreadsheet formatting fails when using documented approach

Question

70 views Asked by James A Mohler At 10 September 2024 at 09:50

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

The formatting option needs to escape the #

To make this work, I needed

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