Wednesday, June 20, 2012

Google Spreadsheets - Automatic Unit Detection?

Earlier today, I was working with a Google Spreadsheet that contained a column of numbers. In one row I entered 50Yd, which the Spreadsheet formatted as text. No surprise there. In another row I entered 10ft, which Google reformatted as 10 Ft and right aligned like a number.

See this example:

See, =isnumber(10ft) is true.

Is it just me, or did Google detect the units on this number? All the other suffixes I tried (in, yd, mi) seemed to fail to trigger this capability. I was really hoping that I could add up various units and have the spreadsheet do the correct math. But alas, this doesn't work. Yet.

A randomly anomaly? Easter egg? Indication of what's to come? What do you make of it?

No comments:

Post a Comment