Not seeing a NaN when expected on initial import

[tfmorris]

Original author: PaulMake...@gmail.com (May 10, 2011 17:48:18)

What steps will reproduce the problem?

1. Import the attached file (containing simply the number 0 and a header)
2. Edit cells -> Transform: value / value

What is the expected output? What do you see instead?

Expect to see NaN - see instead null.

What version of Google Refine are you using?

2.0

What operating system and browser are you using?

Windows Chrome

Please provide any additional information below.

If I transform the column to text and then back to numbers I get the expected NaN as though the initial import missed something in construction.

Original issue: http://code.google.com/p/google-refine/issues/detail?id=377

[tfmorris]

From dfhu...@gmail.com on May 10, 2011 20:59:12:
Paul, in the Transform dialog box, at the bottom, what choice did you specify for "On error"?

[tfmorris]

From PaulMake...@gmail.com on May 10, 2011 21:22:24:
I'm actually looking at the value in the preview pane, even before submitting it.

Interestingly, when submitting it, I see "Text transform on 0 cells in column number: grel:value/value" -- it's not applied to that cell. (This happens regardless of the "On error" setting.)

I can induce a NaN to appear with value.toString().toNumber()/value

[tfmorris]

From dfhu...@gmail.com on May 12, 2011 17:48:37:
I'm seeing an exception thrown, too.

[wetneb]

To rephrase this issue: 0 / 0 should evaluate to NaN in GREL.

[thadguidry]

It's really nice to see this issue finally closed after all these years. It pops up for me every now and again. So, many thanks @elroykanye for fixing this.

[elroykanye]

It's really nice to see this issue finally closed after all these years. It pops up for me every now and again. So, many thanks @elroykanye for fixing this.

😁