I do have a problem with the exporting to Excel. It does not matter if a method the build in menu is used. In both cases a table formated as string containing numbers with a decimal separator (it does not matter the attribute is set to "." or ",") will be exported in a false way.
As long as the numbers have more than 2 digigts behind the separator the export will show the numbers in a wrong way (have a look at the attatched picture.
The Text File Export works fine.
In my case the operating system is german and will use "," as the separator.
Is that a bug or did I missed something in the help files?
Thanks for response.
Solved! Go to Solution.
the decimal separator attribute is only relvant for text files and only for number column type.
What happens here is that Excel tries to be smart and derive the data type from the content of the cell. You should see the same behavior when you enter these values manually.
The only work around is to put a ' in front of the string. This tells Excel to use data type text.
Of the better solution is to store numbers in columns of data type real. Then you will always get the right values in Excel independant of the decimal separtor used in the specific locale.
this is interesting.
Coping the table manually to Excel works correct.
I just realized, that the separator is missing in Excel if the string value has more than two decimals after the separator (cf. attachment). Any idea where the separator gets lost?
The hint to use a ' is nice. Thank you. I was thinking about rounding real datatypes to 2 decimals before writing it to the table but I could loose relevant information that way.
The thing is that I do need the table as string, because different information is stored in the same column (reals, integers, objects, etc.). This table is kind of a result table, where all interessting simulation information is written to at the end of a simulation run.
Thanks in andvance!
Does the seperator also get lost if you put a ' in front?
So it's removed by Excel. Just the ' in front to make Excel handle it as text.