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,
Custom report exports all fields in standard format.
It is mainly due to Template, as cells contains some text (formula with replacement code), they are considered in standard format.
I don't know if it is possible to export in specific format.
I'll have a look, but am not sure there is a solution
It seems that adding attribute ;ope=tbs:num to the code should do the trick
So you should have something like [object.value;ope=tbs:num]
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 =====
TinyButStrong Error in field [object.tokenBillable...]: item 'tokenBillable' is not an existing key in the array
Thanks for your feedback and help
It is because your refrence "object" is something like a Project I guess.
tokenBillable is a field in WorkElement class, not a field in Project class