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.

Replace comma vs do...
 
Notifications
Clear all

Replace comma vs dot excel export

7 Posts
2 Users
0 Reactions
11.4 K Views
(@fgaillet)
Posts: 3
Active Member
Topic starter
 
[#1879]

Hi,

I'm a french user of ProjeQtor.
When I use excel export, the decimal separator of data exported is dot.
I don't want to change my excel configuration.
Is it possible to change the decimal separator for all excel's export with coma ?

Regards


 
Posted : 27 Jun 2014 14H50
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Yes, in global parameters screen.


 
Posted : 27 Jun 2014 15H06
(@fgaillet)
Posts: 3
Active Member
Topic starter
 

I think there is a confusion....... :whistle:
I don't want to change the "separator for csv files" but change in the file exported the decimal separator....

Thank you


 
Posted : 27 Jun 2014 16H43
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Hi,

Sorry, confusion :sick:

No, no way to change decimal point.


 
Posted : 27 Jun 2014 17H41
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Request registered to propose a solution


 
Posted : 27 Jun 2014 17H43
(@fgaillet)
Posts: 3
Active Member
Topic starter
 

HI,
I've seen that the ticket #1420 (Parameter decimal point for exports) was fixed in v4.3.2
I don't know where to change this parameter ....
After the installation of the new version, in excel's export file I have now.....(see attached files)


 
Posted : 08 Jul 2014 14H49
babynus
(@babynus)
Posts: 14957
Main Contributor Admin
 

Hi,

Decimal point is based on locale format.
This means that on the interface you see amounts with decimal as comma, it will be exported this way.
A new parameter could come soon as this point lead to some quesitons and issue.
For instance, if you export with a comma, import of this file will fail as point is expected. This will be fixed, but maybe parmetering will fit better.

Display of type for integer values is an issue that will be fixed in patch 4.3.3
Coming very soon.


 
Posted : 08 Jul 2014 21H04
Share:

Scroll to Top