Not seeing a NaN when expected on initial import

[GoogleCodeExporter]

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 reported on code.google.com by paulm%pa...@gtempaccount.com on 10 May 2011 at 5:48

Attachments:

• zero.txt

[GoogleCodeExporter]

Paul, in the Transform dialog box, at the bottom, what choice did you specify 
for "On error"?

Original comment by dfhu...@gmail.com on 10 May 2011 at 8:59

[GoogleCodeExporter]

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

Original comment by paulm%pa...@gtempaccount.com on 10 May 2011 at 9:22

[GoogleCodeExporter]

I'm seeing an exception thrown, too.

Original comment by dfhu...@gmail.com on 12 May 2011 at 5:48

• Changed state: Accepted