[IGN-6095]Excel Report saving floats as string

Ignition
1

I have a report using the table component that is saving saving numbers with decimals as strings in Excel, despite properly converting integers to numbers. Compare Cell F8, where the tenths place happens to be 0 to the rest of the column.

Is there any way to force the floats to numbers as well?

ExportAgeOven(16).xlsx (6.1 KB)

2

Not without post-processing (i.e., opening the xlsx, manually changing cell formatting, re-saving). I think this is just an issue with our internal export logic not marking the cell as numeric because the check is too simplistic.