Jump to content

Output csv file for Excel in German version of decimal "comma"


Recommended Posts

Posted
The output file in CSV format generates values with decimal point "." (12.5). If I want to use these values of the output file in a German version of Excel I get problems because there, the decimal point is used as "," (12,5). Is there any chance to create an output file which is compatible with Excel in the German Version?
Posted

PVsyst does not foresee to use decimal commas. You will need to set set decimal dots in Windows or in Excel:

 

  • For Windows 8 you find the setting in: 'Region -> Formats -> additional Parameters -> Numbers' . You need to restart Excel for this to take effect.
  • In Excel you find the setting in 'Options -> Advanced -> Editing Options'

After importing the file you can change back to decimal commas.

Posted

This is indeed on our ToDo list since a long time...

We will provide the opportunity of producing comma decimal characters when exporting CSV and Copy/Paste operations in a next version very soon (not necessarily the next one).

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...