Custom report

Hi,
When generating an xlsx type report from the plugin. I note that standard fields like number and date type for example, did not seem to be validated, let me explain, if I want to calculate a sum of numbers for example, it's impossible, field seems to be text fields and not standart fields, I must click on each  one by one and validate it with "enter", this seems to be validated the format.

This is not the case if used the standard csv report, your opinion on the subject?

Thanks for your feedback
Regards,

 

Hi,
Thanks for your feedback and advice, I think this is the right solution but I have one last point where I need your technical advice.

If I try to use your solution in simple "xlsx" file with this object : [workelement.tokenBillable;ope=tbs:num]
I confirmed that it's OK.

But when I try to use the solution in my original file with an array. It does not work :#[object.id;block=tbs:row][object.nameClient][object.nameProject][object.nameUrgency][object.tokenBillable;ope=tbs:num]
The row tokenBillable stay empty.

For information I have this kind of error : 2023-06-12 13:51:56.335 ===== TRACE ===== <br /><b>TinyButStrong Error</b> in field &#91;object.tokenBillable...]: item 'tokenBillable' is not an existing key in the array
Thanks for your feedback and help