Wrong comma/thousand delimiter/seprator

Help
1

My data source is a simple .xlsx document:

Untitled2

As you can see, I use comma as decimal delimiters (and . as thousand seperators). And I want to keep it that way.

When I execute this workflow:

image
image585×723 15.7 KB

It gives me a result, where it suddenly uses “.” instead of “,” as comma delimiter What is wrong? This is only the case on this machine. On my 2 other machine it doesn’t change it.

image
image1353×955 14.1 KB

This is my Windows 10 settings:

image
image528×755 15.9 KB

And this is my Excel settings (I’ve also tried to untick “Use system seperators” and type them in manually.

image
image1034×848 30.4 KB

I’m interested in a working solution and not a a workaround (like using replace each time etc.).

Please help :grinning:

2

Hi,

Can you try to put Assign activity as the following at the beginning of your workflow?

System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("fr-FR")

Regards,

2 Likes
3

Yep, then it works. But how do I solve it without having to put in an extra assign in each of my workflows?

4

@LauraMM
have a play with the preserve format setting (read range)

5

Sure, but then it’s another workaround. I want to understand, why it doesn’t work on one machine, while the two others works perfectly. All same settings (or at least I think).

6

@LauraMM
technically, internaly a double has defined the decimal seperator as “.” and thats all
the locale representation (e.g. yours) is defining the group seperator with “.” and a decimal seperator with “,” when the double is to be represented as a string.

Regardless on how we want to represent the double as string, internally it rest as it is implemented, is fixed and we do not change.

So, if the locale / different representation of the double is not specified (e.g. via CultureInfo…) then the internal representation will be used. And this is the correct behaviour.

Same we do have with dateTime (internally in the format of MM/dd/yyyy HH:mm:ss and we do not touch the internal structure)

1 Like
7

Hi,

If we can change its behavior by some settings except project / workflow, interoperability of project/workflow among PC might be lower. Unfortunately, for now there is no culture settings in project settings etc. it’s not recommended to change it even if we can change it by any other ways except workflow, I think.

Regards,

8

Ok, but why is there a diference on this machine only and not the two others?

It seems like a pseudo-solution to be honest.

9

@LauraMM
lets continue the discussion once you have checked all the technicals e.g. here:

then we can base on facts and sort it out

10

Yeah, is here any particular paragraph, you think will solve my question? I can’t really find it.

My problem: I have the same settings on 3 computers and yet 1 of them behaves in a different manor. I’m not interested in workarounds or pseudo-solutions.

11

Hi,

I have the almost the same issue but the difference is that my system format is as following :

Decimal separator : .
Thousand separator ,

I put the assign activity at the beginning of my workflow but still not working, i suppose that i should use i culture Info from another region.
Can you please help me to solve it?

Thank you