Problem with type Double in Evaluator Column

Help & Support
1

I'm playing around with Evaluator columns and can't get them to work with variables of type double. The most primitive example

x = 1185.15;

return x;

leads to an empty column and the error

Error at line 1, position 13
Unknown value (6): 1185.15

I also tried

x: double = 1185.15;

return x;

and even just

return 1185.15;

with the same result. Other types work just fine. I used 13.5 and now the latest Beta 13.5.5 and I'm not aware of any weird settings I might have changed to influence this.
Am I completely dense or...? :worried:

2

That's pretty odd... all examples work for me.

3

Thanks for trying, lxp.

Just in case this helps: My Windows is set to English but to the regional format "German (Germany)", so by default numbers look like 1.234.567,89. My "Size" column, for example, uses a comma: 5,39 MB.

4

Yep, with "German (Germany)" I see the same error... and there doesn't seem to be a workaround or setting available.

It's strange that this hasn't popped up before, there must be a few users that run the same format :wink:

"German (Switzerland)" works fine, btw.

1 Like
5

The plot thickens... :smiley: Yes, I imagine I'm not the only one with these settings. But using Double values in Evaluator columns may be less typical...

Meanwhile I quickly moved my PC to Australia and "English (Australia)" which did change eg. the date representation in DOpus but it did not change the column issue. Weird.

6

Many thanks for the report. A fix will be in 13.6.1 (first beta after 13.6).

1 Like
7

Using the latest beta 13.6.1 I played around a bit more and entered this:

i = 1 as double / 3;
Output(i);
Output(i as "%.3");
Output(i as "%.2");
Output(i as "%.1");
Output(i as "%.0");
i = 183743933;
output(i as "%.3kb");

The log shows:

 04.05.2024 14:11 Evaluator:  0.333333
 04.05.2024 14:11 Evaluator:  0.3333
 04.05.2024 14:11 Evaluator:  0.333
 04.05.2024 14:11 Evaluator:  0.33
 04.05.2024 14:11 Evaluator:  0.333333
 04.05.2024 14:11 Evaluator:  179.437,435 KB

The Double results seem to be off by one decimal place...
Also note that the filesize is formatted according to my locale (German/Germany), while the other numbers are not.