I have a report that takes an array of records as a table.
It works really well, except if one of the Double values is NAN. Here is the record in question:
(8, 23, 17, 0, 0, 7.47938491860236e-307, 32.0000076591969, 1.69873027156365e-295, 0, +NAN, 1.04301580343872e-309, 1.69876853537201e-295, 1.14945056849938e-305, 8.91746743648873e-85)
Notice the +NAN, indicating that the double value is not a number. Ideally this should be accepted, and the value in that cell should be the equivalent Excel error: #NUM!
I don't know if there is a good way around it. The report uses the <#Table.*> tag, which precludes default values. I don't want to hard code each column because this page in the reports is for displaying diagnostics, and the record fields change often as a result. I'm not even sure if adding defaults would work anyway.
Is there anything I can do to harden the report against NAN values?