Skip to main content
Question

Excelwriter bug?


connecter
Forum|alt.badge.img+4

Hi,

today I have a problem with the excelwriter. I create a simple workflow:

imageThe result in excel:

imageWhy is it insert a comma and not a dot?

The Data Inspector also show different types:

imageBest regards,

Florian

2 replies

ebygomm
Influencer
Forum|alt.badge.img+31
  • Influencer
  • July 21, 2022

The comma is based on the decimal separator set in your system settings in excel. If you set the type to number in the writer you should see a consistent output for all three attributes. What's a bit odd is that the setting of string in the excel writer doesn't seems to give inconsistent results depending on the fme data type when viewed in excel


connecter
Forum|alt.badge.img+4
  • Author
  • August 20, 2022

Sorry for the late answer. 😊

I have test it further and the fme interpreted it wrong or rather it wound't transform correct in the excelwriter. It should be a string. A workaround is the StringFormatter with the "Format String option" of .2f.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings