Excel export - COLHEAD gives error

[Wei Wang]

When exporting to Excel, if we have a formula that contains COLHEAD (referencing the column headers), the exported file returns a “#NAME?” error where the formula exists. It seems that the body of the formula gets exported into the Excel formula but obviously COLHEAD doesn’t exist as an Excel function so it is returning an error. I would expect that the returned value of the formula should be exported rather than the formula itself.

We also tried using the “exportFormulasAsText” parameter, but when doing so it creates a corrupted version of the Excel file (namely the error below shows when trying to open the file):

‌

[Scott Wiltshire]

A bit of an edge case which we obviously didn't test for.

[tomer ganz]

this has been resolved on 2024.02 release