View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Template report plugin : numeric values are allways text in Excel or ODS reports - ProjeQtOr
 

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

More
29 Jan 2026 17:59 #1 by jmmbb
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 :
 

File Attachment:

File Name: Listedesdp...ent.xlsx
File Size:12 KB


result :
 

File Attachment:

File Name: resultt.xlsx
File Size:10 KB
Attachments:

Please Connexion or Create an account to join the conversation.

More
12 Fév 2026 14:59 #2 by maxca
Hello,
I'am redording a ticket for this comment, but I'm not sure it will happen.
Have a nice day,

Please Connexion or Create an account to join the conversation.

More
21 Fév 2026 19:26 #3 by babynus
If think it in an old issue we alredy fixed on this plugin.
Which version of the plugin are you using ?

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
26 Fév 2026 09:22 #4 by jmmbb
Hello,

i use the last V3.1 version.

Regards

Please Connexion or Create an account to join the conversation.

More
11 Mar 2026 18:01 #5 by babynus
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]

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
Yesterday 15:50 #6 by jmmbb
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...

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.057 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.