Ivor O’Connor

February 22, 2009

Google Spreadsheet Data Validation

Filed under: GOOGLE DOCS, Uncategorized — Tags: , — ioconnor @ 6:40 pm

It is good to see google attempting to supply data validation on the cells of a spreadsheet. See details here:

However it’s only a first start. In my spreadsheet demo yesterday the input for employee tax status could not have been validated. As one person mentioned google’s text validation is more like a check off box. Either the text matches exactly one string or it does not validate. There’s nothing equivalent to a pick list. How long will it take Google to supply a pick list? Or for that matter to verify the numeric dollar amount is withing a certain range? I bet it won’t be long. The question is why did they not include these validations in their first release?


1 Comment »

  1. I agree, why no picklist? It seems ridiculous to not have that.

    Comment by John — September 1, 2009 @ 1:51 pm

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: