Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

Template report plu...
 
Notifications
Clear all

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

7 Posts
3 Users
0 Reactions
856 Views
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 
[#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 :
 


 
Posted : 29 Jan 2026 19H59
Maxca
(@maxime)
Posts: 274
Active Member Admin
 

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


 
Posted : 12 Feb 2026 16H59
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

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


 
Posted : 21 Feb 2026 21H26
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

Hello,

i use the last V3.1 version.

Regards


 
Posted : 26 Feb 2026 11H22
babynus
(@babynus)
Posts: 14966
Main Contributor 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]

 
Posted : 11 Mar 2026 20H01
jmmbb
(@jmmbb)
Posts: 561
Contributor
Topic starter
 

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...


 
Posted : 24 Mar 2026 17H50
babynus
(@babynus)
Posts: 14966
Main Contributor Admin
 

Issue will be fixed on next version of plugin


 
Posted : 14 Apr 2026 16H20
Share:

Scroll to Top