Excel writer numeric formatting when using property()

There are two previous questions with the answer is "ChangePropertyType", or () (I.e. double, ...).

That is excel is outputting content with the green triangles where the number is being interpreted as text. I'm a bit stuck, because the property value type is the correct value (using debug message), and the green triangles are still there.

The actual workflow I am using ends up being just complicated enough that I have to ask for help.

So I have a table that is getting sent to a worksheet in an excel report writing workbook. The table has a series of defined columns. I have an array that contains the names of the properties, and another array with a value I want to use to format properties.

When I debugmessage the property type of the value of the array #value := property(array[1]); debugmessage(GetPropertyType(#value)); for example the answer is what I expect.

In my text reporting component, I have property(array[1]), some code in the formatting, and the header for the column is set as array[1]. Earlier in the protocol I pivot data, so I'm not exactly sure at design time the names of the columns, and thus why I'm going with the complicated and circuitious route with array properties that have the names of the properties that have the values. Within the same column I do get variance, some of the values will get reported as "NR".

Anyway, I also generate statistics. The statistics end up having very predictable property names. I generate a report, and the columns with the values of interest end up with the green triangles, and the statistics end up fine.

I've tried double, changePropertyType, and the green triangles persist. Is there a another switch that I missed?

So if I set a property equal to property(Array[1]), and use the new property in the green text reporting component, the green triangles disappear. It seems like a bug that property() function is not returning the values correctly to the excel report writer.

https://r1132100503382-eu1-3dswym.3dexperience.3ds.com/?mkt_tok=eyJpIjoiWlRCak5UVmlPVEZoTVdVeCIsInQiOiJrVXlaZ2FIZHhpU3ZJcDRSOVhkaXZcL2FVeEdMWHRlRjZ2citVQlJETEQ5dnNpc0Y2Z2VkekNQR0VvSWNObXh6Qk1lUGxJNXJ4RmY5WDZNdWdoK1laTmlLM0t3ZCtleDQ3cUFLV0xpRm9qSk9zSmxtcGdWQVh4M2FyN0dcL1kzWkZjIn0=&serverId=SwymHttpdTomcatServer_1#community:FV3_L4yySoKZ4k2DYvnQ6Q/iquestion:PFHZ2xfPTJ6BdlejolUGr


Q