Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Navigation
- Tecnomatix
- Forums
- Blogs
- Knowledge Bases
- Groups

- Siemens PLM Community
- Tecnomatix
- Plant Simulation
- Excel Exporting Failure

Options

- Start Article
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-19-2015 12:16 PM

Hi,

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.

6 REPLIES 6

Re: Excel Exporting Failure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-20-2015 02:13 AM

Hello Jan,

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.

Regards,

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Re: Excel Exporting Failure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-20-2015 04:39 AM

Hi Ralf,

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!

Jan

Re: Excel Exporting Failure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-20-2015 05:31 AM

Does the seperator also get lost if you put a ' in front?

Regards,

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Re: Excel Exporting Failure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-20-2015 05:40 AM - edited 08-20-2015 05:43 AM

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-20-2015 05:42 AM

So it's removed by Excel. Just the ' in front to make Excel handle it as text.

Regards,

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Ralf

------------------------------------------------------------------------------------------------------

Did you like the answer? Then click the Thumbs Up button.

Did the answer solve your problem? Then accept the answer as solution.

Re: Excel Exporting Failure

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

08-20-2015 09:31 AM

Hi Ralf,

thank you very much for your help. In my opinion the topic can be closed

Jan

Follow Siemens PLM Software

© 2019 Siemens Product Lifecycle Management Software Inc