Differing Table Tool Output in Designer and Gallery

Question

Hello together,

I ran into a problem when executing my WF on the Gallery. The table rendered to a .xlsx/.pdf carries different values on the Designer vs. the Gallery.

Local WF:

On Gallery:

As you can see, the values are messed up and do not show the actual value when executed on Gallery.

The input into the table tool are double values and are rounded by 0.01 (mentioning this bc. the values seem to cut off a few places and round it then).

I am doing the same thing for five other tables and they work perfectly fine, this is the only troubling one.

I know that I could change it to a string that could solve this, but I'd prefer to input it as a numerical value.

Can not add the WF in here.

FrederikE · Accepted Answer

Solved

The issue that the Input was a .xls file and how that file is read in (comma vs. dot) depends on the computer locale. Since my PC is german but the server is english this caused the problem. Hard to troubleshoot...

AndrewSu · Accepted Answer

@FrederikE , glad that this is resolved for you.

could you please mark this reply as a solutions so that we can cleanup/organize this thread?

That way others can benefit from our collaboration and your findings.

Thanks!