Hi,
today I have a problem with the excelwriter. I create a simple workflow:
The result in excel:
Why is it insert a comma and not a dot?
The Data Inspector also show different types:
Best regards,
Florian
Excelwriter bug?
+4
Userlevel 1
+10
- Participant
- 3078 replies
-
21 July 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
+4
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.