Forum

Template report plu...
 
Notifications
Retirer tout

Template report plugin : numeric values are allways text in Excel or ODS reports

7 Posts
3 Utilisateurs
0 Reactions
768 Vu
jmmbb
(@jmmbb)
Posts: 561
Noble Member
Début du sujet
 
[#10051]

Hello,

i face a issue that is an large irritant.
When making an custom template reprot via plugin, numeric values are allways convert to text (even if i use ;type=num in field's arguments) so, no calculation or croos table is possible without a large time of post-treatment (changing avery cell type....).

The worst is for Amount flieds, where html code is added, that is good for text or word, but the worst for Excel (it corrupt the file !).

Expect to be clear, i set an example :
Template :
 

result :
 


 
Posté : 29/01/2026 7:59 pm
(@maxime)
Posts: 268
Membre Admin
 

Hello,
I'am redording a ticket for this comment, but I'm not sure it will happen.
Have a nice day,


 
Posté : 12/02/2026 4:59 pm
(@babynus)
Posts: 14952
Membre Admin
 

If think it in an old issue we alredy fixed on this plugin.
Which version of the plugin are you using ?


 
Posté : 21/02/2026 9:26 pm
jmmbb
(@jmmbb)
Posts: 561
Noble Member
Début du sujet
 

Hello,

i use the last V3.1 version.

Regards


 
Posté : 26/02/2026 11:22 am
(@babynus)
Posts: 14952
Membre Admin
 

Just need to use good syntax, which is ;ope=tbs:num
Example (on Requirement Matrix - updated for next version of plugin)

[object.countTotal;ope=tbs:num]

 
Posté : 11/03/2026 8:01 pm
jmmbb
(@jmmbb)
Posts: 561
Noble Member
Début du sujet
 

Hello,

with ope=tbs.num i get the value 63000,00 &nbps;€ instead og 63000 in cell, so value is non numeric and can't be summed for example...


 
Posté : 24/03/2026 5:50 pm
(@babynus)
Posts: 14952
Membre Admin
 

Issue will be fixed on next version of plugin


 
Posté : 14/04/2026 4:20 pm
Share:
Retour en haut