Excel export (Filter Values) - number format does not export for adhoc columns

We noticed this issue on both the latest v2024.02 FP1 and an earlier release from last year v2023.05 FP1. When we try to do a formatted Excel export (w/ filtered values), we lose any number format applied to adhoc formulas cells defined in Apliqo. Not sure if this was ever working on previous versions (or if its a feature that was never expanded to include adhoc formulas).

To replicate, use Apliqo_Demo → Simple Planning (a2.v2)

insert a column to the left of Jan
use "0.0" as the numberFormat and appliedNumberFormat under columnMap
add the following under columnFormat

"4": [
        {
          "numberFormat": "0.0"
        }
      ],
"5": [
        {
          "numberFormat": "0.0"
        }
      ]

export to Excel with Filter Values
in the Excel file, notice that the inserted column still formats with 2 decimal points but the Jan column formats as defined

‌

Comments (1)