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
769 Vu
jmmbb
(@jmmbb)
Posts: 561
Contributor
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 Jan PM 19:011
(@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 Fév PM 16:022
(@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 Fév PM 21:022
jmmbb
(@jmmbb)
Posts: 561
Contributor
Début du sujet
 

Hello,

i use the last V3.1 version.

Regards


 
Posté : 26 Fév AM 11:022
(@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 Mar PM 20:033
jmmbb
(@jmmbb)
Posts: 561
Contributor
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 Mar PM 17:033
(@babynus)
Posts: 14952
Membre Admin
 

Issue will be fixed on next version of plugin


 
Posté : 14 Avr PM 16:044
Share:
Retour en haut