View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - problem with export to open document format - ProjeQtOr
 

problem with export to open document format

More
05 Oct 2022 16:29 - 05 Oct 2022 17:07 #1 by jeanmoulin
Hello
I'm running projeqtor 9.5.5  (update to new version is planned)
I do not have Microsoft Office : only Libre Office
In the 'global parameters' screen the export format is set to Open document
in the ‘users parameters’ screen the export format is also set to Open document
I ask for the export of a reportThe format is Xlsx even if the export parameters are set to open documentI choose to open in Libre office calcI get some garbage caracters , specially in the cells where I am supposed to have numbers

screen shots in the attached file

regards
Attachments:
Last edit: 05 Oct 2022 17:07 by jeanmoulin.

Please Log in or Create an account to join the conversation.

More
07 Oct 2022 10:52 #2 by Arkhanje
Hello !

We're confused because these parameters are only for the HR module and we actually see that the tooltip doesn't mention it at all. This will be done in the next patch.
for character issues it is UTF8 encoding which does not match that of your system. The one we generate is in UTF8 windows format.

Please Log in or Create an account to join the conversation.

More
10 Oct 2022 10:00 #3 by jeanmoulin
Thank you for your answer but I'm sorry I do not fully understand it

I'm running windows 10 on my computer : if projeqtor is generating utf8 in windows format then why do I have a problem opening ths generated xlsx file in Libre Office on a window computer ??
Furthermore when I export csv (projects or activities for instance) they are utf8 as well and I have no probleme opening them with Libre Office

more generaly : why generating a microsoft office format file and not at least giving the user the choice between the microsoft format and the open document format, as it seems that you do in the HR module ? I would think that you would be supporting the open document format rather than the microsoft format !!

regards

Please Log in or Create an account to join the conversation.

More
13 Oct 2022 18:06 #4 by babynus
In fact Arkhanje replied to 2 issues :

1) Export of reports is always in xlsx format, never in odf, even if a global parameter seems to apply to this case : this parameter only applies to HR Dashbord export.
But this is not really an issue as Libre office can open xlsx files.

2) Weird characters are due encoding.
To fit most needs we extract excel with encoding 'CP1252' (corresponding to Windows-1252 charset)
To avoid this, you can set global pamareter "Export CSV files to UTF-8" to YES, to preserve UTF-8 encoding

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
17 Oct 2022 08:47 - 17 Oct 2022 08:48 #5 by jeanmoulin
hello
I agree with you that the export file format should not be an issue since libre office can read .xlsx format.

Sorry but 'Setting Export CSV files to UTF-8 to YES' does not work : this paramameter was already set in my system, I checked (see screen copy attached) and tried again : I still have the problem

So obviously something doesn't work as it is supposed to !

Please note that I upgraded my version to 10.0.6 (not 9.5.5 anymore)

Regards
Attachments:
Last edit: 17 Oct 2022 08:48 by jeanmoulin.

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.051 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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